$ 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.