15

I download mysql installer here:

http://dev.mysql.com/downloads/installer/

And then I downloaded MySql WorkBench.

At workbench's connection configuration I put hostname as "127.0.0.1", port "3306", user: "root", password is empty. I click "test connection" and it gives me this error:

"Can't connect to MySQL server on '127.0.0.1' (10061)"

What am I missing?

Improve this question
5
  • 1
    I updated the download link. Commented Dec 12, 2013 at 13:02
  • 1
    Press windows+R--> type 'services.msc'-->find mysql-->click on it--> click on 'start' appears on left Commented Dec 12, 2013 at 13:03
  • 1
    I noticed that this service is not installed! Commented Dec 12, 2013 at 13:05
  • 1
    You've probably installed mysql but didn't start the service. The command to start the service is mysqld. What OS are you using? Commented Dec 12, 2013 at 13:05
  • 1
    I am using Windows. I've already searched the service twice. I will search again. Commented Dec 12, 2013 at 13:06

3 Answers 3

Reset to default
13

See here for starting the service and here for how to make it permanent. In short to test it, open a "DOS" terminal with administrator privileges and write:

shell> "C:\Program Files\MySQL\[YOUR MYSQL VERSION PATH]\bin\mysqld"
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

7

Consider using the MySQL Installer for Windows as it installs and updates the various MySQL products on your system, including MySQL Server, MySQL Workbench, and MySQL Notifier. The Notifier monitors your MySQL instances so you'll know if MySQL is running, and it can also be used to start/stop MySQL.

Improve this answer

Comments

2

removing temp files, and did you restart the computer or stop the MySQL service? That's the error message you get when there isn't a MySQL server running.

Improve this answer

5 Comments

yeah! I noticed that I don't have any service related to MYSQL. Shouldnt the installer install it?
Not sure about that, might be fixed if you re-install the software.
The installer will install the service if while installation you have checked the check box named as mysql install as service
I will check that option, but I installed using the Full option.
this box doensn't exists.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.