I have changed the location of the socket file in my.cnf, however, when I try to login to mysql, I get the error "Can't connect to local MySQL server through socket 'prev/sock'" (I am using Prev/sock to denote that it is still looking for the previous location/default location).
I have added this parameter in my.cnf file
I am using [mysqld] in my.cnf, not [client]
when I try using the command:
mysql -u root -p -S /opt/data/sockpid/mysql.sock - this bit is working
The parameter is not being read or not working correctly...