Hi
I’ve been trying to connect to MySQL but I am unable.
This is how I go about the setup:
0 - I retrieve the MySQL root password in: /root/.digitalocean_password 1 - I set up 2x A records 3x NS records 2 - I out comment the bin-address or change it to 0.0.0.0 in the MySQL config 3 - I log in to MySQL: mysql -u root -p
In step 3 is it normal that any password works?, and not only the one provided by the digital ocean one click service? as the MySQL root password?
4 - Within the MySQL terminal i: 4.1 - CREATE USER ‘myname’@‘myip’ IDENTIFIED BY ‘password’; 4.2 - GRANT ALL PRIVILEGES ON * . * TO ‘myname’@‘myip’; 4.3 - FLUSH PRIVILEGES; 4.4 - quit
In step 4, myip is my own IP, right? like ‘75.252.532.561’?
5 - Open up HeidiSQL and set the settings like: 5.0 Network MariaDB OR MySQL (TCP/IP) 5.1 Hostname / IP = My servers IP 5.2 User = myname 5.3 Password = password 5.4 Port = 3306
I tried restarting MySQL, I tried many different things, but the above I think is the correct way to set it up?.
However, I am unable to login… there is not set a firewall and I don’t get it.
I’ve read several articles, questions, answers, solutions, etc etc…
I get this error code 10060 with the message Can’t connect to MySQL server on ‘myserverip’ (10060)
Can someone please help me out here?
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!
Hi there @webwizard,
The steps that you’ve taken look correct. I could suggest a few extra things:
- Make sure that your MySQL is actually binding on
0.0.0.0:3306by running this command:
- netstat -plant | grep 3306
Feel free to share the output here.
- If you have a dynamic IP address, this might explain the problem that you are seeing. I would recommend visiting this site here and making sure that you’ve used the correct IP address when creating your MySQL user:
- If you have a dynamic IP address, there are a couple of ways to solve the problem:
- Either use a wildcard and grant access to the whole IP range when creating your user:
CREATE USER 'myname'@'75.123.123.%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'myname'@'75.123.123.%';
FLUSH PRIVILEGES;
That way if your IP changes you would still be allowed to connect as long as your new IP is from the same range.
- Rather than accessing MySQL directly, use SSH tunnel, you can that by following the steps from this tutorial here:
Hope that this helps! Regards, Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.