centos安装mysql

 

 卸载：

检查安装的mysql 软件
[root@ chenerdui]# rpm -qa | grep -i mysql

yum remove mysql-community-common-8.0.18-1.el7.x86_64
yum remove mysql-community-libs-compat-8.0.18-1.el7.x86_64
yum remove mysql-community-client-8.0.18-1.el7.x86_64
yum remove mysql-community-libs-8.0.18-1.el7.x86_64
yum remove mysql80-community-release-el7-3.noarch

卸载参考 https://www.cnblogs.com/leelice/p/10728129.html

安装参考：https://www.cnblogs.com/luohanguo/p/9045391.html

 mysql8 会有一些新语法 问题 ，使用 mysql 5.7 比较成熟稳定

 

mysql 常用服务命令：【https://blog.csdn.net/xufengzhu/article/details/81110982】

1.启动命令

[root@xufeng Desktop]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
2.关闭命令

[root@xufeng ~]# service mysqld stop
Redirecting to /bin/systemctl stop mysqld.service
3.重启命令

[root@xufeng ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service

4.查看服务状态

[root@xufeng ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
————————————————

 

 ERROR 1130:mysql 1130连接错误的有效解决方法（远程连接）

mysql -u root -p

mysql>use mysql;

mysql>select 'host' from user where user='root';

mysql>update user set host = '%' where user ='root';

mysql>flush privileges;

mysql>select 'host'   from user where user='root';

 

 

安装mysql之后 开放 远程访问 

解决CentOS 7安装mysql后3306端口不通

https://www.cnblogs.com/love-wife/p/10903876.html