1、下载mysql的rpm包
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2、安装该rpm包
rpm -ivh mysql-community-release-el7-5.noarch.rpm
3、安装mysql
yum install mysql-server
加入开机启动
systemctl enable mysqld
启动mysql
systemctl enable mysqld
4、初始化配置或重置密码
mysql_secure_installation
第一次执行没有初始密码,按回车即可
Enter current password for root (enter for none):
设置/修改密码
Change the root password? [Y/n] y
New password:
Re-enter new password:
删除匿名用户
Remove anonymous users? [Y/n] y
禁止远程登录
Disallow root login remotely? [Y/n] n
删除test数据库
Remove test database and access to it? [Y/n] y
刷新权限
Reload privilege tables now? [Y/n] y
4、登录
mysql -uroot -p密码
5、授权
mysql命令行下执行:
grant all PRIVILEGES on *.* to 'root'@'%' identified by '密码' WITH GRANT OPTION;
刷新权限
flush privileges;
6、开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙
firewall-cmd --reload
注意:如果使用的是阿里云服务器,还需要登录到阿里云后台开放3306端口
7、添加用户并授权(扩展)
mysql命令行下执行:
CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
授权(下面示例是给该用户赋予操作mytest数据库的所有权限)
grant all PRIVILEGES on mytest.* to '用户名'@'%' identified by '密码' WITH GRANT OPTION;