mysql添加开机自启_初始化mysql并设置开机自动启动

1，初始化环境

useradd mysql

mkdir /3333

mkdir /3333/data

mkdir /3333/log

mkdir /3333/run

touch /3333/log/db.log

chown -R mysql:mysql /3333

2，初始化数据库，无密码

[root@db01 data]# /opt/mysql/bin/mysqld --datadir=/3333/data --user=mysql --initialize-insecure

2021-02-07T02:12:02.462057Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2021-02-07T02:12:02.773084Z 0 [Warning] InnoDB: New log files created, LSN=45790

2021-02-07T02:12:02.825583Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2021-02-07T02:12:02.887143Z 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: de29a256-68e9-11eb-b2ef-000c29a91aed.

2021-02-07T02:12:02.887685Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2021-02-07T02:12:02.888181Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

3，初始化数据库

cat >> /3333/data/my.cnf<

[mysqld]

port=3333

datadir=/3333/data

socket=/3333/mysql.sock

[mysqld_safe]

log-error=/3333/log/db.log

pid-file=/3333/run/db.pid

EOF

4，设置开机自动启动脚本

[root@db01 support-files]# pwd

/opt/mysql/support-files

[root@db01 support-files]# cp mysql.server mysql3333

[root@db01 support-files]# chmod +x mysql3333

support-files 文件设置开机启动脚本：

1，datadir=/3333/data

2，lockdir='/3333'

3,启动参数文件my.cnf，放到datadir目录(extra_args="-e $datadir/my.cnf)