Fedora14下 mysql更改密碼

不知為什麼，fedora14下用yum安裝mysql後配置挺麻煩，現將更改密碼的方法記錄一下。

報錯問題：

[root@myfedora mysql]# mysqladmin -u root password 123456
mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'

是許可權的問題嗎？不解

解決方案：

1. 修改檔案/etc/my.cnf，在[mysqld]段中加入skip-grant-tables，就是在啟動開啟mysql時跳過許可權驗證，儲存退出。

2.重啟mysql服務[root@myfedora mysql]# service mysqld restart

3.登入mysql修改密碼

[root@myfedora mysql]# mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.1.56 Source distributionCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 licenseType 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> USE mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> UPDATE user SET Password = password('passwd') WHERE User = 'root';Query OK, 4 rows affected (0.00 sec)Rows matched: 4  Changed: 4  Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> quit

4.設定檔/etc/my.cnf改回，重啟服務即可

Good luck