Linux安装MySQL

由于MySQL在CentOS7中收费了,所以已经不支持MySQL了,取而代之在CentOS7内部集成了mariadb,而安装MySQL的话会和MariaDB的文件冲突,所以需要先卸载掉MariaDB.

⒈卸载MariaDB

rpm -qa | grep mariadb    查询是否安装了MariaDB
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64    强制卸载
yum install vim libaio net-tools    安装MySQL依赖

⒉安装MySQL

  ①下载MySQL官网的repo源

    https://dev.mysql.com/downloads/repo/yum/

  ②安装yum repo文件

rpm -ivh mysql80-community-release-el7-2.noarch.rpm

  执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo mysql-community-source.repo  

  ③更新yum缓存

yum clean all
yum makecache

  ④安装MySQL   

sudo yum install mysql-server

⒊启动MySQL

  ①启动MySQL服务   

systemctl start mysqld.service

  ②查看MySQL服务状态  

systemctl status mysqld.service

  ③将MySQL设为开机启动

systemctl enable mysqld 
systemctl daemon-reload

  ④修改root密码

    ⑴获取默认root密码

      MySQL安装完成之后,在/var/log/mysqld.log文件中给root生成了一个默认密码。

grep 'temporary password' /var/log/mysqld.log

    得到如下内容:

      2019-03-02T10:13:04.628699Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: fIwo)pVrk0r/

    fIwo)pVrk0r/  为默认root密码

    ⑵使用默认的root密码登录并修改   

mysql -u root -p 

MySQL对密码强度要求较高,需要包含大小写字母、数字和特殊字符

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@123';

  ⑤设置MySQL服务器的安全配置

mysql_secure_installation

    Set root password? [Y/n] y                  [设置root用户密码]

    Remove anonymous users? [Y/n] y                 [删除匿名用户]

    Disallow root login remotely? [Y/n] y       [禁止root远程登录]

    Remove test database and access to it? [Y/n] y          [删除test数据库]

    Reload privilege tables now? [Y/n] y            [刷新权限]

  ⑥设置MySQL远程连接    

use mysql;
SELECT user, host, plugin from mysql.user;
update user set host='%' where user='root';
flush privileges;

  ⑦开放3306端口

firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload

  

原文地址:https://www.cnblogs.com/fanqisoft/p/10462508.html