mysql8修改密码之后无法登陆_MySQL 8.0 用户管理 更改密码 创建用户登录 遇到很迷的问题...

注意文本格式，有时候在其他地方直接复制粘贴执行会有问题，例如从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)