[afnog] help with ACID installation

Benjamin A. Eshun baeshun at aau.org
Wed May 11 20:06:29 EAT 2005


> 
> >  Database ERROR:Can't connect to local MySQL server through socket
> >  '/var/lib/mysql/mysql.sock' (13)"
> >
> 

You may also just want to start the mysql from the line interface with the command 
below.

mysql --socket=/var/lib/mysql/mysql.sock ...

If it works change to the MySQL  configuration file /etc/my.cnf that will permanently set 
the socket file  used by the mysql client. 

[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

If there is not currently a section called [client], add one at the bottom of the file and 
copy the socket= line under the [mysqld] section such as:

[client]
socket=/var/lib/mysql/mysql.sock

If there is already a [client] section in the my.cnf file, add or edit the socket line as 
appropriate. You won't need to restart your server or any other processes. Subsequent 
uses of the mysql client will use the proper socket file.

cheers,

Benjamin




More information about the afnog mailing list