開心每一天1111
2019-06-24 10:38:23
無法通過套接字‘/var/mysql/mysql.sock’連接到本地MySQL服務(wù)器(38)我有一個大問題,試圖連接到MySQL。當(dāng)我跑步時:/usr/local/mysql/bin/mysql start我有以下錯誤:Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)我確實有mysql.sock在/var/mysql目錄。在……里面/etc/my.cnf我有:[client]port=3306socket=/var/mysql/mysql.sock[mysqld]port=3306socket=/var/mysql/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M和在/etc/php.ini我有:; Default socket name for local MySQL connects. If empty, uses the built-in; MySQL defaults.mysql.default_socket = /var/mysql/mysql.sock我已經(jīng)重新啟動Apachesudo /opt/local/apache2/bin/apachectl restart但我仍然有錯誤。否則,我不知道這是否相關(guān),但當(dāng)我這么做的時候mysql_config --sockets我得到--socket [/tmp/mysql.sock]
3 回答

胡子哥哥
TA貢獻(xiàn)1825條經(jīng)驗 獲得超6個贊
socket=/var/lib/mysql/mysql.sock
mysqladmin -u root -p status
sudo chmod -R 755 /var/lib/mysql/

DIEA
TA貢獻(xiàn)1820條經(jīng)驗 獲得超3個贊
yum -y install mysql mysql-server (or apt-get install mysql mysql-server)
/sbin/chkconfig mysqld on
/sbin/service mysqld start
mysqladmin -u root password 'new-password' (with the quotes)

慕田峪4524236
TA貢獻(xiàn)1875條經(jīng)驗 獲得超5個贊
添加回答
舉報
0/150
提交
取消