mysql server problem

[ramkumar]

we have installed a new server . in that i want to start the mysql server . but when i am trying to start it by using mysql.server start . IT is giving error message /tmp/mysql.sock is not available . I have not modifed any config files like my.cnf in etc .

expecting your reply soon

[Yogeeraj_1]

hi,

try to create a link to the file:
e.g.
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

regards
Yogeeraj

[BONNAFOUS Jean Marc]

Hi,

This file has been, probably, deleted (it's problem with files in /tmp.
You can change this file location in my.cnf or protect access to this file.

See http://www.nexen.net/docs/mysql/annotee/problems-with-mysql.sock.php (in french).

Rgds
JMB

[ramkumar]

hi there is no directory call /var/lib/mysql

[BONNAFOUS Jean Marc]

Hi,

Your mysql is in other folder, perhaps /var/opt/mysql.
Or use find command:
find / -name "*mysql.sock*" -follow -print

to find where is this file.

So i'm not sure it's a good idea to link it this a file in /tmp. Change location in the mysql config.

Rgds
JMB

[ramkumar]

hi guys ,


thanks for you efforts . I found the solution from mysql site . it is known problem . i am using Hp-ux 11.11 in whih i need to apply two pathes related to streams and sockets . I applied it and tested worked ine

[Muthukumar_5]

IS your ./safe_mysqld daemon running there?

Try to start it in background

# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

./safe_mysqld
Starting mysqld daemon with databases from /usr/local/var

[1]+ Stopped ./safe_mysqld

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.


Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql>

HTH.