yum 安装mysql数据库_Centos7下使用yum安装mysql数据库

Centos7下使用yum安装mysql数据库

环境

[root@nginxphp ~]# uname -a

Linux nginxphp 3.10.0-514.el7.x86_64

[root@nginxphp ~]# cat /etc/redhat-release

CentOS Linux release 7.3.1611 (Core)

centos7默认库没有mysql 添加mysql官方库

一、下载安装官方提供的yum rpm包

点击Red Hat Enterprise Linux 7 / Oracle Linux 7 (Architecture Independent), RPM Package后面的download，进入新的页面点击No thanks, just start my download.就可以看到下载源地址了。

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum安装mysql

yum -y install mysql-community-server

启动并配置mysql

systemctl start mysqld

#启动mysql

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

# for root@localhost: #;eli&h/I2pq

#查看默认mysql密码

mysql -uroot -p'#;eli&h/I2pq'

#登录mysql

mysql> set global validate_password_policy=0;

mysql> set global validate_password_length=1;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

#修改为简单密码

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;

#开启远程登录

测试

本地用Navicat连接远程mysql。 能链接上表明搭建成功。