CentOS7通过Yum方式安装MySQL

Myth丶恋晨 2023-05-30 04:58 31阅读 0赞

**卸载已有的MySQL**

(1) 停掉mysql进程

pkill -9 mysqld

(2) 查看本地安装的mysql

rpm -qa | grep mysql

(3) 卸载本地mysql

//这里有多个, 要一个一个删除
    yum -y remove '上一步显示的软件名'

![在这里插入图片描述][20191107150806353.png]

**重新安装MySQL**

(1) 从mysql官网下载对应版本的rpm安装包

//这个是mysql5.7
    wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

(2) 安装myql

a. 显示安装包名

![在这里插入图片描述][2019110715045966.png]

b. 安装rpm包

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

c. 安装 mysql 服务

yum -y install mysql-server

(3) 修改mysql配置文件(这步可以跳过)

vi /etc/my.cnf

(4) 启动mysql服务

service mysqld restart

(5) 设置开机启动mysql服务

sudo systemctl enable mysqld.service

(6) 修改密码

a. 获取mysql临时密码

grep "password" /var/log/mysqld.log

b. 登录mysql

mysql -u root -p

c. 修改密码

alter user 'root'@'localhost' identified by 'Root!!2019';

d. 刷新权限

flush privileges;

(7) 授权远程访问(先登录mysql)

a. 授权

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'Root!!2019' WITH GRANT OPTION;

b. 刷新权限

FLUSH PRIVILEGES;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdGlhbnhpYW5nX2thb2xh_size_16_color_FFFFFF_t_70]

(8) 配置阿里云服务器安全组规则

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdGlhbnhpYW5nX2thb2xh_size_16_color_FFFFFF_t_70 1]

[20191107150806353.png]: https://img-blog.csdnimg.cn/20191107150806353.png
[2019110715045966.png]: https://img-blog.csdnimg.cn/2019110715045966.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdGlhbnhpYW5nX2thb2xh_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191107150633793.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdGlhbnhpYW5nX2thb2xh,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdGlhbnhpYW5nX2thb2xh_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191107150719147.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpdGlhbnhpYW5nX2thb2xh,size_16,color_FFFFFF,t_70