Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’

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.

Leave a Reply

Your email address will not be published. Required fields are marked *