smrtalec wrote:
whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included.
mysql 2524 2500 0 15:41 pts/1 00:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/li mysql 2526 2524 0 15:41 pts/1 00:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/li mysql 2527 2526 0 15:41 pts/1 00:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/li mysql 2528 2526 0 15:41 pts/1 00:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/li root 2568 2100 0 15:53 pts/1 00:00:00 ps -ef
inglewood:/var/lib/mysql # l total 395 drwx------ 5 mysql daemon 616 Jan 24 15:41 ./ drwxr-xr-x 26 root root 672 Jan 21 03:06 ../ -rw-rw---- 1 mysql daemon 4884 Jan 21 03:06 inglewood-bin.001 -rw-rw---- 1 mysql daemon 347233 Jan 24 08:28 inglewood-bin.002 -rw-rw---- 1 mysql daemon 86 Jan 24 11:30 inglewood-bin.003 -rw-rw---- 1 mysql daemon 73 Jan 24 11:30 inglewood-bin.004 -rw-rw---- 1 mysql daemon 86 Jan 24 11:38 inglewood-bin.005 -rw-rw---- 1 mysql daemon 414 Jan 24 15:37 inglewood-bin.006 -rw-rw---- 1 mysql daemon 86 Jan 24 15:40 inglewood-bin.007 -rw-rw---- 1 mysql daemon 73 Jan 24 15:41 inglewood-bin.008 -rw-rw---- 1 mysql daemon 160 Jan 24 15:41 inglewood-bin.index -rw-rw---- 1 mysql daemon 4 Jan 24 15:41 inglewood.pid drwx------ 2 mysql daemon 528 Jan 21 03:06 mysql/ srwxrwxrwx 1 mysql daemon 0 Jan 24 15:41 mysql.sock= -rw-r--r-- 1 mysql daemon 3831 Jan 24 15:41 mysqld.log -rw-r--r-- 1 mysql daemon 635 Jan 24 08:28 mysqld.log-20040122 drwx------ 2 mysql daemon 48 Jan 24 14:42 studio_3/ drwx------ 2 mysql daemon 2976 Jan 21 06:44 test/
[EMAIL PROTECTED]:~/perl> mysqladmin -u root -p version Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! [EMAIL PROTECTED]:~/perl>
Permissions on /var/lib/mysql are 700 Your client can not search the directory for the socket. Make the permissions 755.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
