Topic: SQL Connection using EMS SQL Manager

[Mizou]

I am using sme 5.6 with xp clients installed with EMS SQL manager.

I don't have a problem accessing MYSQL via putty and I also use phpmyadmin without any probs.

I found the EMS SQL Manager to be a very useful tool for what I am working on, but I cannot get it to connect to my sme box / host.

I have used 'mydomain.com.au' , my server IP Address of '192.168.89.1' as well as 'localhost' to try to connect to mysql, but I keep getting a "can't connect to mysql server on 'localhost' 10061" message. I have used various user name of root, admin etc... with and without password and still no luck....

Is anyone else using this EMS SQL Manager and have you got an idea of what I am doing wrong...

Cheers

Mizou

[Jan Rozema]

Did you check port 3306, is it open, some provider block 3306, the standard port which MySql is using to connect over a tcp/ip network.

Jan R/

[Kobus Bensch]

I have a similar problem trying to use DBManager and ODBC.

Get the following errors
Lost connection to MySql Server during connection

and another error of

Loading Server fsl@10.10.10.2 (MySQL): Lost connection to MySQL server during query.

Help would be greatly appreciated.

[Boris]

Two thinks to check:
1. make sure glibc and glibc-common updated to the latest available for RH7.3
2.Using phpmyadmin or command line create the database user with permissions to login from your workstation's IP. By default root allowed to connect only from server itself, hence phpmyadmin works.

[Hugo]

My problem is identical to Mizou's. Only I use SQLyog as sql applic.
No problem connecting to the 5.5 box. The 5.6 installation is updated SR5 ...
Should I still check glibc and glibc-common?
TIA
Hugo

[Boris]

glibc update for SME 5.6 solves network mySQL connections problems.