Linux安装MySQL过程及远程无法连接解决办法

Linux安装MySQL数据库
1、下载和安装mysql源
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2、安装mysql源
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
3、安装mysql
sudo yum install mysql-community-server
4、启动
systemctl start mysqld.service
5、查看状态
systemctl status mysqld.service
6、关闭
systemctl stop mysqld.service
7、重启
systemctl restart mysqld.service
8、获取初始登录密码
grep 'temporary password' /var/log/mysqld.log
9、登录数据库
mysql -uroot -p
输入密码
10、修改密码（数字、大小写字母、特殊字符）
ALTER USER 'root'@'localhost' IDENTIFIED BY '10xingLei@#';
11、设置编码
cd /etc
编辑my.cnf文件
[mysqld]
character_set_server=utf8
init-connect='SET NAMES utf8'
12、关闭防火墙
service firewalld stop
13、远程连接失败解决办法（确保账号密码正确）
登录MySQL数据库
use mysql;
select Host,User from user;
update user set Host = '%' where User = 'root';
远程连接成功