Failed to Connect to MySQL at 127.0.0.1:3306 with user root

Question

0.00/5 (No votes)

See more:

I have an error in mysql workbench for connect to the database server

Failed to Connect to MySQL at 127.0.0.1:3306 with user root

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Now i using linux ubunutu operating system and please give me sugesstion for that can't connect to server......
Please give me suggestion........

Posted 30-Jan-13 1:09am

prabu kanagaraj

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

markkuk · Answer 1 · 2013-01-30T01:40:00

1. Check that the MySQL server is installed and running
2. Check that the MySQL server is configured to listen for TCP connections in addition to Linux domain socket connections
3. Check that the MySQL user "root" (not the same as Linux "root"!) has the right to connect to the database from host 127.0.0.1

Swarnendu09 · Answer 2 · 2013-01-31T07:47:00

Solution 2

check whether u are using correct mysql connector jar in classpath.

Posted 31-Jan-13 7:47am

Swarnendu09

Comments

markkuk 1-Feb-13 14:37pm

MySQL Workbench isn't written in Java, so your answer is completely irrelevant.

Member 15457941 · Answer 3 · 2021-12-06T13:52:00

Solution 3

Double click the windows(or others) icon, find and click MySQL installer --, click the MySQL server configuration item quick action (if there is no MySQL server, click add on the right to find and add it), and then follow it foolishly

Posted 6-Dec-21 13:52pm

Member 15457941

Updated 6-Dec-21 13:53pm