1-安装MySQL数据库

1. 解压文件,移动到/usr/local/mysql3308目录下

tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.35-linux-glibc2.12-x86_64 /usr/local/mysql3308

2. 创建数据目录

mkdir -p /data/mysql3308

3. 给mysql用户赋权

chown mysql:mysql -R /data/mysql3308
chown mysql:mysql -R /usr/local/mysql3308

4. 创建配置文件

vim /usr/local/mysql3308/my.cnf
--------
[mysqld]
bind-address=0.0.0.0
port=3308
user=mysql
basedir=/usr/local/mysql3308
datadir=/data/mysql3308
socket=/tmp/mysql3308.sock
log-error=/data/mysql3308/mysql.err
pid-file=/data/mysql3308/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
lower_case_table_names=1
default_storage_engine=InnoDB
sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[client]
port=3308
socket=/tmp/mysql3308.sock
----------
chown mysql:mysql -R /usr/local/mysql3308/my.cnf

5. 初始化mysql

cd /usr/local/mysql3308/bin
./mysqld --defaults-file=/usr/local/mysql3308/my.cnf --basedir=/usr/local/mysql3308/ --datadir=/data/mysql3308/ --user=mysql --initialize

6. 查看mysql 初始密码

cat /data/mysql3308/mysql.err
dxbiyanGC4_w

7. 修改服务文件

vim /usr/local/mysql3308/support-files/mysql.server

basedir=/usr/local/mysql3308
datadir=/data/mysql3308
conf=/usr/local/mysql3308/my.cnf

8. 启动mysql

./mysqld_safe --defaults-file=/usr/local/mysql3308/my.cnf  --user=mysql &

9. 如果出现错误 查看错误日志

cat /data/mysql3308/localhost.localdomain.err

10. 查看服务是否启动成功
    ps -ef|grep mysql3308

11. 连接mysql

./mysql -S /tmp/mysql3308.sock -u root -pdxbiyanGC4_w

12. 修改密码 远程登录

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('2be$iU0Fl^cIF2F&');
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '2be$iU0Fl^cIF2F&' WITH GRANT OPTION; flush privileges;
FLUSH PRIVILEGES;
exit;

13. 查看配置文件是否生效

show variables like 'lower_case_table_names';

show variables like "%data%";