Jump to content
  • 0

error with MySQL please help


TheLibra

Question


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   0
  • Joined:  12/12/12
  • Last Seen:  

1grw9v.png

I get this error whenever I try opening a connection with mysql. I just installed it for the first time on this computer, haven't changed any settings, the only thing I did was click "New Connection" under the left server box in mysql. Then I entered the settings you see in the last box in the pic above (with a pass ofcourse). But it doesn't even let me enter the pass when I try to open the server before it gives me the connection error. How could I have done something wrong? I've used mysql before, and I don't remember having to tweak any settings besides for port forwarding in order to connect. Am I forgetting something?

Link to comment
Share on other sites

11 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   0
  • Joined:  12/12/12
  • Last Seen:  

Is your SQL Server running?

What do you mean? I'm using workbench to try to open a localhost connection.

If you're asking if it continues on to open the connection after I get that error, then no. I click ok, and I'm back at the main workbench window.

Edit: I tried putting as much information as I could in my first post, the only thing I didn't think of, is what version of mysql I am using. I'm using MySQL workbench version 5.2 I believe. If you need any other information more then this, let me know.

Edited by TheLibra
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  

Error 10061 indicate that your MySQL server is not running properly. Try restarting your MySQL server and see if that helps

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   0
  • Joined:  12/12/12
  • Last Seen:  

I don't get what you mean... of course the server is not running properly, I keep getting this error, so I can't run it. lol. I've tried closing mysql workbench and re-opening it, but it gives me the same error.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  

I recommend you use something AIO like xampp or VertrigoServ but in your case you need to kill mysqld.exe from your Task Manager and run it again (don't forget to click on "Show processes from all users")

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   0
  • Joined:  12/12/12
  • Last Seen:  

oooh yea, xampp i've used before. You need that to run the mysqlserver don't you?

Edit: Yup, I just downloaded and installed Xampp and tried mysql workbench again and it got past the error. Problem solved. I'm stupid. Sorry for wasting your guy's time =P Is there a way to delete/close this thread?

Edited by TheLibra
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  439
  • Reputation:   29
  • Joined:  12/08/11
  • Last Seen:  

You don't have to. A tag will be added by a Mod.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  123
  • Reputation:   4
  • Joined:  11/21/11
  • Last Seen:  

try typing "services.msc" in the run command, see if mysql daemon is running

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

oooh yea, xampp i've used before. You need that to run the mysqlserver don't you?

Edit: Yup, I just downloaded and installed Xampp and tried mysql workbench again and it got past the error. Problem solved. I'm stupid. Sorry for wasting your guy's time =P Is there a way to delete/close this thread?

You don't have to. A tag will be added by a Mod.

Please put a [solved] tag on the tag box. Kindly help the moderators too~ :)

*It's a help for the moderators and comers who would like to help, so they can skip solved problems. either way, it's not painful for you, is it?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   0
  • Joined:  12/12/12
  • Last Seen:  

Please put a [solved] tag on the tag box. Kindly help the moderators too~ :)

How do I do this? I'm new to the forums, and don't know the controls or anything.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

just click on the "edit" on the first post and you can found them there..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...