centos 7.6 安装mysql命令并且解决远程连接问题

0.切换到root用户
su
1.
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
2.
rpm -ivh mysql-community-release-el7-5.noarch.rpm

3.yum -y install mysql-community-server

4.
systemctl restart mysqld.service
netstat -ntlp

5.
mysql_secure_installation

mysql -uroot -p
show databases;
exit

===============================================
遇到的问题
---------------------------
SQLyog Enterprise
---------------------------
错误号码2003

Can't connect to MySQL server on '192.168.126.128' (0)
---------------------------
确定   
---------------------------
解决方案☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆

工具连接错误提示大概意思为连接被拒绝
解决办法:
1,用root账户登录linux
2,打开终端,登录mysql(密码默认不显示)
mysql -uroot -p
2,打开终端,切换到mysql数据库
mysql>use mysql
3,给本地ip赋予连接权限,包括远程访问权限,%百分号表示允许任ip访问数据库(记得+引号)
mysql>grant all privileges on *.* to root@"%" identified by "123456";
4,重新加载权限表
mysql>flush privileges;
5,退出
mysql>exit
6,重启数据库
service mysqld restart
7,关闭防火墙( systemctl stop firewalld.service)
好像不关也可以,记得放行mysql数据库(3306)端口

来自：https://blog.csdn.net/weixin_56569876/article/details/115328675?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1-115328675-blog-113275751.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1-115328675-blog-113275751.pc_relevant_default&utm_relevant_index=2