MySQL root access from all hosts
1 min read

MySQL root access from all hosts

Grant privileges. As root user execute after

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

bind to all addresses:

The easiest way is to comment out the line in your /etc/mysql/my.cnf file:

#bind-address = 127.0.0.1

Enjoying these posts? Subscribe for more