centos yum 安装mysql8 修改密码

柔光的暖阳◎ 2022-01-14 10:23 304阅读 0赞

##### 官网地址：[https://dev.mysql.com/downloads/repo/yum/][https_dev.mysql.com_downloads_repo_yum] #####

可以在以上地址选择想要的版本将下面的链接后面部分替换  
![替换地址][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODY2NDg2_size_16_color_FFFFFF_t_70]

wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

yum update

安装：

yum install mysql-server

![安装成功][20190614103818909.png]  
初始化：

mysqld --initialize

权限设置：

chown mysql:mysql -R /var/lib/mysql

启动mysql：

systemctl start mysqld

查看运行状态：

systemctl status mysqld

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODY2NDg2_size_16_color_FFFFFF_t_70 1]

验证安装：

mysqladmin --version

![在这里插入图片描述][20190614104445575.png]  
登陆后报下面的错误:  
![在这里插入图片描述][20190614105101442.png]  
解决方法：

停止服务
    systemctl stop mysqld
    编辑my.cnf
    vi /etc/my.cnf
    在末尾追加
    skip-grant-tables
    启动服务
    systemctl start mysqld.service
    登录mysql
    mysql -u root
    刷新权限
    flush privileges;
    修改密码
    alter user 'root'@'localhost'IDENTIFIED BY '你的新密码，大写小写符号组合';
    接下来删除skip-grant-tables 然后重启mysql即可

![在这里插入图片描述][20190614111939894.png]

[https_dev.mysql.com_downloads_repo_yum]: https://dev.mysql.com/downloads/repo/yum/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODY2NDg2_size_16_color_FFFFFF_t_70]: /images/20220114/a1828d40901b440598d9bcec3fb831b1.png
[20190614103818909.png]: /images/20220114/d053a8b9614a4adabfee88529d3098fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODY2NDg2_size_16_color_FFFFFF_t_70 1]: /images/20220114/e3ee78211a4644d894d1f8919c643adc.png
[20190614104445575.png]: /images/20220114/f3e74090a7bb46b0bb699cefa7835e25.png
[20190614105101442.png]: /images/20220114/25b9f142e1f341b5a9d02f4761169098.png
[20190614111939894.png]: /images/20220114/6bbefd535ceb44b9a9d1d9d6ae30ce00.png