Friday, 22 April 2016

How to connect remotely to MySQL with the standard "root" user ?


$ mysql -u root -p

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'xxxxxxx' WITH GRANT OPTION;

Remember you need to create an account with your IP (xxx.xxx.xxx.xxx) as host,
this tells MySQL that this user with this IP has permission to remotely access the Database.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.