mysql - 无法在 mysql 5.1.73 上创建新用户

Question

这个好像不行

mysql> SET PASSWORD FOR juser201411@localhost= PASSWORD(".6,y:C2a");

ERROR 1133 (42000): Can't find any matching row in the user table

之后我尝试从 mysql.user 手动添加

mysql> update mysql.user set password=('.6,y:C2a') where User='juser201411' and Host='localhost';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

mysql> select User from mysql.user;+------+
| User |
+------+
| root |
| root |
+------+
2 rows in set (0.00 sec)

centos 6.5 x64

Answer 1

尝试使用CREATE USER 语法。有关详细信息，请参阅 MySQL doc

CREATE USER 'juser201411'@'localhost' IDENTIFIED BY PASSWORD '.6,y:C2a';