下载和解压mysql

• 下载地址https://dev.mysql.com/downloads/mysql/ ；存档下载地址： https://downloads.mysql.com/archives/community/

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

或者

wget -O mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz https://sourceforge.net/projects/generic-software/files/mysql/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz/download

tar -zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

 mv mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql

初始化

• 在mysql下添加data目录

 mkdir /usr/local/mysql/data

• 创建用户和用户组；更改mysql目录下所有的目录及文件夹所属组和用户

groupadd mysql
useradd -r -g mysql mysql
cd /usr/local
 chown -R mysql:mysql mysql/
 chmod -R 755 mysql/

• 编译安装并初始化mysql，记住命令行末尾的密码

/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

2020-05-13T14:04:08.052652Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-13T14:04:09.009944Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-05-13T14:04:09.129179Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-05-13T14:04:09.190602Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9d7da7a0-9522-11ea-b338-00163e154252.
2020-05-13T14:04:09.192264Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2020-05-13T14:04:09.192633Z 1 [Note] A temporary password is generated for root@localhost: drFol7fayg-6

启动

/usr/local/mysql/support-files/mysql.server start

• 启动可能报错Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/test.pid) ;一定要把/etc/my.cnf改个名字或者删除掉；报这个错也可能是权限问题。

• 还可以添加到服务，设置开机自启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql 
#把mysql注册为开机启动的服务
chkconfig --add mysql  

#查看是否添加成功
chkconfig --list mysql  

• 其他命令

#其他命令
#启动mysql
service mysql start
#停止mysql
service mysql stop
#重启mysql
service mysql restart

使用mysql

• 登录进去，要使用开始生成的密码，比如我这里是drFol7fayg-6

cd /usr/local/mysql
./bin/mysql -u root -p

• 登录进去一般就是修改密码

#修改为root
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

• 无需重启，用新密码再次登录就可以了
  
• 开启mysql远程访问

use mysql;
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
FLUSH PRIVILEGES;

增加配置文件my.cnf

• vim /usr/local/mysql/my.cnf

[mysqld]
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#这个配置只能本机连接   如果要开启外部访问可以写)0.0.0.0
bind-address = 127.0.0.1
#设置东八区时区  MySQL默认的时区是UTC时区  否则代码连接可能报 Could not create connection to database server. Attempted reconnect 3 times. (url拼接serverTimezone=UTC参数也能解决这个报错)
default-time-zone='+08:00'
... 后面的参数省略，如果只是测试运行，就这4行也行 ...

• 配置完成后重启即可