Help! I’m getting access denied trying to access a remote / local MySQL database

Sometimes when you try to access MySQL, you will get an access denied message. There could be a multitude of reasons but if you are coming from a remote host, you could try execute the following command on the database server:

grant all privileges on database_name.* to ‘user’@’remote_ip or localhost’ identified by ‘YOUR_PASSWORD’ with grant option;

Tags

Share this article

Leave a Reply

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

Scroll to Top