How to enable remote root access in MySQL

Feb 17, 2014 · 1 min read

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