topic mysql server problem in Operating System - HP-UX

mysql server problem

ramkumar — Wed, 27 Oct 2004 06:01:26 GMT

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

Re: mysql server problem

Yogeeraj_1 — Wed, 27 Oct 2004 06:24:25 GMT

hi,

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

regards
Yogeeraj

Re: mysql server problem

BONNAFOUS Jean Marc — Wed, 27 Oct 2004 06:32:29 GMT

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

Re: mysql server problem

ramkumar — Wed, 27 Oct 2004 06:50:38 GMT

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

Re: mysql server problem

BONNAFOUS Jean Marc — Thu, 28 Oct 2004 02:06:15 GMT

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

Re: mysql server problem

ramkumar — Thu, 28 Oct 2004 05:04:07 GMT

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

Re: mysql server problem

Muthukumar_5 — Thu, 28 Oct 2004 07:43:01 GMT

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.