Hey guys, im new to mySQL and i’m trying to connect to the server. I set up a one-click install of mySQL and i’m trying to connect through my Macbook (Terminal) by putting the command found in the the “Flags” section. However, when executed i get this error message and i have no idea what it means or how to solve it. Can anybody help me with this?
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!
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.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Hi @yannbohbot,
Can you please confirm the exact command you are trying to use to connect to your MySQL?
Additionally, please make sure, you’ve allowed traffic of your IP to the MySQL port. The Port MySQL usually uses is 3306. You can check that from your droplet.
Additionally, if you ssh to your droplet, can you enter MySQL from there?
To do so, do the following
Once you are in, type in
And see if you would be logged in.
If you aren’t, check if MySQL is running with the following commands
Or with
Check if anything is running on port 3306 at all. If MySQL is actually running, you’ll need to allow your IP to access the specific port.
In most cases following simple rule opens TCP port 3306:
However I won’t recommend that, I’ll recommend just allowing your IP like
Please remember to change XXX.XXX.XXX.XXX with your actual IP address.
Regards, KDSys
I don’t think that you’ve done anything incorrectly, @yannbohbot. Have you successfully connected to this DB instance before?
The error you pasted above seems to be related to SSL
You might try downloading the CA cert from the control panel and addressing it in your command such as;
Also check the Logs/Queries tab in the control panel do you see anything in the bottom panel suggesting a problem?