MySQL Forums
Forum List  »  MySQL Administrator

can't start mysql saying mysql can't create /tmp/mysql.sock
Posted by: sheila yao
Date: May 21, 2009 03:04PM

I've a mysql version Ver 14.12 Distrib 5.0.60sp1, for redhat-linux-gnu (i686) using readline 5.1.

I use the default data directory /var/lib/mysql.

When I don't create /etc/my.cnf file, I can start and stop mysql.

When I copied the big-mysql.cnf to /etc/my.cnf and added socket = /tmp/mysql.sock in my.cnf, I can't start mysql any more.

The error says mysql can't create /tmp/mysql.sock. Do you have another mysql instance running?

The permission of /tmp/ is correct because I (mysql user) can create a file in /tmp/.
And I don't have another mysql instance running.

Does anyone know what is going on?

Never mind, someone else created a sock file under /var/lib/mysql.

Thanks.

Sheila



Edited 1 time(s). Last edit at 05/21/2009 03:11PM by sheila yao.

Options: ReplyQuote


Subject
Written By
Posted
can't start mysql saying mysql can't create /tmp/mysql.sock
May 21, 2009 03:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.