centos7/linux编译安装mysql8最新版

linux服务器一台  # centos/redhat
mysql8.0.28软件包一个  # 其余版本类似
navicat 客户端工具
复制

[yunweijia@localhost ~]$ sudo setenforce 0  # 管理selinux，这里是临时关闭，要永久关闭请查看我之前的文章
[yunweijia@localhost ~]$ sudo systemctl stop firewalld.service  # 关闭防火墙
[yunweijia@localhost ~]$ sudo systemctl disable firewalld.service
Removed symlink etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[yunweijia@localhost ~]$ sudo rpm -qa | grep mysql  # 检查之前时候有mysql安装的内容，如果有请使用rpm -e命令进行卸载
[yunweijia@localhost ~]$ rpm -qa| grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[yunweijia@localhost ~]$ sudo rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
[yunweijia@localhost ~]$ sudo yum -y install libaio  # mysql依赖
[yunweijia@localhost ~]$ sudo yum -y install perl  # mysql依赖
[yunweijia@localhost ~]$ sudo yum -y install net-tools  # mysql依赖
复制

[yunweijia@localhost ~]$ yum -y install ncurses-compat-libs
复制

[yunweijia@localhost jier]$ ls
mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar
[yunweijia@localhost jier]$ pwd
/home/yunweijia/jier
[yunweijia@localhost jier]$
复制

[yunweijia@localhost ~]$ cd home/yunweijia/jier/
[yunweijia@localhost jier]$ tar xf mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar 
[yunweijia@localhost jier]$ sudo rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm 
[yunweijia@localhost jier]$ sudo rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm 
[yunweijia@localhost jier]$ sudo rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm 
[yunweijia@localhost jier]$ sudo rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm 
[yunweijia@localhost jier]$ sudo rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm 
[yunweijia@localhost jier]$ sudo rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm
复制

[yunweijia@localhost jier]$ sudo systemctl status mysqld  # 查看启动状态
[yunweijia@localhost jier]$ sudo systemctl start mysqld  # 启动
复制

[yunweijia@localhost jier]$ sudo grep "temporary password" var/log/mysqld.log
复制

[yunweijia@localhost jier]$ mysql -uroot -p
复制

mysql> alter user 'root'@'localhost' identified by 'Yunweijia@123';  # 修改root密码为“Yunweijia@123”
Query OK, 0 rows affected (0.01 sec)




mysql> flush privileges;  # 刷新配置
Query OK, 0 rows affected (0.00 sec)


mysql>
复制

mysql> create user yunweijia@'%' identified  by 'Yunweijia@123';  # 新建用户yunweijia
Query OK, 0 rows affected (0.01 sec)




mysql> grant all privileges on *.* to yunweijia@'%' with grant option;  # 给新建用户进行授权
Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;  # 刷新权限
Query OK, 0 rows affected (0.00 sec)


mysql>
复制