centos7 yun安装mysql_centos7 yum安装mysql

下载最新的mysql8，mysql80-community-release-el7-1.noarch.rpm

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

yum -y install mysql-server

默认配置文件路径：

配置文件：/etc/my.cnf

日志文件：/var/log/var/log/mysqld.log

服务启动脚本：/usr/lib/systemd/system/mysqld.service

socket文件：/var/run/mysqld/mysqld.pid

重启mysql服务

systemctl restart mysqld.service

查找默认密码

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

用默认密码登录

mysql -u root -p

出现问题

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

查看启动权限

ls -ld /var/run/mysqld/

因为目录没有权限，改变用户

chown mysql.mysql /var/run/mysqld/

启动还是失败，查看状态

systemctl status mysqld.service

无结果，打开/etc/my.cnf 文件，查看日志位置log-error=/var/log/mysqld.log

cat /var/log/mysqld.log

发现端口似乎被占用

2018-07-19T06:40:14.780868Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use

2018-07-19T06:40:14.780924Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?

查看端口占用

lsof -i:3306

发现竟然是mysql占用，瞬间崩溃，不停kill后重启终于领悟，原来服务器已经装过禅道，端口被占用了，改端口

vim /etc/my.cnf

在[mysqld]下添加

port=3309

启动服务

systemctl start mysqld.service

用默认密码登录

mysql -u root -p

强制要求改密码，必须大小写、符号、数字

alter user 'root'@'localhost' identified by '×××××';

允许远程连接

打开防火墙端口

firewall-cmd --permanent --add-port=3309/tcp

firewall-cmd --reload

在mysql下

use mysql；

update user set Host='%' where User = 'root';

重启服务

systemctl restart mysqld.service

mysql 5.7.25 安装方法

上官网找到最新的rpm连接地址

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

报错：

warning: mysql80-community-release-el7-3.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

mysql57-community-release conflicts with mysql80-community-release-el7-3.noarch

由于昨晚安装了旧版本，所以先删除

rpm -qa | grep mysql

mysql57-community-release-el7-11.noarch

rpm -e --nodeps mysql57-community-release-el7-11.noarch

修改repo

vim /etc/yum.repos.d/mysql-community.repo

让80不可用，让57可用,修改两个enabled参数

# Enable to use MySQL 5.7

[mysql57-community]

name=MySQL 5.7 Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/

enabled=1

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql80-community]

name=MySQL 8.0 Community Server

baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/

enabled=0

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

yum install mysql-community-server