在 gentoo 上安裝了 mysql, 但運行時總是的得到這個錯誤信息:
Access denied for user 'root'@'localhost'
可以這樣解決:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('yournewpasswd') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
搞定。
測試一下:
$ mysqladmin -uroot -pmypasswd ping
mysqld is alive
運行:
$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6
Server version: 5.0.44-log Gentoo Linux mysql-5.0.44
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>