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包
打开网页:https://dev.mysql.com/downloads/repo/yum/
点击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
测试版本选择切换到5.6
vi /etc/yum.repos.d/mysql-community.repo
将MySQL 5.6 enabled=1,MySQL 5.7 enabled=0
#须要那个版本把对应的enabled改为1就可以了。另外的都必须为0。
yum repolist all | grep mysql
出现如下信息代表可以安装mysql了
mysql-connectors-community/x86_64 MySQL Connectors Community ON
下面安装的是mysql5.7(5.6和5.7命令不一样。)
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。 能链接上表明搭建成功。