Mysql 安装流程

前言

在数据库内核对Oracle、Mysql进行兼容性开发时，不可缺少的就是拿需要兼容的数据库对这个功能进行测试，安装数据库的步骤就必不可少。开发过程中，每个人不是都拿着服务器进行开发，因此机器磁盘的容量是有限的。这会导致开发过程中数据库删了又装，装了又删，如此反复。为节约时间，我在这里简单记录一下。

下载

Mysql下载地址：MySQL Community Downloads

安装

1、解压

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

2、安装
安装可以参考：
Linux 安装Mysql 详细教程（图文教程）
3、区别
3.1 配置文件/etc/my.cnf内容不同

[mysql]
default-character-set=utf8mb4
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
[mysqld]
port=3306
#server-id=3306
user=mysql
server-id=1
general_log = 1
general_log_file=/var/log/mysql/mysql.log
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql/mysql-5.7
datadir=/usr/local/mysql/data
log-bin=/usr/local/mysql/data/mysql-bin
innodb_data_home_dir=/usr/local/mysql/data
innodb_log_group_home_dir=/usr/local/mysql/data/
character-set-server=utf8mb4
lower_case_table_names=0
autocommit=1
default_authentication_plugin=mysql_native_password
symbolic-links=0
skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/usr/local/mysql/data/mysql.log
pid-file=/usr/local/mysql/data/mysql.pid
#
# include all files from the config directory

3.2 守护进程初始化

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

3.3数据库启动命令

mysql -uroot -hlocalhost -p