1. 配置yum源
vim /etc/yum.repos.d/mysql.repo
[mysql57]
name=mysql57
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.7-community-el7-x86_64/
enabled=1
gpgcheck=0
[mysql8]
name=mysql57
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/
enabled=1
gpgcheck=0
2. yum安装
yum install mysql-community-server lrzsz libaio -y
3. vim /etc/my.cnf 清空后粘贴下面内容
[mysql]
# CLIENT #
port = 3306
socket = /data/mysql/mysql.sock
[mysqld]
# GENERAL #
user = mysql
socket = /data/mysql/mysql.sock
pid-file = /data/mysql/mysql.pid
datadir = /data/mysql
log-error = /data/mysql/mysqld-error.log
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections = 1000
default_authentication_plugin = mysql_native_password
4. 创建mysql用户和目录
groupadd mysql
useradd -g mysql mysql
mkdir -p /data/mysql
chown -R mysql.mysql /data/mysql
5. 初始化mysql
mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
6. 查看临时密码
cat /data/mysql/mysql_error.log | grep -i 'temporary password'|cut -d":" -f5-10|awk '{gsub(/^\s+|\s+$/,"");print}'
7. 设置启动管理
#启用systemctl管理方式
systemctl enable mysqld
#启动mysql
systemctl start mysqld
8. 修改初始临时密码
mysql -uroot -p
输入第6步临时密码
ALTER USER 'root'@'localhost' IDENTIFIED with mysql_native_password BY '123456';
flush privileges;
9. 连接mysql
mysql -uroot -p123456
10.mysql 常用SQL
# 列出全部数据库
show databases;
#切换库
use 库名
# 列出全部表
show tables;
11. 问题排查
检查端口
netstat -lnp|grep 3306
检查进程
ps -ef|grep mysql
检查日志
cd /data/mysql
tail -n 100 mysql-error.log
12. 常用管理命令
#检查mysql
systemctl status mysqld
#启动mysql
systemctl stop mysqld
#关闭mysql
systemctl start mysqld