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

Share :

Tweet

More

Related Post

• script : kill slow MySQL queries--muqodimah---Hello everyone, this time i will share simple script to kill long query of MySQL.&nbs