Re: Can't connect URGENT!
On Sun, 8 Feb 2004 [EMAIL PROTECTED] wrote: the only way I can connect to the server is typing mysql -h localhost -u root make sure you don't have a line skip-networking in your /etc/my.cnf cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect URGENT!
On 8 Feb 2004, at 00:29, [EMAIL PROTECTED] wrote: Hi, I have instaled mysql 4.0.17 on a debian server, but i have a big problem. I can only connect to mysql at the server and only with -h localhost. If I try this: mysql -h server -u root from anywhere i receice always the same response: ERROR 2003: Can't connect to MySQL server on 'server' (111) the only way I can connect to the server is typing mysql -h localhost -u root at the server. Can anyone please help? I already search at google and can fine anything. TIA Carlos Baptista Just a thought - have you granted privileges for user 'root' to connect using hostname 'server'? http://www.mysql.com/doc/en/GRANT.html HTH Steve. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can't connect URGENT!
Hmmm, I dunno. Perhaps the term: mysql -h 'server' -u root Should be changed to: mysql -h your_hostname -u root As your_hostname is the actual FQDN of your server. Brian Duke SS-TCAM//87797 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 5:30 PM To: [EMAIL PROTECTED] Subject: Can't connect URGENT! Hi, I have instaled mysql 4.0.17 on a debian server, but i have a big problem. I can only connect to mysql at the server and only with -h localhost. If I try this: mysql -h server -u root from anywhere i receice always the same response: ERROR 2003: Can't connect to MySQL server on 'server' (111) the only way I can connect to the server is typing mysql -h localhost -u root at the server. Can anyone please help? I already search at google and can fine anything. TIA Carlos Baptista - This mail sent through IMP: http://horde.org/imp/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can't connect URGENT!
Hi You can only connect as root from localhost for security I think. If you want to connect from elsewhere create a new user and use that - look for GRANT on www.mysql.com Peter -Original Message- From: Duke, Brian [mailto:[EMAIL PROTECTED] Sent: 08 February 2004 01:50 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Can't connect URGENT! Hmmm, I dunno. Perhaps the term: mysql -h 'server' -u root Should be changed to: mysql -h your_hostname -u root As your_hostname is the actual FQDN of your server. Brian Duke SS-TCAM//87797 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 5:30 PM To: [EMAIL PROTECTED] Subject: Can't connect URGENT! Hi, I have instaled mysql 4.0.17 on a debian server, but i have a big problem. I can only connect to mysql at the server and only with -h localhost. If I try this: mysql -h server -u root from anywhere i receice always the same response: ERROR 2003: Can't connect to MySQL server on 'server' (111) the only way I can connect to the server is typing mysql -h localhost -u root at the server. Can anyone please help? I already search at google and can fine anything. TIA Carlos Baptista - This mail sent through IMP: http://horde.org/imp/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]