Thanks for taking the time to reply. Could you maybe elaborate and tell me how I can make mysql the owner of the directory. (Would I also have to stop and restart mysqld as this was part of my original problem).
-----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 14:31 To: Mark Colvin Cc: MySQL Mailing List (E-mail) Subject: Re: mysqld problem Pick/Create a different directory. Make it owned by mysql:mysql, and set it mode 775. Mysqld can not write to /usr/local/bin. Mark Colvin wrote: >I am having difficulty stopping and starting my mysql server. The mysqld is >currently running as all of the client machines can access the database. If >I try to invoke the mysql command from the server box (linux 7.2) I get the >following - > >error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' >(2' >Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! > >The mysql.sock does not exists int /tmp directory and I am attempting to >restart the server to create this. When I run mysqld restart it fails to >stop and start. I think the server was last started with the safe_mysqld & >command. I use the /tmp directory to hold files created by cron jobs and >this directory is periodically cleared out. This is obviously a problem as >the mysql.sock currently needs to be in here. I have since changed the >my.cnf file to read - >[mysqld] >datadir=/var/lib/mysql >socket=/usr/local/bin/mysql.sock > >thus changing the directory for mysql.sock to resolve the above issue but I >can't restart the server to get the mysql.sock recreated. Any ideas? > > > >**************************************************** >This e-mail is intended for the recipient only and >may contain confidential information. If you are >not the intended recipient then you should reply >to the sender and take no further ation based >upon the content of the message. >Internet e-mails are not necessarily secure and >CCM Limited does not accept any responsibility >for changes made to this message. >Although checks have been made to ensure this >message and any attchments are free from viruses >the recipient should ensure that this is the case. >**************************************************** > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] **************************************************** This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. **************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
