Centos7 MySQL-5.5.42数据库安装并设置能够远程连接

其实现在已经到8了，但是8太新了很多时候并不好用，这里还是用的5。
MySQL-5.5.42-1.linux2.6.x86_64.rpm-bundle.tar文件下载
https://downloads.mysql.com/archives/community/

拷入MySQL-5.5.42-1.linux2.6.x86_64.rpm-bundle.tar文件到/root/mysql下

tar -xvf MySQL-5.5.42-1.linux2.6.x86_64.rpm-bundle.tar
rpm -ivh MySQL-server-5.5.42-1.linux2.6.x86_64.rpm 
rpm -ivh MySQL-client-5.5.42-1.linux2.6.x86_64.rpm
service mysql start
/usr/bin/mysql_secure_installation

根据提示选择y或n，123456那个是密码，可以设别的

Set root password? [Y/n] y
New password: 123456
Re-enter new password: 123456
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] n
Reload privilege tables now? [Y/n] y

mysql -u root -p
use mysql
select host,user,password from user;
update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'（出现了这句报错不用管）
flush privileges;