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 (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

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.

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.

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.

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

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

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?

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

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