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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
In <b>/etc/mysql/my.cnf</b>, what do you have currently for the <code>bind-address</code> parameter? I think it needs to be set to the public IP address of your droplet.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.