Centos Mysql安装

删除MariaDB

查询是否安装了mariadb

[root@localhost ~]# rpm -aq | grep mariadb

列出信息

删除mariadb相关套件

[root@localhost ~]# rpm -e --nodeps mariadb-libs-后面加上面显示的版本号

安装依赖

[root@localhost ~]# yum install perl -y

[root@localhost ~]# yum install net-tools -y

[root@localhost ~]# yum install libncurses*

[root@localhost ~]# yum install libaio

安装MySQL

新建文件夹，用于存放MySQL

[root@localhost usr]# mkdir /usr/java/mysql

[root@localhost usr]# mkdir /usr/java/package

[root@localhost usr]# cd /usr/java/package

下载安装包

[root@localhost package]# wget http://dev.mysql.com/get/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar

解压缩安装包

[root@localhost package]# tar xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar -C /usr/mysql

依次执行以下命令

[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm

[root@localhost mysql]# rpm -ivh mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm

[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm

[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm

[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

判断是否安装成功

[root@localhost mysql]# rpm -aq | grep mysql-community-server

首先要启动：

[root@localhost mysql]#systemctl start mysqld

[root@localhost mysql]#systemctl status mysqld

出现以下界面说明已经开启

重载所有修改过的配置文件：

[root@localhost mysql]# systemctldaemon-reload

重启服务：

[root@localhost mysql]# systemctl restart mysqld

开机自启：

[root@localhost mysql]# systemctl enablemysqld

设置密码

1.安装完毕后，/var/log/mysqld.log 文件中会自动生成一个随机的密码，我们需要先取得这个随机密码，以用于登录 MySQL 服务端：

[root@localhost mysql]# grep "temporarypassword" /var/log/mysqld.log

[root@localhost mysql]# mysql -uroot -p

MySQL 密码安全策略：

设置密码强度为低级：

set globalvalidate_password_policy=0;

设置密码长度最低为4：

set globalvalidate_password_length=4;

修改本地密码：

alteruser 'root'@'localhost' identified by 'ac1d78499bf754b4';

远程登录

以新密码登陆 MySQL：

mysql-uroot -pX94Lj&qwcu

创建用户：

create user 'java_mer_release'@'%'identified by 'ntsFYWAJMtyBmsa7';

允许远程连接：

grant all privilegeson *.* to 'root'@'%' with grant option;

grant all privileges on *.* to 'root'@'%' identified by 'ac1d78499bf754b4' with grantoption;

grant all privileges on *.* to 'java_mer_release'@'%' with grant option;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'ac1d78499bf754b4';

ALTER USER 'java_mer_release'@'%' IDENTIFIED WITH mysql_native_password BY 'ntsFYWAJMtyBmsa7';

刷新权限：

flushprivileges;