从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 这种写法是错误的。