[MySQL] – 更改密碼後，無法登入phpmyadmin
問題：
# ./mysql -V
./mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3更改密碼後，無法登入phpmyadmin
但 commend 確可以?
解答：
問題在 編碼要使用舊式的
# rm -rf /usr/local/mysql/data/mysql/
#/usr/local/mysql/bin/mysqldump -uroot -p showdown
# /usr/local/mysql/scripts/mysql_install_db –user=mysql
# /usr/local/mysql/bin/mysqld_safe –user=mysql >/dev/null &
# /usr/local/mysql/bin/mysqladmin -uroot password new-password
#/usr/local/mysql/bin/mysql -uroot -p
> SET PASSWORD FOR ‘root’@'localhost’ = OLD_PASSWORD(’新密碼‘);
[Mysql][PHP] – OLD_PASSWORD 問題
會有OLD_PASSWORD的問題
Although this MySQL extension is compatible with MySQL 4.1.0 and greater, it doesn’t support the extra functionality that these versions provide. For that, use the MySQLi extension.
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Question :
執行 phpmyadmin 登入時出現 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解析：
意為 php Can`t connect mysql.sock （在 /tmp 目錄下找不到 mysql.sock 這個程序）
解決方法：
方法一、 某些mysql安裝時將mysql.sock放在/var/lib/mysql/mysql.sock或者其他的什麼地方，你可以通過修改/etc/my.cnf文件來修正它
vi /etc/my.cnf
socket=/var/lib/mysql/mysql.sock -> socket=/tmp/mysql.sock
方法二、 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
建議使用方法二
ps .
php.ini 文件中 mysql.default_socket =
如為空值意為預設值 /tmp/mysql.sock
