centos 安装mysql

centos 安装mysql

1.保证没有mysql相关东西（注意删除的都是前面查出来的路径）

rpm -qa | grep mysql

rpm -e --nodeps 

whereis mysql

find / -name mysql

rm -rf 

2.下载相关

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum update

yum install mysql-server

3.权限设置

chown mysql:mysql -R /var/lib/mysql

4.初始化 MySQL

mysqld --initialize

5.启动 MySQL

systemctl start mysqld

6.查看 MySQL 运行状态

systemctl status mysqld

7.验证安装

mysqladmin --version

8.创建root用户密码

mysqladmin -u root password "new_password";

9.连接

mysql -u root -p

10.设置可远程访问

grant all privileges on *.* to root@"%" identified by "你的密码";

grant all privileges on *.* to root@"localhost" identified by "你的密码";

flush privileges;

有疑问

扫描公众号，了解更多实例分享：

参考

https://www.runoob.com/mysql/mysql-install.html
https://www.cnblogs.com/ccsert/p/12296213.html
https://www.jianshu.com/p/276d59cbc529
设置远程访问