匿名用户我的环境：centos，使用obd安装
版本：社区版4.1
问题描述：
第一次我的语句是：
create user ‘u1’ identified by password ‘oceanbase113’;
报错为： The password hash doesn’t have the expected format.Check if the correct password algorithm is being used with the PASSWORD() function
之后我根据提示，使用如下语句：
create user ‘u1’ identified by password password(‘oceanbase113’);
报错为：错误码1064，提示有语法错误。
求助分析原因。
(root@10.0.0.66:2883) [oceanbase]> select user,host,password from mysql.user;
+-------------+------+-------------------------------------------+
| user | host | password |
+-------------+------+-------------------------------------------+
| root | % | *a558cc603cc38ca75cb299a7b97d02f5f1f351f7 |
| proxyro | % | *ac62f97bec7190f347b35bc1d8f4ed1209ea07d3 |
| ocp_monitor | % | *12853e91831ccd89956b321b517b7c9dac4bbdb9 |
+-------------+------+-------------------------------------------+
3 rows in set (0.037 sec)
(root@10.0.0.66:2883) [oceanbase]> create user mq identified by password "*a558cc603cc38ca75cb299a7b97d02f5f1f351f7";
Query OK, 0 rows affected (0.875 sec)
评论
有用 0
