Centos7 安装Mysql5.7全过程
一、安装MySQL YUM资源库:
安装MySQL YUM资源库
yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
二、安装MySQL 5.7:
yum install -y mysql-community-server
三、启动MySQL服务器和MySQL的自动启动(在启动MySQL服务器这前我用yum install xulrunner.i686安装了32位环境):
systemctl start mysqld.service
systemctl enable mysqld.service
四、查看MySQL运行状态:
systemctl status mysqld.service
五、此时MySQL已经开始正常运行,不过要想进入MySQL还得先找出此时root用户的密码,通过如下命令可以在日志文件中找出密码:
grep "password" /var/log/mysqld.log
六、登录MySQL数据库:
/usr/bin/mysql -u root
七、修改MySQL数据库原始密码:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
八、开启MySQL数据库远程访问
mysql> grant all privileges on *.* to 'root'@'192.168.0.1' identified by 'password' with grant option;
;
注:password–是你设置你的mysql远程登录密码;开启的IP是 192.168.19.128,如要开启所有的,用%代替IP。
九、刷新权限
flush privileges;
十、退出
exit