Rodolfo Bandeira
Home Blog Posts Photos Videos Github Contact
<< All Posts
How to enable remote root access in MySQL

Feb 17, 2014


First you must to connect to your mysql server:

mysql -h localhost -u root -p</pre>

After this, you have to grand privileges:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

And then, you have to restart the mysqld service.

service mysqld restart

Rodolfo



<< All Posts

Previous post:
How To Install Linux, Apache, MySQL, PHP (LAMP) on CentOS 6
Most recent post:
How to enable federated engine in MySQL

rodolfo.io 🇧🇷 🇨🇦

Runs on OpenBSD 🐡
Twitter Github Linkedin RSS