mysql –password=xxxxxxxxxxxxx
GRANT ALL PRIVILEGES ON *.* TO root@192.168.221.5 IDENTIFIED BY 'xxxxxxx';
or
or
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xxxxxxxx';
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 or 185.54.81.20
and restart mysql
service mysql restart
To check where mysql service has binded execute as root:
netstat -tupan | grep mysql