rpm -qa | grep mysql
2.下载和安装mysql源
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
3.安装mysql源
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
4.查看/etc/yum.repos.d/下多了两个mysql的repo
mysql-community.repo mysql-community-source.repo
5.查看mysql相关资源
yum repolist enabled | grep "mysql.*-community.*"
6.选择masql版本
sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community
7.安装mysql
sudo yum install mysql-community-server
8.启动
systemctl start mysqld.service
systemctl status mysqld.service
9.停止
systemctl stop mysqld.service
10.重启
systemctl restart mysqld.service
11.修改密码及登录
grep 'temporary password' var/log/mysqld.log
mysql -uroot -p
set global validate_password_policy=LOW;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
12.查看编码
SHOW VARIABLES LIKE 'character%';
13.设置编码
编辑/etc/my.cnf，[mysqld]节点增加以下代码
[mysqld]
character_set_server=utf8
init-connect='SET NAMES utf8'
14.设置开机启动
systemctl enable mysqld
systemctl daemon-reload
15.允许远程登录
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
16.开放端口号
firewall-cmd --zone=public --remove-port=3306/tcp --permanent
service firewalld restart（重启防火墙）
firewall-cmd --zone=public --list-ports
firewall-cmd --zone=public --remove-port=22/tcp --permanent
firewall-cmd --zone=public --remove-port=10086/tcp --permanent
ps -aux|grep mysql
删除mysql 进程
kill -9 pid
