ECS搭建Java Web环境问题

环境：

服务器：ECS        系统：CentOS 8.5 

jdk：1.8.0_***        MySQL:8.0.**

---

问题列表

Q1：安装MySQL服务报错

Error: Unable to find a match: mysql-community-server

A1：yum方式安装mysql需要先关闭mysql模块

---

 Q2：修改mysql安全策略报错

mysql> set global validate_password_policy=0;
ERROR 1193 (HY000): Unknown system variable 'validate_password_policy'
mysql> SHOW VARIABLES LIKE 'validate_password%';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

A2：mysql5.7使用的变量和mysql8使用的变量略有差距

--先修改密码，查看对应变量
mysql> SHOW VARIABLES LIKE 'validate_password%';
--再做修改
mysql> set global validate_password.policy=0;

mysql变量如图

---

Q3：mysql，授予root用户远程管理权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '12345678'' at line 1

A3：没有root用户，先创建，后授权

mysql> create user root@'%' identified by '12345678';
Query OK, 0 rows affected (0.01 sec)

mysql> grant all privileges on *.* to root@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)

---

 Q4：导入初始数据报错

[root@]# sql_file="/var/www/html/static/backup/sql/"$(ls /var/www/html/static/backup/sql/) && mysql -uroot -12345678 pbootcms < $sql_file
mysql: [ERROR] mysql: unknown option '-x'.

A4：使用其他方式，先登录数据库，切换实例，在导入数据

mysql> use pbootcms;
Database changed

mysql> source /var/www/html/static/backup/sql/pbootcms_v310.sql;

mysql> show tables;
+--------------------+
| Tables_in_pbootcms |
+--------------------+
| ay_area            |
| ay_company         |
| ay_config          |
| ay_content         |
| ay_content_ext     |
| ay_content_sort    |
| ay_diy_telephone   |
| ay_extfield        |
| ay_form            |
| ay_form_field      |
| ay_label           |
| ay_link            |
| ay_member          |
| ay_member_comment  |
| ay_member_field    |
| ay_member_group    |
| ay_menu            |
| ay_menu_action     |
| ay_message         |
| ay_model           |
| ay_role            |
| ay_role_area       |
| ay_role_level      |
| ay_site            |
| ay_slide           |
| ay_syslog          |
| ay_tags            |
| ay_type            |
| ay_user            |
| ay_user_role       |
+--------------------+
30 rows in set (0.00 sec)

---

最近刚开始接触，持续更新中，欢迎评论交流！！！【不玩了，转腾讯云】