Table of Content

You have to put this as root:

GRANT ALL PRIVILEGES ON *.* TO ‘USERNAME’@’IP’ IDENTIFIED BY ‘PASSWORD’;
where IP is the IP you want to allow access and USERNAME is the user you use to connect

If you want to allow access from any IP just put % instead of your IP

and then you only have to put

FLUSH PRIVILEGES;
Or restart mysql server and that’s it.

Last modified: 20.01.2018

Author

Comments

Write a Reply or Comment

Your email address will not be published.