软件版本
1.Linux:CentOS Linux release 8.3.2011
2.MySQL:mysql-8.0.21
安装MySQL
1、下载mysql的yum仓库,下载地址
2、选择适合的版本,点击Download,将下载地址复制下来
3、下载MySQL rpm文件
也可以直接下载下来,用ftp上传到服务器
wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm
4、安装mysql的yum源
[root@localhost~]# yum localinstall mysql80-community-release-el8-1.noarch.rpm
结果:在/etc/yum.repos.d/目录下生成两个mysql-community开头的repo文件
5、检查mysql源是否安装成功
[root@localhost~]# yum repolist enabled | grep "mysql.*-community.*"
6、禁用CentOS8自带mysql模块
[root@localhost~]# yum module disable mysql
7、使用yum源安装mysql
[root@localhost~]# yum install -y mysql-community-server
登录mysql
// 获取初始密码
[root@localhost~]# grep 'temporary password' /var/log/mysqld.log
// 登录
[root@localhost~]# mysql -uroot -p
修改root密码
alter user 'root'@'localhost' identified by 'Root123+';
备注:如果不先修改初始密码,输入任何命令都会报以下错误:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
如果密码过于简单,会报以下错误:
ERROR 1193 (HY000): Unknown system variable ‘validate_password_policy’
开放远程连接
mysql> show databases;
mysql> use mysql;
mysql> update user set host = "%" where user = "root";
授予所有权限
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;
使用Navicat Premium连接报错
- 错误信息:1449:-The user specified as a definer(‘mysql.infoschema’@‘localhost’) does not exist
mysql.infoschema
- 问题分析:‘mysql.infoschema’@'localhost’账户被删除了
- 解决方法:
mysql> SET GLOBAL innodb_fast_shutdown = 1;
[root@localhost~]# mysql_upgrade -u root -p
修改密码时报错
- 错误信息:1819-Your password does not satisfy the current policy requirements
- 问题分析:密码校验策略太强了
- 解决方法:
// 1、查看当前安全变量值
mysql> SHOW VARIABLES LIKE 'validate_password%';
// 2、修改变量
mysql> SET GLOBAL validate_password.policy = 0;
mysql> SET GLOBAL validate_password.length = 4;