View Single Post
Old 08-05-2006, 03:51 PM   #1
barney
Senior Member
 
barney's Avatar
 
Join Date: Jul 2006
Location: USA
Posts: 203
barney is on a distinguished road
Send a message via ICQ to barney Send a message via AIM to barney Send a message via Yahoo to barney
Default unable to access mysql as anyone besideslinux user= root

--Boundary_(ID_sfMnLS1lO9IgDoKXPWVUWg)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
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/

rowan@inglewood:~/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!
rowan@inglewood:~/perl>
barney is offline   Reply With Quote