Change MySQL password under fedora14

I don't know why, it is very difficult to configure fedora14 after installing MySQL with Yum. Now I will record the password change method.

Error:

[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'

Is it a permission issue? Puzzled

Solution:

1. Modify the file/etc/My. CNF and add skip-grant-tables to the [mysqld] segment. This means that the permission verification is skipped when MySQL is started and saved and exited.

2. Restart the MySQL service [root @ myfedora MySQL] # service mysqld restart

3. log on to MySQL and change the password.

[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. Change the configuration file/etc/My. CNF and restart the service.

Good luck