[MySql] External Connection to MySql

mysql -u root -p

input password


mysql>grant all privileges  on *.* to 'root'@'%' identified by 'password';
mysql>flush all privileges;


then restart mysql like  : mysqld restart

if it does not work edit mysql.conf (mysql.ini) and restart.

//bind 127.0.0.1 ---> comment this .