mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql:

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

According to pkginfo -l, the installation was successful:

# uname -a
SunOS <hostname> 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250
# pkginfo -l mysql
PKGINST: mysql
NAME: MySQL Community Edition - Standard (GPL)
CATEGORY: application
ARCH: sun4u
VERSION: 5.0.21
BASEDIR: /opt/mysql
VENDOR: MySQL AB
PSTAMP: MySQL AB Build Engineers
INSTDATE: May 25 2006 10:40
EMAIL: build@mysql.com
STATUS: completely installed
FILES: 1668 installed pathnames
54 directories
99 executables
163084 blocks used (approx)

I also did a find on mysql.sock, and I came up with nothing. Any ideas? I would really appreciate any help or advise :slight_smile:

That means the server has not been started. In the first command you posted "mysql", you seems to be starting the mysql client, not the server. If the server is not yet started local client connection will fail.

Find out if the package has a mysql server init script and try starting it first.

thank you for the replya :slight_smile:

this was a simple case of rtfm. you are right. i was suppose to start mysql.server and copy the appropriate .cnf file to /etc/my.cnf.

thanx. :o