Re: [gentoo-user] Network access to mysql

2009-01-29 Thread Peter Humphrey
On Wednesday 28 January 2009 16:25:16 AllenJB wrote: > Check the bind-address setting in /etc/my.cnf - if this is 127.0.0.1 > then no other machines will be able to connect to the mysql server. To > listen on all available interfaces, this setting should be "0.0.0.0" or > unset. That was it - tha

Re: [gentoo-user] Network access to mysql

2009-01-28 Thread Alejandro
2009/1/28 AllenJB > Peter Humphrey wrote: > >> Afternoon all, >> >> I have mysql running on my workstation and on my local server, and I want >> to connect as an ordinary user from the workstation to the server; I can't. >> This is what happens: >> >> $ mysql -p -h serv.ethnet >> Enter password:

Re: [gentoo-user] Network access to mysql

2009-01-28 Thread AllenJB
Peter Humphrey wrote: Afternoon all, I have mysql running on my workstation and on my local server, and I want to connect as an ordinary user from the workstation to the server; I can't. This is what happens: $ mysql -p -h serv.ethnet Enter password: ERROR 2003 (HY000): Can't connect to MySQ

[gentoo-user] Network access to mysql

2009-01-28 Thread Peter Humphrey
Afternoon all, I have mysql running on my workstation and on my local server, and I want to connect as an ordinary user from the workstation to the server; I can't. This is what happens: $ mysql -p -h serv.ethnet Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 'serv.ethnet'

Re: [gentoo-user] Network access to MySQL

2008-05-03 Thread Peter Humphrey
On Tuesday 29 April 2008 22:40:09 Mick wrote: > HTH. Thanks to both of you. I'll leave the bind address unspecific. -- Rgds Peter -- gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] Network access to MySQL

2008-04-29 Thread Mick
On Tuesday 29 April 2008, kashani wrote: > Peter Humphrey wrote: > > Having just installed mysql on my server, I've found that I have to set > > bind-address = 0.0.0.0 in /etc/mysql/my.cnf to enable me to connect to > > mysqld over the local network: leaving it at the default 127.0.0.1 causes > > c

Re: [gentoo-user] Network access to MySQL

2008-04-29 Thread kashani
Peter Humphrey wrote: Having just installed mysql on my server, I've found that I have to set bind-address = 0.0.0.0 in /etc/mysql/my.cnf to enable me to connect to mysqld over the local network: leaving it at the default 127.0.0.1 causes connection requests to be rejected. Is there a more se

Re: [gentoo-user] Network access to MySQL

2008-04-29 Thread Hamish
On Tuesday 29 April 2008 10:51:30 Peter Humphrey wrote: > Having just installed mysql on my server, I've found that I have to set > bind-address = 0.0.0.0 in /etc/mysql/my.cnf to enable me to connect to > mysqld over the local network: leaving it at the default 127.0.0.1 causes > connection request

[gentoo-user] Network access to MySQL

2008-04-29 Thread Peter Humphrey
Having just installed mysql on my server, I've found that I have to set bind-address = 0.0.0.0 in /etc/mysql/my.cnf to enable me to connect to mysqld over the local network: leaving it at the default 127.0.0.1 causes connection requests to be rejected. Is there a more secure value for this para