linux服务器配置jpress以及出现的问题记录

  

mysql> use jpress;
Database changed
mysql> create user 'jpress'@'%' identified by 'Root123.';
Query OK, 0 rows affected (0.06 sec)

mysql> grant all privileges on *.* to 'jpress'@'%' with grant option;
Query OK, 0 rows affected (0.02 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root123.';
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| jpress             |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.01 sec)

mysql> select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+----------