cPanel & WHM Version 82 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!
 
This object is in archive! 

Make "MySQL Root Password" auto-repair the root grant

cPDavidNielson shared this idea 5 years ago
Open Discussion

Sometimes, root can't access MySQL because /root/.my.cnf contains a wrong password, or no password. But sometimes it's because the root grant is missing or broken:

- user 'root' might not exist

- grant might be for 'root'@'*' instead of 'root'@'%'

- "super" or "grant" privileges might be missing


It wouldn't be hard, in an automated way, to make sure that the necessary root grants are in place and configured correctly, and it would be extremely helpful to system administrators and support personnel.


More info below. This is not a complete list of grants that have to exist, but it's enough to get started.


http://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-users-full-privileges

http://stackoverflow.com/questions/1708826/how-to-get-all-privileges-back-to-the-root-user-in-mysql