centos7.6 mysql8.3 Community版本安装

jianyue0420

已于 2024-04-12 16:54:47 修改

阅读量210

点赞数 3

文章标签： mysql centos

于 2024-03-27 16:42:39 首次发布

本文链接：https://blog.csdn.net/jianyue0420/article/details/137080965

版权

检查是否安装旧版本

查看

rpm -qa | grep mysql
rpm -qa | grep mariadb

卸载

rpm -e --nodeps    mysql包名
rpm -e --nodeps    mariadb包名

下载安装包

#下载安装包  这是x86架构的安装  amd架构的自行找 https://dev.mysql.com/downloads/mysql/
wget https://cdn.mysql.com//Downloads/MySQL-8.3/mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
#解压
tar -xvf mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
#执行安装  报错就跟到提示顺序安装
rpm -ivh mysql-community-common-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.3.0-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.3.0-1.el7.x86_64.rpm
#删除安装源
rm -rf mysql-community*
rm -rf mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar

启动验证

#启动
systemctl start mysqld
#查看版本
mysql --version
#查看密码
cat /var/log/mysqld.log  | grep password	
#登入修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '数据库密码';
#-创建用户并指定密码
CREATE USER u@'%' IDENTIFIED BY '密码';  
#授权
GRANT ALL PRIVILEGES ON *.* TO u@'%' WITH GRANT OPTION;  
#刷新配置
flush privileges;