一、MYSQL8.0.34
1、检查操作系统版本
cat /proc/version 或者uname -a
2、操作系统选择下载
查看操作系统信息，我的系统版本是el7 即liunx/centos 7系列
3、下载对应操作系统本班
a、地址：https://dev.mysql.com/downloads/mysql/
b、我的Linux版本是el7
c、mysql选择版本8.0.34，操作系统选择Red hat linux,版本选择 linux7 x86 64bit
# 下载 RPM Bundle（推荐，包含所有组件）
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.34-1.el7.x86_64.rpm-bundle.tar
4、放入指定目录
/usr/local/mysql8034
5、解压命令
tar -xvf mysql-8.0.34-1.el7.x86_64.rpm-bundle.tar
6、安装前要卸载linux自带的数据库
#卸载mariadb
#检查是否安装mariadb
rpm -qa|grep mariadb
#卸载
rpm -e --nodeps mariadb-libs
#再次检查
rpm -qa|grep mariadb
yum remove -y mysql-libs
#查看防火墙
firewall-cmd --state
#关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld
#授权
setenforce 0
sed -i '/SELINUX/s/enforcing/disabled/' /etc/selinux/config
##安装依赖
yum -y install openssl-devel
#重启
reboot
7、开始安装
a、先安装全局的依赖mysql-community-common
rpm -ivh mysql-community-common-8.0.34-1.el7.x86_64.rpm
b、安装mysql-community-icu-data-files
rpm -ivh mysql-community-icu-data-files-8.0.34-1.el7.x86_64.rpm
c、安装mysql-community-client-plugins
rpm -ivh mysql-community-client-plugins-8.0.34-1.el7.x86_64.rpm
d、安装mysql-community-libs
rpm -ivh mysql-community-libs-8.0.34-1.el7.x86_64.rpm
e、安装mysql-community-client
rpm -ivh mysql-community-client-8.0.34-1.el7.x86_64.rpm
f、安装mysql-community-server
rpm -ivh mysql-community-server-8.0.34-1.el7.x86_64.rpm
g、安装mysql-community-libs-compat
rpm -ivh mysql-community-libs-compat-8.0.34-1.el7.x86_64.rpm
h、安装mysql-community-devel
rpm -ivh mysql-community-devel-8.0.34-1.el7.x86_64.rpm
针对linux8安装
rpm -ivh mysql-community-common-8.0.34-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.34-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.34-1.el8.x86_64.rpm
yum install mysql-community-devel-8.0.34-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.34-1.el8.x86_64.rpm
yum install net-tools
rpm -ivh mysql-community-icu-data-files-8.0.34-1.el8.x86_64.rpm
yum install mysql-community-server-8.0.34-1.el8.x86_64.rpm
如果rpm -ivh安装失败，就使用yum install
8、启动mysql数据库和关闭数据库
systemctl start mysqld.service
systemctl stop mysqld.service
systemctl status mysqld.service
9、查看启动进程
ps -ef | grep mysql
lsof -i :3306
10、查找初始密码
grep 'temporary password' /var/log/mysqld.log
11、修改初始密码
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '159952@Way';
flush privileges;
12、登录数据库测试新密码
mysql -u root -p
13、设置开机启动服务
systemctl enable mysqld.service
14、创建用户
create user 'zblog'@'%' identified by 'Zblog@2025';
15、授权所有库所有操作权限（with grant option可以将自己的权限授权给别人）
grant all privileges on *.* to 'zblog'@'%' with grant option;
flush privileges;
数据库：testdb
grant all privileges on testdb.* to 'zblog'@'%' with grant option;
flush privileges;
授权某库权限
grant all privileges on rydev.* to 'zblog'@'%' with grant option;
grant all privileges on ryconfig.* to 'zblog'@'%' with grant option;
grant all privileges on ryseata.* to 'zblog'@'%' with grant option;
flush privileges;
16、解决连接MYSQL1251问题
alter user 'zblog'@'%' identified by 'ry2023$DEV' password expire never;
alter user 'zblog'@'%' identified with mysql_native_password by 'ry2023$DEV';
flush privileges;
alter user 'bsjy'@'%' identified by 'Bsjy1219$' password expire never;
alter user 'bsjy'@'%' identified with mysql_native_password by 'Bsjy1219$';
17、授权某用户某数据库权限
例如:数据库testdb
grant select,insert,update,delete,create,alter,drop,index on testdb.* to 'ruoyi'@'%';
18、删除用户
DROP USER 'rydba'@'%';
19、MYSQL优化
vim /etc/my.cnf
参考https://blog.51cto.com/u_15906694/5922671
20、创建数据库
create database pakclouddev CHARSET utf8mb4 collate utf8mb4_general_ci;
21、修改大小写
vim /etc/my.cnf
lower_case_table_names = 1
default-authentication-plugin=mysql_native_password
22、设置大小写问题后启动失败方法
rm -rf /var/lib/mysql/
mkdir /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql
chmod -R 750 /var/lib/mysql
/usr/sbin/mysqld --initialize --user=root --lower-case-table-names=1
重新启动
create database pak_cloud_nacos_dev CHARSET utf8mb4 collate utf8mb4_general_ci;
create database pak_cloud_seata_dev CHARSET utf8mb4 collate utf8mb4_general_ci;
create database pak_cloud_xxl_job_dev CHARSET utf8mb4 collate utf8mb4_general_ci;
create database pak_cloud_dev CHARSET utf8mb4 collate utf8mb4_general_ci;
grant all privileges on pak_cloud_nacos_dev.* to 'pakcloud'@'%' with grant option;
grant all privileges on pak_cloud_seata_dev.* to 'pakcloud'@'%' with grant option;
grant all privileges on pak_cloud_xxl_job_dev.* to 'pakcloud'@'%' with grant option;
grant all privileges on pak_cloud_dev.* to 'pakcloud'@'%' with grant option;
flush privileges;
网友评论