安装MySQL
需要安装MySQL5以上版本,进入官网查看,官网地址:跳转链接.
选择版本下载:
wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
安装下载的包(安装完后可删除):
yum -y install mysql80-community-release-el7-7.noarch.rpm
安装MySQL服务端:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-server
启动MySQL服务
systemctl start mysqld.service
查看MySQL运行状态
systemctl status mysqld.service
显示running则表示MySQL正常运行:
修改登录密码
安装MySQL时会随机生成密码,使用该密码登录MySQL:
grep "password" /var/log/mysqld.log
登录MySQL:
mysql -uroot -p
修改root的登录密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mysql_123';
MySQL开启远程访问权限
mysql8.0之后,只需要按照步骤执行代码即可:
create user root@'%' identified by 'Mysql_123';
grant all privileges on *.* to root@'%' with grant option;
mysql8.0之前:
grant all privileges on *.* to 'root'@'%' identified by 'Mysql_123' with grant option;
最后记得权限更新
flush privileges;
至此已经成功在云服务器上安装MySQL。