Linux安装MySQL5.7数据库

下载安装mysql

下载5.7 安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

配置安装依赖

sudo yum localinstall -y mysql57-community-release-el7-8.noarch.rpm

安装数据库

sudo yum install -y mysql-community-server

数据库启动

sudo systemctl start mysqld

查看数据库状态

systemctl status mysqld

数据库启动

sudo systemctl enable mysqld

2、安装启动完成，查看密码

密码在mysql日志中

[mysql@GenMinh~]$ grep 'pass' /var/log/mysqld.log
2020-03-14T12:28:57.051218Z 1 [Note] A temporary password is generated for root@localhost: <z?Shbek>8Gd
<z?Shbek>8Gd 就是我的初始密码了。

3、连接mysql

连接mysql， 默认端口3306

mysql -u root -p
输入密码<z?Shbek>8Gd，进入mysql命令行，修改root密码
mysql> SET PASSWORD = PASSWORD('Db@369012');
Query OK, 0 rows affected, 1 warning (0.00 sec)

4、创建用户，赋权

create user 'we_che_tt'@'%' identified by 'wechett@weduolavvMM33';
create user 'we_che'@'%' identified by 'weche@weduolavvMM33';
create user 'we_che_things'@'%' identified by 'wechethings@weduolavvMM33';
flush privileges;
CREATE DATABASE `we_che_tt`;
grant all privileges on `we_che_tt`.* to 'we_che_tt'@'%';
CREATE DATABASE `we_che`;
grant all privileges on `we_che`.* to 'we_che'@'%';
CREATE DATABASE `we_che_things`;
grant all privileges on `we_che_things`.* to 'we_che_things'@'%';
flush privileges;

5、启动配置

如果是5.7版本的mysql，导入时可能报错，需要修改my.cnf
sudo vim /etc/my.cnf
修改内容如下，在[mysqld]下添加

导入大SQL文件

max_allowed_packet=900M

解决5.6的SQL在5.7的执行错误 ERROR 1067 (42000) Invalid default value for ‘end_time’

sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
修改完后，重启mysql
sudo systemctl restart mysqld
systemctl status mysqld