Dave M G wrote:
[EMAIL PROTECTED]:~$ ps aux | grep mysql
And it said back to me:
root 11171 0.0 0.0 1772 532 ? S 20:36 0:00 /bin/sh
/usr/bin/mysqld_safe
mysql 11290 0.1 0.7 126708 15424 ? Sl 20:36 0:00
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking
--port=3306 --socket=/var/run/mysqld/mysqld.sock
root 11291 0.0 0.0 2920 736 ? S 20:36 0:00 logger
-p daemon.err -t mysqld_safe -i -t mysqld
dave 11309 0.0 0.0 3004 764 pts/0 R+ 20:37 0:00 grep mysql
$ mysql -u root -p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Oh, this might be relevant - I ran a PHP script with phpinfo() and it
says my MYSQL_SOCKET is located at:
/var/run/mysqld/mysqld.sock
Dave,
It appears that mysql started with mysqld.sock at
/var/run/mysqld/mysqld.sock and your client is configured to look in
/tmp for the same. I would suggest that you modify your /etc/my.cnf to
reflect the same location.
#/etc/my.cnf
[mysqld]
...<snip>...
socket = /tmp/mysql.sock
...<snip>...
restart mysqld.
Also, mysqld safe is a daemon which provides some safety features to
mysql and is the recommended method of starting mysql, AFAIK.
http://dev.mysql.com/doc/refman/5.0/en/mysqld-safe.html
HTH,
--
Josh Miller, RHCE/VCP
Seattle, WA
Linux Solutions Provider
http://itsecureadmin.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]