下载页面:https://dev.mysql.com/downloads/repo/yum/
此处采用yum安装,说明页面 MySQL :: A Quick Guide to Using the MySQL Yum Repository
1、选择Yum Repository 页面 https://dev.mysql.com/downloads/repo/yum/
下载rpm
2、在 /mydata/mysql 目录下下载rpm文件
wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
3、添加Yum repository
sudo rpm -Uvh mysql80-community-release-el7-7.noarch.rpm
4、检查MySQL在Yum repository默认版本
[root@shuidi-101 mysql]# yum repolist enabled | grep mysql
5、安装
sudo yum install mysql-community-server
6、启动mysql
systemctl start mysqld
7、检查mysql是否启动成功
systemctl status mysqld
8、获取默认密码
[root@shuidi-101 mysql]# sudo grep 'temporary password' /var/log/mysqld.log
2022-11-10T06:33:04.738089Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: o!-Vavop<1nX
默认密码:o!-Vavop<1nX
9、修改默认密码
[root@shuidi-101 mysql]# mysql -uroot -p
Enter password:
输入密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
10、设置外网可访问
use mysql;
查询host输入
select user,host from user;
11、创建host(如果有"%"这个host值,则跳过这一步)
如果没有"%"这个host值,就执行下面这两句:
mysql> update user set host='%' where user='root';
mysql> flush privileges;
授权用户
(1)任意主机以用户root和密码pwd连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
Grant all privileges on *.* to 'root'@'%';
FLUSH PRIVILEGES;
exit;