MySQL数据库初始化部署

1、新建组和用户

groupadd mysql

useradd -r -g mysql -s /bin/bash mysql

mkdir -p /u02/mysql/data

chown -R mysql:mysql /u02/mysql/data

2、解压安装包并MV到指定路径

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

mv mysql-5.7.39-linux-glibc2.12-x86_64 /u01/mysql

cd /u01/mysql

mv mysql-5.7.39-linux-glibc2.12-x86_64 mysql-5.7

chown -R mysql:mysql /u01/mysql/mysql-5.7

3、编辑my.cnf配置

vi /etc/my.cnf

[mysqld]

basedir=/u01/mysql/mysql-5.7.39
datadir=/u02/mysql/data
socket=/tmp/mysql.sock
port=3306
character-set-server=utf8mb4
pid-file=/u02/mysql/data/mysqld.pid
log-error=/u02/mysql/data/mysqld.err
lower_case_table_names=1
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[client]
socket=/tmp/mysql.sock

　　

4、初始化库和服务配置

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

sudo vi /etc/systemd/system/mysql.service  #里面编辑cnf文件的路径

[Unit]
Description=MySQL Server
After=network.target

[Service]
ExecStart=/etc/mysql/mysql-5.7/bin/mysqld --defaults-file=/etc/my.cnf
User=mysql
Group=mysql
Restart=always

[Install]
WantedBy=multi-user.target

　　

systemctl daemon-reload  #编辑完重载

sudo systemctl start mysql

sudo systemctl status mysql

sudo systemctl stop mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'mics';

FLUSH PRIVILEGES;

CREATE DATABASE micssta CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE USER 'mics'@'%' IDENTIFIED BY 'mics';

GRANT ALL PRIVILEGES ON micssta.* TO 'mics'@'%';
FLUSH PRIVILEGES;