Cannot connect to mysql server

garyg007 · 11-25-2008, 09:13 PM

I've just installed a mysql gui - windows app run using wine.
It starts up fine, but when I try to connect to a database I get the error

Quote:

Error No.2003
Can't connect to Mysql server on 'localhost' (10061)

(the gui is SQLyog Community Edition)
I believe the mysql permissions have been taken care of. I can log into Mysql and access the database from the konsole.

What am I missing?

Gary

datopdog · 11-26-2008, 02:37 AM

It could be that your mysql is only listening to the unix socket, check to see if it is listening to TCP on the localhost. But why are u using sqlyog when mysql provide a similar tool that works on linux.

jschiwal · 11-26-2008, 02:42 AM

You may have the same tools with the mysql-gui-tools package. For adninistration, mysql-administrator is very good. Also check if the firewall on either the client or server is blocking traffic. Also check if the mysql service is running on the server.

r3sistance · 11-26-2008, 07:56 AM

You can open up a terminal and type "mysql" to open the command line client, if this errors the error message should supply better information, if not then this might be a bit of a tricky one.

datopdog · 11-26-2008, 08:03 AM

@r3sistance now why would he do that ? He has already stated in the ticket that he can connect from the console.

garyg007 · 11-26-2008, 11:16 AM

Quote:

Originally Posted by datopdog

But why are u using sqlyog when mysql provide a similar tool that works on linux.

I took a look at that, and it looked like it would take a master rocket scientist to install it

Quote:

Originally Posted by jschiwal

Also check if the firewall on either the client or server is blocking traffic. Also check if the mysql service is running on the server.

Mysql Client and server are both running on the same host. Since I can access from console, what does the firewall have to do with it?

Quote:

Originally Posted by r3sistance

You can open up a terminal and type "mysql" to open the command line client, if this errors the error message should supply better information, if not then this might be a bit of a tricky one.

If you will read my original post, you will see that I stated that I had NO trouble accessing mysql from a console

datopdog · 11-27-2008, 03:36 AM

Have you checked if your server is binding to TCP ?

garyg007 · 11-28-2008, 10:37 AM

Quote:

Originally Posted by datopdog

Have you checked if your server is binding to TCP ?

How do I do that?

However, I am in the process of removing all reference of mysql from my system and am going to start over installing mysql.

I tried to install mysql-qui-tools, and ran into a bit of a mess. Some of the pre-reqs were available as slackbuilds and some were not. Mysql is not available as slackbuild. Where a slackbuild was not available I installed from source - using "checkinstall" to create a slackware package. Some worked some did not. So what I ended up with was a lot of stuff that had been installed from slackbuilds, and source and some of the source using checkinstall and some using "make install" When I got done I ended up not being able to access mysql from either the mysql-guy or from command prompt.

Gary