Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Rien on March 01, 2005, 07:59:28 PM

Title: Problems connecting MySQL Administrator to SME 6.01-01
Post by: Rien on March 01, 2005, 07:59:28 PM
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:

Quote
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]
Title: Problems connecting MySQL Administrator to SME 6.01-01
Post by: Kobus on March 01, 2005, 10:07:21 PM
Try this

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

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

service mysqld restart
Title: Problems connecting MySQL Administrator to SME 6.01-01
Post by: Rien on March 02, 2005, 02:21:58 AM
Hi Kobus,

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

Can you answer the following questions:
Title: Problems connecting MySQL Administrator to SME 6.01-01
Post by: Kobus on March 02, 2005, 12:14:19 PM
Quote from: "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


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
Title: Problems connecting MySQL Administrator to SME 6.01-01
Post by: gelcube on March 02, 2005, 07:20:08 PM
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".