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 - thanks.

[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

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

Re: [gentoo-user] Network access to mysql

2009-01-28 Thread Alejandro
2009/1/28 AllenJB gentoo-li...@allenjb.me.uk 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

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

[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

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 requests

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

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