此处采用yum安装,说明页面 https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
1、选择Yum Repository 页面 https://dev.mysql.com/downloads/repo/yum/
下载rpm
wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
2、添加Yum repository
sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm
3、检查MySQL Yum repository是否成功安装
yum repolist enabled | grep mysql
4、安装
sudo yum install mysql-community-server
Running transaction Installing : mysql-community-common-5.7.21-1.el7.x86_64 1/7 Installing : mysql-community-libs-5.7.21-1.el7.x86_64 2/7 Installing : mysql-community-client-5.7.21-1.el7.x86_64 3/7 Installing : numactl-libs-2.0.9-6.el7_2.x86_64 4/7 Installing : mysql-community-server-5.7.21-1.el7.x86_64 5/7 Installing : mysql-community-libs-compat-5.7.21-1.el7.x86_64 6/7 Erasing : 1:mariadb-libs-5.5.52-1.el7.x86_64 7/7 Verifying : mysql-community-client-5.7.21-1.el7.x86_64 1/7 Verifying : mysql-community-libs-compat-5.7.21-1.el7.x86_64 2/7 Verifying : mysql-community-libs-5.7.21-1.el7.x86_64 3/7 Verifying : numactl-libs-2.0.9-6.el7_2.x86_64 4/7 Verifying : mysql-community-server-5.7.21-1.el7.x86_64 5/7 Verifying : mysql-community-common-5.7.21-1.el7.x86_64 6/7 Verifying : 1:mariadb-libs-5.5.52-1.el7.x86_64 7/7 Installed: mysql-community-libs.x86_64 0:5.7.21-1.el7 mysql-community-libs-compat.x86_64 0:5.7.21-1.el7 mysql-community-server.x86_64 0:5.7.21-1.el7 Dependency Installed: mysql-community-client.x86_64 0:5.7.21-1.el7 mysql-community-common.x86_64 0:5.7.21-1.el7 numactl-libs.x86_64 0:2.0.9-6.el7_2 Replaced: mariadb-libs.x86_64 1:5.5.52-1.el7 Complete! |
5、运行mysql
systemctl start mysqld
查看mysql是否运行
systemctl start mysqld
6、获取连接初始密码
sudo grep 'temporary password' /var/log/mysqld.log
7、登入mysql
mysql -uroot -p
8、修改登入密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'pwd';
pwd密码要求
至少一个大写,一个小写,一个数字,一个特殊字符,最少8位
9、设置外网可访问
9.1 use mysql;
9.2 查询host输入: select user,host from user;
9.3 创建host(如果有"%"这个host值,则跳过这一步)
如果没有"%"这个host值,就执行下面这两句:
mysql> update user set host='%' where user='root';
mysql> flush privileges;
9.4 授权用户
(1)任意主机以用户root和密码pwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION;
mysql> flush privileges;
(2)指定IP为(如192.168.1.100)的主机以用户tuser和密码tpwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'tuser'@'192.168.1.100' IDENTIFIED BY 'tpwd' WITH GRANT OPTION;
mysql> flush privileges;
至此外网可以访问mysql了