环境:
服务器: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)
最近刚开始接触,持续更新中,欢迎评论交流!!!【不玩了,转腾讯云】