How to use Grant and Revoke commands in MySQL

Поделиться
HTML-код
  • Опубликовано: 3 окт 2020
  • In my previous video , I have told you how to install MYSQL in windows.
    In this tutorial, I will be showing you how to use DCL commands in MYSQL :
    Creating new user
    Grant
    Revoke
    User Switching
    Making super user
    Account lock and unlock
    password expire
    So, let's get started without wasting time :)

Комментарии • 20

  • @dragnar4743
    @dragnar4743 Месяц назад

    The video was very helpful and informative. Thanks :))

  • @ishwarmise
    @ishwarmise Год назад +1

    your explanation is very nice thanks for helping us to grow our knowledge ....

  • @MohitSaini-qf7cz
    @MohitSaini-qf7cz 2 года назад +1

    Thanks. it was very helpful

  • @jollynikhade1701
    @jollynikhade1701 3 года назад +1

    Thanks for the explanation, it is useful.

  • @yashsinghal7471
    @yashsinghal7471 8 месяцев назад +2

    Thanks 🙏🙏🙏🙏

  • @guhanprasath6117
    @guhanprasath6117 2 года назад +1

    thank you so much sir ,for your very well explanation

  • @user-fy4me4dn7v
    @user-fy4me4dn7v 8 месяцев назад

    hi Ajay this leacher is a very helpful for us thankyou.

  • @nehavishwakarma2667
    @nehavishwakarma2667 3 года назад +1

    explained very well. Thanks

  • @Sudhanshusable98
    @Sudhanshusable98 2 года назад

    thank you sir it is very useful. 🙏🙏

  • @shrikantkulkarni5550
    @shrikantkulkarni5550 2 года назад +1

    Excellent.

  • @teknathjha227
    @teknathjha227 3 года назад +1

    Great 👌

  • @dini3776
    @dini3776 9 месяцев назад

    ❤❤❤❤❤❤❤❤❤You are such a god❤❤❤

  • @ParveenKumar-zk6pk
    @ParveenKumar-zk6pk 8 месяцев назад +1

    User switching mein problem a rahi hai please tell the solution

  • @ParveenKumar-zk6pk
    @ParveenKumar-zk6pk 8 месяцев назад

    System MySQL mein error show kar raha hai

  • @mshilpa9897
    @mshilpa9897 2 года назад

    System mysql -u ajay -P command is not working in workbench what is the issue

    • @kush34100
      @kush34100  2 года назад

      It should work . system mysql -u root -p Enter this command and give password which u gave at time of installation of MySQL.

    • @kush34100
      @kush34100  2 года назад

      ajay is user name which i created in my system . U need to specify ur user name which u created . system mysql -u -p

    • @abusaeed8565
      @abusaeed8565 2 года назад +1

      @@kush34100 It does not work in MySQL workbench. Is there any other way?

    • @historywithreese
      @historywithreese Год назад

      @@abusaeed8565 It works on shell. In workbench, you can click on 'Administration'->Users and Privileges. There, you can add users, set privileges from them easily without running any commands.