Fedora 14下 MySQL 更改密碼

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

報錯問題：

[[email protected] 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服務[[email protected] mysql]# service mysqld restart

3.登錄mysql修改密碼

1. [[email protected] mysql]# mysql
2. Welcome to the MySQL monitor. Commands end with ; or \g.
3. Your MySQL connection id is 2
4. Server version: 5.1.56 Source distribution
6. Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
7. This software comes with ABSOLUTELY NO WARRANTY. This is free software,
8. and you are welcome to modify and redistribute it under the GPL v2 license
10. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
12. mysql> USE mysql;
13. Reading table information for completion of table and column names
14. You can turn off this feature to get a quicker startup with -A
16. Database changed
17. mysql> UPDATE user SET Password = password('passwd') WHERE User = 'root';
18. Query OK, 4 rows affected (0.00 sec)
19. Rows matched: 4 Changed: 4 Warnings: 0
21. mysql> flush privileges;
22. Query OK, 0 rows affected (0.00 sec)
24. mysql> quit

Good luck