MySQL数据库更改用户密码

从mysql细节上可以感受出mysql越来越和oracle相似。比如改密码：

从5.7.6开始可以使用：

mysql> select version();
+------------+
| version()  |
+------------+
| 5.7.11-log |
+------------+
1 row in set (0.03 sec)


mysql> alter user user() identified by '20127163';
Query OK, 0 rows affected (0.06 sec)


mysql>

alter user的语法和oracle一致的。

而在这之前，比如5.5中：

mysql> select version();
+------------+
| version()  |
+------------+
| 5.5.48-log |
+------------+
1 row in set (0.00 sec)


mysql> alter user user() identified by '20127163';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user user() identified by '20127163'' at line 1
mysql> set password for 'root'@'localhost'=password('20127163');
Query OK, 0 rows affected (0.06 sec)


mysql>

alter user 这种写法是错误的。