MySQL set up a connection not working?

Question

I have been having issues with trying to set a new connection on MySQL. I continue to get two errors: "Cannot Connect to Database Server", and "Failed to Connect to MySQL at 127.0.0.1:3306 with user "(username I typed)". I have downloaded the most current MySQL Server 8.0.40 as well as the MySQL Workbench.

I have been working on this for around 12 hours today (taking breaks). I want to solve this issue.

Please see my screenshots attached of the issues I am having, and me trying to solve, hopefully you can see them.

Thank you,

Tara G.

Answer 1

Hi Tara!

Thanks for reaching out.

Thank you for providing multiple screenshots.

There are several potential reasons for encountering an error in this situation. Can you please answer the following questions, so that we can assist you better?

1. Please ensure you are referring to the correct connection (nativeuser in your case). Please note that you are not obliged to use this one, you can stick to using root.

2. Please ensure you have typed the correct password. If you are using several keyboards, please ensure you are typing the password using the correct one.

3. Verify the localhost and the port are the same number as expected (something we cannot deduct from the Manage Server Connections window from the screenshot you have provided.

4. Ensure port 3036 is not blocked from your Firewall.

5. If none of these works, consider reinstalling Workbench (and if it doesn't work, consider downgrading (i.e. installing an archived, slightly older version).

To do that, please follow the step-wise approach explained here:

https://learn.365datascience.com/question/i-have-a-problem-with-mysql-installation/

Solving this issue might take several steps, but please try to implement every step we suggest and report back with screenshots. Thus, we are supposed to get Workbench working for you.

Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin

MySQL set up a connection not working?

Submit an answer

related questions