centos 安装mysql

选择 mysql yum源    https://repo.mysql.com/yum/

安装

wget https://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql57-community-release-el7-10.noarch.rpm

rpm -ivh mysql57-community-release-el7-10.noarch.rpm

yum update

yum install mysql-server

 

初始化

mysqld --initialize

启动

systemctl start mysqld

查看状态

systemctl status mysqld

开机启动

systemctl enable mysqld
systemctl daemon-reload

获取root密码

grep 'temporary password' /var/log/mysqld.log

修改密码

mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码!';

远程连接授权

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '您的数据库密码' WITH GRANT OPTION;

flush privileges;