安装
# 下载
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
# 解压
tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
如下
# 查看系统是否自带mariadb
rpm -qa | grep mariadb
# 将查出的mariadb进行卸载
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64
# 安装
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
# 启动
service mysqld start
#重启
service mysqld restart
# 默认密码
grep password /var/log/mysqld.log
# 登录
# 修改密码
alter user 'root'@'localhost' identified by '123456';
# 修改失败,修改密码规则
set global validate_password_policy=LOW;
set global validate_password_length=6;
# 授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 指定网段
# grant all privileges on *.* to '192.168.%' identified by '123456' with grant option;
flush privileges;
常见问题
#忽略大写小 vim /etc/my.cnf 追加
lower_case_table_names = 1
# group by查询报错。ONLY_FULL_GROUP_BY
## 修改
SET sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
## 新库,去掉ONLY_FULL_GROUP_BY
SET @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
# 查看
show variables like ‘%sql_mode’;
## 永久修改 /etc/my.cnf
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
安装目录
- 日志:
/var/log/mysqld.log - 数据库目录
/var/lib/mysql/ - 配置文件
/usr/share/mysql
/etc/my.cnf - 常用命令(mysqladmin mysqldump等命令)
/usr/bin