How to get all privileges back to the root user in MySQL

Question

I am using MySQL  My root user doesn t have all privileges  How can I get all privileges back to the root user  How to do it step by step

User · Answer

If you facing grant permission access denied problem, you can try mysql to fix the problem:

grant all privileges on . to root@'localhost' identified by 'Your password';

grant all privileges on . to root@'IP ADDRESS' identified by 'Your password?';

your can try this on any mysql user, its working.

Use below command to login mysql with iP address.

mysql -h 10.0.0.23 -u root -p

User · Answer

This worked for me on Ubuntu   Stop MySQL server    etc init d mysql stop   Start MySQL from the commandline    usr sbin mysqld   In another terminal enter mysql and issue   grant all privileges on     to  root      with grant option    You may also want to add  grant all privileges on     to  root   localhost  with grant option    and optionally use a password as well   flush privileges    and then exit your MySQL prompt and then kill the mysqld server running in the foreground   Restart with   etc init d mysql start

User · Answer

Log in as root  then run the following MySQL commands   GRANT ALL PRIVILEGES ON     TO  root   localhost   FLUSH PRIVILEGES

User · Answer

If you facing grant permission access denied problem, you can try mysql to fix the problem:

grant all privileges on . to root@'localhost' identified by 'Your password';

grant all privileges on . to root@'IP ADDRESS' identified by 'Your password?';

your can try this on any mysql user, its working.

Use below command to login mysql with iP address.

mysql -h 10.0.0.23 -u root -p

[mysql] How to get all privileges back to the root user in MySQL?

Examples related to mysql

Examples related to privileges