[Snippet] Allow mysql root access from anywhere
Posted on March 18, 2010
A small annoyance of mine is on local development servers, I can't login to the MySQL server as root.
Simply connect the mysql shell
mysq
- mysql -u
Then,
- GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '[A PASSWORD]'
Exit and you're done.
Related posts
- MySQL Root Password on cPanel
Wheres the MySQL root password in cPanel installs? Easy, look in /root/.my.cnf... - Upgrading to MySQL 5.1 in cPanel/WHM
Upgrading to MySQL 5.1 in cPanel is currently not the easiest thing in the world.... - Repair and optimize all tables in all MySQL databases
MySQL tables can crash or become corrupt quite easily if you don't shut down the... - MySQL Server on CentOS, what the RPM doesn’t do for you
Installing MySQL via YUM Once the updates have finished we will be ready to install... - MySQL 5.0 or 5.1 to 5.5 Upgrade Traumas on CentOS
Ignoring all the panic-mongers on the rest of the internet upgrading MySQL from 5.0 or 5.1...
