ihaveinstalledmysqlthroughbinaryinstallationandfollowedbelowsteps
3358 dev.MySQL.com/doc/ref man/5.0/en/binary-installation.html
rightnowsockfilesarecraetedon/tmp/MySQL.sockwhenmysqlserviceisstarted。
iwanttoknowwhichconfigurationfilesneedtobeeditedtochangethepathofmysql.sock
itriedthefollowingstepstochangemysql.sockpathfrom/tmp/MySQL.sockto/var/lib/MySQL/MySQL.sock
1.itriedtoentersocketpathin/etc/my.cn f
socket=/var/lib/MySQL/MySQL.sock
2./etc/init.d/mysql
basedir=/var/lib/mysql
datadir=/var/lib/mysql/data
socket=/var/lib/MySQL/MySQL.sock
Can anybody help me to fix this issue。
解决方案
settingthesevariablesinmy.cnfshouldworkjustfine (tested locally,Ubuntu 10.10 )。
datadir=/var/lib/mysql
socket=/var/lib/MySQL/MySQL.sock
justmakesureyou ' rerestartingmysqlservice?
Below is what I did,thisisonfedora (since you ' reusingrhelthisshouldmoremimicyoursetup ) :
ibdata1IB _ log file0IB _ log file1mysqlmysql.sock
mysqld.pid
stopping mysqld : [确定]
starting mysqld : [确定]
ibdata1IB _ log file0IB _ log file1MySQL
mysqld.pid mysql.sock
theonlythingthatichangedwassocket=this time,and restarting still worked fine。
areyousurethatyou ' renoteditingsocketwithinthe [ client ] section ofmy.cn f? itmustbeunderthe [ mysqld ] section。