View Single Post
  #12  
Old 26th March 2013, 17:26
researcher7 researcher7 is offline
Junior Member
 
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

As mentioned in the previous reply.
The general rule is the [client] section to match what the [mysqld] section has for the socket file location, so if [mysqld] shows

socket = /tmp/mysqld.sock,

then [client] section should have
/tmp/mysqld.sock

If [mysqld] has something else, like socket = /var/run/mysqld/mysqld.sock then [client] should have the same.

Note: Make sure to back up your my.cnf file before applying any changes.

Code:
cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
Or

Code:
cp /etc/my.cnf /etc/my.cnf.bak

Last edited by researcher7; 26th March 2013 at 17:30.
Reply With Quote