starting mysql client localhost not recognised?

davidh_uk · 05-08-2005, 06:24 AM

I cant seem to start mysql without providing the IP number:
shell>mysql -h 127.0.0.1 -p #works fine
but
shell>mysql -h localhost -p #gives this error
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I do have localhost in my /etc/hosts file.

I think the issue is that my mysql.sock file is at the default /tmp location but invoking mysql with a non-IP address makes it look in /var/lib/mysql & I dont know why or how to change it. Nor do I see why this would cause a difference between mysql's treatment of an IP number and an address name such as localhost in this scenario. This could be nothing to do with it of course

I start the server manually (For testing reasons) so I have no /etc/my.cnf so I must be using all default values for client and server.

TIA

david_ross · 05-09-2005, 04:13 PM

You could use the -S option to specify the path to the sock file. See "man mysql" for the full list of options.

davidh_uk · 05-09-2005, 04:47 PM

Quote:

Originally posted by david_ross
You could use the -S option to specify the path to the sock file. See "man mysql" for the full list of options.

yup, that worked fine:
'shell>mysqladmin -S /tmp/mysql.sock variables -u david -p'
versus
'shell>mysqladmin variables -u david -p'

but I'd like to know what to change so I don't have to type all the -S stuff every time. Yea, I know, I just want it all

Thanks David:

mrcheeks · 05-09-2005, 05:15 PM

Maybe if you have the line "skip-networking" in your mysql.conf you can comment it by removing the "#" at the beginning of the line.

jschiwal · 05-09-2005, 05:15 PM

According to another thread on this board you can change a line in your /etc/my.conf file:

Code:

cat /etc/my.conf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
...

david_ross · 05-10-2005, 01:31 PM

Quote:

Originally posted by jschiwal
According to another thread on this board you can change a line in your /etc/my.conf file:

You can also set it for client utilities:

Code:

[mysql]
socket=/var/lib/mysql/mysql.sock

So long as it is the same for client and server it should work.

davidh_uk · 05-10-2005, 04:32 PM

It now works fine.
"shell>bin/mysqld --help" showed that mysqld was looking for the my.cnf file in /etc
but I put it in /etc/mysql/my.cnf and didn't pass it the "--defaults-file" option to tell it where to pick options up from. Thus it wasn't picking the .sock file up from /tmp and it was this which caused all the confusion.

Thanks to all for the tips that helped me resolve it