Linux环境下安装Mysql

Mysql安装

1、下载mysql的repo源

#这是8.0版本的mysql 
#5.0版本使用	https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

2、安装mysql-community-release-el7-5.noarch.rpm包

#5.0版本使用	mysql57-community-release-el7-8.noarch.rpm
rpm -ivh mysql80-community-release-el7-1.noarch.rpm

3、安装mysql

yum install mysql-server

4、启动mysql服务

service mysqld start

5、登录mysql

mysql -u root
##此时会报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

6、先去查询mysql的初始密码

grep password /var/log/mysqld.log
##初始密码*todaP*Rh5Jy
2021-12-01T05:02:12.251715Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: *todaP*Rh5Jy

7、重新登录

mysql -u root -p

8、然后输入密码

Enter password: *todaP*Rh5Jy

9、进入后重新修改密码

mysql> alter user 'root'@'localhost' identified by 'Lxt@123';