xixiNote

Appearance

Linux mysql安装包安装 ​

TIP

安装包在官网下载MySQL :: Download MySQL Community Server (Archived Versions)

本次安装的所有用到的压缩包都在/root目录下

本次安装mysql以5为例

名称版本描述下载地址
mysql5mysql-5.7.17-1.el7.x86_64.rpm-bundle.tarmysql5安装包下载
mysql8mysql-8.0.23-1.el7.x86_64.rpm-bundle.tarmysql8安装包下载
目录

WARNING

首先卸载已经存在的数据库

卸载mariadb ​

查看本机是否存在自带mariadb

shell
rpm -qa | grep mariadb
rpm -qa | grep mariadb

如果有，则强制卸载,后面的xx是你查询出来的名称

shell
rpm -e --nodeps XXXXXXXXXX
rpm -e --nodeps XXXXXXXXXX

解压 mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar

shell
cd /root
tar -xvf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar -C /opt/module
cd /root
tar -xvf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar -C /opt/module

进入/opt/module

shell
cd /opt/module
cd /opt/module

安装 ​

shell
rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm --force --nodeps

检查是否安装成功

shell
rpm -qa | grep mysql
rpm -qa | grep mysql

启动服务 ​

shell
systemctl daemon-reload	#重载所有修改过的配置文件
systemctl start mysqld	#开启服务
systemctl enable mysqld #开机自启 若不成功也不影响
systemctl daemon-reload	#重载所有修改过的配置文件
systemctl start mysqld	#开启服务
systemctl enable mysqld #开机自启 若不成功也不影响

登录mysql数据库 ​

获取root初始密码

shell
grep "temporary password" /var/log/mysqld.log
grep "temporary password" /var/log/mysqld.log

登录，并输入密码

shell
mysql -uroot -p
mysql -uroot -p

修改密码 ​

设置密码强度为低级

sql
set global validate_password_policy=0;
set global validate_password_policy=0;

设置密码长度

sql
set global validate_password_policy=4;
set global validate_password_policy=4;

修改用户密码

sql
alter user 'root'@'localhost' identified by '123456';
alter user 'root'@'localhost' identified by '123456';

退出

sql
exit
exit

TIP

做到这一步安装其实已经算完成了，不过为了后期更方便使用mysql，我们需要继续进行以下操作

设置远程登录 ​

以新密码登录mysql

shell
mysql -uroot -p123456
mysql -uroot -p123456

创建用户

sql
create user 'root'@'%' identified by '123456';
create user 'root'@'%' identified by '123456';

允许远程连接

sql
grant all privileges on *.* to 'root'@'%' with grant option;
grant all privileges on *.* to 'root'@'%' with grant option;

刷新权限

sql
flush privileges
flush privileges