More MySql troubles


#1

I have done some more work on my connection issues and found that I cannot
connect to the database (any of them) when logged in to the system as anyone
other than root. Below is an example of the error I get when logging in as
’bob’.

[bob@support1 bob]$ mysqladmin -u root status
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Can’t connect to local MySQL server through socket
’/var/lib/mysql/mysql
.sock’ (111)‘
Check that mysqld is running and that the socket:
’/var/lib/mysql/mysql.sock’ ex
ists!
[bob@support1 bob]$

Any ideas?


#2

| I have done some more work on my connection issues and found that I cannot
| connect to the database (any of them) when logged in to the system as
| anyone other than root. Below is an example of the error I get when
| logging in as ‘bob’.
|
| [bob@support1 bob]$ mysqladmin -u root status
| mysqladmin: connect to server at ‘localhost’ failed
| error: ‘Can’t connect to local MySQL server through socket
| ‘/var/lib/mysql/mysql
| sock’ (111)’
| Check that mysqld is running and that the socket:
| ‘/var/lib/mysql/mysql.sock’ ex
| ists!
±–>8

Sounds to me like /var/lib/mysql is only accessible by root. You should
probably chmod o+rx it.

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]


#3

Thanks for the idea.
I agree with your prognosis. However, your fix did not do it. Any other
(extended) ideas?-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On Behalf Of Brandon S. Allbery
KF8NH
Sent: Thursday, December 28, 2000 4:34 PM
To: rmcduffee@virsage.com; rt-users@lists.fsck.com
Subject: Re: [rt-users] More MySql troubles

On Thursday, December 28, 2000 04:23:12 PM -0700, Robert McDuffee rmcduffee@virsage.com wrote:
| I have done some more work on my connection issues and found that I cannot
| connect to the database (any of them) when logged in to the system as
| anyone other than root. Below is an example of the error I get when
| logging in as ‘bob’.
|
| [bob@support1 bob]$ mysqladmin -u root status
| mysqladmin: connect to server at ‘localhost’ failed
| error: ‘Can’t connect to local MySQL server through socket
| ‘/var/lib/mysql/mysql
| sock’ (111)’
| Check that mysqld is running and that the socket:
| ‘/var/lib/mysql/mysql.sock’ ex
| ists!
±–>8

Sounds to me like /var/lib/mysql is only accessible by root. You should
probably chmod o+rx it.

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


#4

The problem weas in the security of the /var/lib/mysql directory and not the
mysql.sock file. I fixed that with a chmod 775 and all is well.-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On Behalf Of Robert McDuffee
Sent: Friday, December 29, 2000 8:38 AM
To: ‘Brandon S. Allbery KF8NH’; rt-users@lists.fsck.com
Subject: RE: [rt-users] More MySql troubles

Thanks for the idea.
I agree with your prognosis. However, your fix did not do it. Any other
(extended) ideas?

-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]On Behalf Of Brandon S. Allbery
KF8NH
Sent: Thursday, December 28, 2000 4:34 PM
To: rmcduffee@virsage.com; rt-users@lists.fsck.com
Subject: Re: [rt-users] More MySql troubles

On Thursday, December 28, 2000 04:23:12 PM -0700, Robert McDuffee rmcduffee@virsage.com wrote:
| I have done some more work on my connection issues and found that I cannot
| connect to the database (any of them) when logged in to the system as
| anyone other than root. Below is an example of the error I get when
| logging in as ‘bob’.
|
| [bob@support1 bob]$ mysqladmin -u root status
| mysqladmin: connect to server at ‘localhost’ failed
| error: ‘Can’t connect to local MySQL server through socket
| ‘/var/lib/mysql/mysql
| sock’ (111)’
| Check that mysqld is running and that the socket:
| ‘/var/lib/mysql/mysql.sock’ ex
| ists!
±–>8

Sounds to me like /var/lib/mysql is only accessible by root. You should
probably chmod o+rx it.

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users