Topic: Problems connecting MySQL Administrator to SME 6.01-01

[Rien]

Hi,

If I try to connect to the MySQL server on my SME-server with MySQL Administrator installed on my WIN2000 client, I get the message:

Could not connect tot the specified instance
MaSQL Error Number 2003
Can't connect to MySQL server on "192.168.10.10'(10061)

I use portnumber 3306

What could be wrong?[/quote]

[Kobus]

Try this

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no

/sbin/e-smith/expand-template /etc/my.cnf

service mysqld restart

[Rien]

Hi Kobus,

Thanks for your reply. I tried, but no results.

Can you answer the following questions:

• I use portnumber 3306, is that the correct number?
• I use the ip-address of the SME-server (192.168.10.10) as server name, is that correct?
• I have tried to logon as "root" an as "admin". Which should work?
• I use the "test" database. It exists according to phpmyadmin

[Kobus]

Hi Kobus,

Thanks for your reply. I tried, but no results.

Can you answer the following questions:

• I use portnumber 3306, is that the correct number?
• I use the ip-address of the SME-server (192.168.10.10) as server name, is that correct?
• I have tried to logon as "root" an as "admin". Which should work?
• I use the "test" database. It exists according to phpmyadmin

1 Correct port number
2 address should only matter as far as rights to mysql grants table is concerned
3 root admin should not matter
4 test is fine

try this

login to mysql
run select * from mysql.user;
what do you see in the host column?

is there only localhost?
if there is only localhost then you can only access mysql from the local server via putty or the console

is there %?
if there is a % that means you should be able to connect to it from any pc

is there and ip address?
if there is an ipaddress then you can access mysql from that ip address

is there a hostname?
ditto as for ip address

[gelcube]

You can also do this via phpmyadmin.  You'll likely have to create a user with access from any pc ("%" under host), as I don't think SME creates one by default.  All the users have access host = "localhost".