rpm 方式安装mysql

安装

# 下载
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