JZTXT

Linux安装mysql8

发布时间 2023-11-24 13:53:21作者: ifiwereaboy

1.更新下yum

[root@hadoop001 mysql]# yum -y update

2.确认系统版本（），从官网下载https://dev.mysql.com/downloads/repo/yum/对应的安装包

mysql80-community-release-el7-11.noarch.rpm，进行本地安装

[root@hadoop001 mysql]# ls
mysql80-community-release-el7-11.noarch.rpm
[root@hadoop001 mysql]# yum localinstall mysql80-community-release-el7-11.noarch.rpm

2.安装 mysql-community-server

[root@hadoop001 mysql]# yum -y install mysql-community-server

 3.启动mysql，并从日志中查看初始密码

[root@hadoop001 mysql]# systemctl start mysqld
[root@hadoop001 mysql]# cat /var/log/mysqld.log

 4.接下来修改初始密码

 失败了，咋回事？

换种方式，先改下文件，添加 skip-grant-tables

[root@hadoop001 mysql]# vim /etc/my.cnf 

 然后重启mysql

[root@hadoop001 mysql]# systemctl restart mysqld;

 现在可以不输入密码直接回车进入mysql

[root@hadoop001 mysql]# mysql -u root -p

 修改密码，要符合规定，记得flush privileges一下

mysql> alter user 'root'@'%' identified by 'mysql@123';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;

5.删除 skip-grant-tables，重启mysql,就可以用新密码进去了