centos7下安装mysql数据库，详细步骤，亲测有效

在centos下安装MySQL数据库
首先下载mysql包

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm #yum安装
yum -y install mysql-community-server #mysql服务器安装

然后启动mysql

systemctl start  mysqld.service
systemctl status mysqld.service
grep "password" /var/log/mysqld.log
mysql -uroot -p

更改用户密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
grant all privileges on *.* to 'root'@'192.168.0.1' identified by 'password' with grant option;
flush privileges; 
exit

开启端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --add-port=8080/tcp --permanent
firewall-cmd --reload

如果重启草 Job for …的错误

cd /var/lib
chown root.root mysql
ls -ld mysql
rm -rf mysql
ls #查看mysql时候已经删除
mysqld --initialize-insecure --user=mysql  #初始化
systemctl start  mysqld.service

即可重置mysql

cat /var/log/mysqld.log 查看日志检查报错

好了，打完收工