1. 在线安装MySQL数据库
-
替换yum源
curl -o /etc/yum.repos.d/CentOS-Base.repo mirrors.163.com/.help/CentOS7-Base-163.repo
yum clean all yum makecache
-
下载rpm文件
yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
-
安装MySQL数据库
yum install mysql-community-server -y
2.数据库操作
-
修改MySQL目录权限
chmod -R 777 /var/lib/mysql/
-
初始化MySQL
mysqld --initialize chmod -R 777 /var/lib/mysql/*
-
启动MySQL
systemctl start mysqld.service
-
查看初始密码
grep 'temporary password' /var/log/mysqld.log
-
登陆数据库之后,修改默认密码
mysql -u root -p alter user user() identified by "abc123456";
-
允许远程使用root帐户
select host,user from user; UPDATE user SET host = '%' WHERE user ='root'; FLUSH PRIVILEGES;
-
允许远程访问MySQL数据库(/etc/my.cnf)
character_set_server = utf8 bind-address = 0.0.0.0
-
开启防火墙3360端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent firewall-cmd --reload
注意:云服务器注意开放3306端口