1 |
Peter Humphrey wrote: |
2 |
> Afternoon all, |
3 |
> |
4 |
> I have mysql running on my workstation and on my local server, and I want to |
5 |
> connect as an ordinary user from the workstation to the server; I can't. |
6 |
> This is what happens: |
7 |
> |
8 |
> $ mysql -p -h serv.ethnet |
9 |
> Enter password: |
10 |
> ERROR 2003 (HY000): Can't connect to MySQL server on 'serv.ethnet' (111) |
11 |
> |
12 |
> The same thing happens if I try as root. |
13 |
> |
14 |
> I can connect locally as myself or as root on either machine and manipulate |
15 |
> tables in various ways. I haven't yet installed a firewall on either |
16 |
> machine. |
17 |
> |
18 |
> I've set DEBUG=4 in /etc/conf.d/mysql on both machines, but nothing shows up |
19 |
> in /var/log/mysql/*; only some startup debug messages. I've run tcpdump on |
20 |
> the server, which shows that one packet passes in each direction, followed |
21 |
> immediately by a reverse lookup of the workstation being sent to the name |
22 |
> server. I don't know why nothing happens after the name-service request is |
23 |
> answered, but it seems to imply that the workstation is refusing the |
24 |
> request itself rather than forwarding it to the server. |
25 |
> |
26 |
> I can't see anything in /etc/conf.d/mysql or in /etc/mysql/* on either |
27 |
> machine to restrict network access, so what have I missed? |
28 |
> |
29 |
|
30 |
Check the bind-address setting in /etc/my.cnf - if this is 127.0.0.1 |
31 |
then no other machines will be able to connect to the mysql server. To |
32 |
listen on all available interfaces, this setting should be "0.0.0.0" or |
33 |
unset. |
34 |
|
35 |
Also check that skip-networking is not enabled. |