MySQL安装
1、下载软件包:mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar
2、将软件包通过moba上传到linux系统/usr/local/soft/目录下
3、解压软件包
cd /usr/local/soft/
tar -xvf mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar
4、卸载系统自带mariadb
rpm -qa | grep mariadb
yum -y remove mariadb-libs-5.5.52-1.el7.x86_64
5、下载依赖包(可直接全部复制粘贴,批量执行)
yum -y install openssl-devel perl-JSON
yum install -y libaio.x86_64 libaio-devel.x86_64
yum install -y openssl-devel.x86_64 openssl.x86_64
yum install -y perl.x86_64 perl-devel.x86_64
yum install -y perl-JSON.noarch
yum install -y autoconf
yum install net-tools –y
yum -y install numactl
6、顺序安装mysql(可直接全部复制粘贴,批量执行)
rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.15-1.el7.x86_64.rpm
安装完默认是mysql用户、用户组和权限
chown -R mysql:mysql /var/lib/mysql/
7、重启mysql服务
systemctl restart mysqld.service
systemctl status mysqld.service
若启动失败查看:
tail -n 100 /var/log/mysqld.log
8、查看密码
cat /var/log/mysqld.log | grep password
或
cd /var/log/
cat mysqld.log
9、数据库登陆
mysql -u root -p
输入第八步中的密码进行登陆
10、设置登陆密码复杂度
set global validate_password.length=4;
set global validate_password.policy=0;
SHOW VARIABLES LIKE 'validate_password%';
11、修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
flush privileges;
12、开放所有IP都能访问
use mysql;
select host, user, authentication_string, plugin from user;
CREATE USER 'root'@'%' IDENTIFIED BY 'root123';
grant all privileges ON *.* to 'root'@'%' with grant option;
flush privileges;
13、修改加密方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root123';
select host, user, authentication_string, plugin from user;
14、重启数据库
quit
systemctl restart mysqld.service
或:
systemctl start mysqld
设置开机自启动
systemctl enable mysqld.service
15、远程navicat连接测试
FAQ
1、错误:依赖检测失败:
libcrypto.so.10()(64bit) 被 mysql-community-libs-8.0.15-1.el7.x86_64 需要
遇到类似的错误的话,可以试试在rpm安装命令后添加
--nodeps --force
如:
rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-devel-8.0.15-1.el7.x86_64.rpm --nodeps --force