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

Previous
Next Post »

comment please ... ConversionConversion EmoticonEmoticon

Thanks for your comment