Original address: http://blog.sina.com.cn/s/blog_6fd605b50100q5es.html with mysqladmin change password hintMysqladmin:can ' t turn off logging; Error: ' Access denied; you need the SUPER privilege for this operation 'Workaround:Modify MySQL Login settingsvi/etc/my.cnfin the [MYSQLD] paragraph, addSkip-grant-tablesRestart MySQL service after savingchange MySQL password after restarting MySQL service[[email protected] anylinux]# MySQL Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 3 to server version:3.23.56
Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear thebuffer.
mysql> use MySQL;
Reading table information for completion of table and ColumnNames
Can turn off this feature to get a quicker startup with-a
Database changed
mysql> UPDATE user SET Password = Password (' anylinux ') WHERE user = ' root ';
Query OK, 0 rows Affected (0.00 sec)
Rows matched:2 changed:0 warnings:0
mysql> flush Privileges;
Query OK, 0 rows affected (0.01 sec)
Mysql> quit
ByeRestart the MySQL service mysql-u root-p log in to MySQL OK to log in successfully.
MySQL prompts you to need the SUPER privilege for this operation workaround
