Rodolfo Bandeira

Rodolfo Bandeira

software, electronics, security, devops, thoughts

How to enable remote root access in MySQL

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

Last modified:

LinkedIn
WhatsApp