Question

Unable to access remote database from my localhost

Posted August 12, 2013 4.5k views
I current have a database on my VPS, I am trying to connect to it from my MacBook but unfortunately I am failing. I have opened port 3306. I have also granted privileges for a user; GRANT ALL PRIVILEGES ON myDatabaseName.* TO ‘root’@'myIP' IDENTIFIED BY 'Pa55word'; In my database configuration on my MacBook I have the following; define('DB_NAME', 'myDatabaseName'); define('DB_USER', 'root'); define('DB_PASSWORD', 'Pa55word'); define('DB_HOST', 'vpsIP'); Unfortunately I am still receiving the error; Error establishing a database connection Am I doing something wrong?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
In /etc/mysql/my.cnf, what do you have currently for the bind-address parameter? I think it needs to be set to the public IP address of your droplet.
Thank-you Pablo, that was it! It was commented out.
Submit an Answer