环境:
阿里云服务器(centos7)
1、下载rpm包并安装
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
2、安装mysql-community-server
yum install mysql-community-server
3、开启mysql服务
systemctl start mysqld.service
4、获取初始密码
cat /var/log/mysqld.log | grep password
5、首次登陆数据库
mysql -u root -ph2ug?K?YiMU?
mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxx';#注意位数和种类至少大+写+小写+符号+数字
6、配置防火墙或者关闭防火墙
配置防火墙
firewall-cmd --zone=public --list-ports 查看所有打开的端口
firewall-cmd --zone=public --add-port=80/tcp --permanent 开启一个端口,添加--permanent永久生效,没有此参数重启后失效
firewall-cmd --permanent --add-port=80/tcp 开放端口80
firewall-cmd --permanent --remove-port=80/tcp 移除端口80
firewall-cmd --reload 重启防火墙,修改后重启防火墙生效
关闭防火墙
systemctl stop firewalld
systemctl disable firewalld
7、开启mysql远程服务,并使用Navicat 连接
连接过程报错拒绝连接,配置阿里云安全组
8、建立自己的数据库并允许远程连接
mysql>update user set host='%' where user='root';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
9、允许从任何主机连接至数据库
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;