That's because you get this: '020317 16:48:10 mysqld ended.' It means there was an error, and the database server is no longer running. Check your mysql log files to find out why. Does the user, 'mysql' have permissions to write into the directory mysql is using, normally /var/lib/mysql Who is the owner, and group for that directory? And what are the permissions? Do an 'ls -la /var/lib/' You should have something like: 'drwxrwxr-x 25 mysql root 3072 Mar 16 23:00 mysql' or even 'drwxrwxr-x 25 root mysql 3072 Mar 16 23:00 mysql'
-----Original Message----- From: Art Fore [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 6:04 PM To: [EMAIL PROTECTED] Subject: RE: mysql.sock Found the file there, guess I missed it or it got created after I looked before If I run ./safe_mysqld --user=mysql & I get Starting mysqld-max daemon with databases from /var/lib/mysql 020317 16:48:10 mysqld ended. I run mysqladmin u root -p piccolo 'new-password' Enter password: I then get connect to server at 'localhost failed If I run mysqld -ping, I get all kinds of info back. So guess I am completely lost. Art -----Original Message----- From: Mark Maunder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 4:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock Art, Do you mean, whenever you try to run the 'mysql' client you get that error? That usually happens because you are trying to connect to the mysql server using the mysql client running on the same machine i.e. localhost. It's because the mysql client uses a socket file when connecting locally and the mysqld server is not storing the file in the default location where the client expects it. Fix it by putting this entry in the file /etc/my.cnf under the [client] section. socket = /tmp/mysql.sock or whatever the location of your socket file is. If you can't find it do a find / -name "mysql.sock" Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: > When I try to run the mysqld or safe_mysql, I get "connot connect to local > MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that > mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! > > This file does not exist. Where does it come from or how do you create it? I > have done a search on the website, but no results. /etc/hosts file is also > correct. > > Art > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
