注意文本格式,有时候在其他地方直接复制粘贴执行会有问题,例如从word复制执行。另外密码如果有特殊符号,可以用单引号括起来。以下是测试,没发现有什么问题:
mysql> create user 'aplan'@'%' identified by 'Aplan123@';
Query OK, 0 rows affected (0.02 sec)
mysql> select user,host from mysql.user;
user
host
aplan
%
mysql.infoschema
localhost
mysql.session
localhost
mysql.sys
localhost
root
localhost
5 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
mysql> exit
Bye
[root@linux-base mysql]# mysql -uaplan -p'Aplan123@'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 10
Server version: 8.0.12 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql> select user();
user()
aplan@localhost
1 row in set (0.00 sec)
mysql> alter user aplan@'%' identified by 'password';
Query OK, 0 rows affected (0.04 sec)
mysql> exit
Bye
[root@linux-base mysql]# mysql -uaplan -p'password'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11
Server version: 8.0.12 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql> select user();
user()
aplan@localhost
1 row in set (0.00 sec)