[NBLUG/talk] MySQL connection problem

Peter Lutz peter3 at sonic.net
Sat Feb 19 10:08:51 PST 2005


Good Morning.

I don't use MySQL much, but I do have it installed on a Debian testing box.
It seems to work just fine after an upgrade from 3.23 to 4.0.23, on the server.
The problem is on a client.  When trying to connect,
shell>mysql -h<HOSTNAME> -u<USERNAME> -p
I get the error message:
ERROR 2003: Can't connect to MySQL server on 'host_name' (111)

The /etc/mysql/my.cnf file for 3.23 had a line containing:
#  skip-networking
which was NOT commented out in the original file.  All I had to do to start
networking was add the comment octothorp and bounce the server.  But the
new my.cnf file has no such line, and I can't understand the comments in
the new file or the suggestions in the manual (5.5.8 about Access denied).
I'm sure this is a simple fix, but darned if I can find it.

I've checked the grant tables on the server, and they seem to contain all the
right users, and there are many more columns than there used to be, so I
think that part of things is working correctly.

Any help would be welcome.
Thanks.
-- 
Peter Lutz  AA6AV
Debian Linux 2.4.28





More information about the talk mailing list