WebmasterForums.NET - Webmaster Forums & Directory
 

Go Back   WebmasterForums.NET - Webmaster Forums & Directory > Design and Development > Database - Mysql, SQL and Others
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database - Mysql, SQL and Others MySQL, MSSQL, PGSQL, ms access and other database discussions.

Reply
 
Thread Tools Display Modes
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
Old 08-05-2006, 03:51 PM   #2
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

Permissions on /var/lib/mysql are 700
Your client can not search the directory for the socket.
Make the permissions 755.
barney is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 11:28 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
WebmasterForums.NET - Webmaster Forums & Directory