Mar 6, 2012

Remote Access MySql root user

--1--
login to mysql with root user
mysql -u root

--2--
and type command below :
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
mysql> flush privileges ;
mysql> exit;

that's all and try to connect remotely

0 comments:

Post a Comment

comment please ...