CentOS7安装mysql8

安装包准备

下载mysql8 rpm包,地址:https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

安装

执行命令,安装以下rpm

yum install -y mysql-community-client-8.0.33-1.el7.x86_64.rpm \
mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm \
mysql-community-common-8.0.33-1.el7.x86_64.rpm \
mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm \
mysql-community-libs-8.0.33-1.el7.x86_64.rpm \
mysql-community-libs-compat-8.0.33-1.el7.x86_64.rpm \
mysql-community-server-8.0.33-1.el7.x86_64.rpm

配置

编辑 /etc/my.cnf
添加 default-authentication-plugin=mysql_native_password

[mysqld]
default-authentication-plugin=mysql_native_password

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

修改密码

重启mysql

systemctl restart mysqld

获取临时密码

cat /var/log/mysqld.log | grep -i password

登录mysql,修改root密码

mysql -u root -p

ALTER USER USER() IDENTIFIED BY 'C@p19U#qfo';
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容