![image.png](/uploads/projects/lanyangyangguodanian@mvig19/ca54419faab03f9600911ce204eb69cb.png)
[mysqld]
basedir=/opt/mysql
datadir=/opt/mysql/data
socket=/tmp/mysql.sock
server_id=1
port=3306
log_error=/opt/mysql/data/mysql_err.1og
explicit_defaults_for_timestamp=true
[mysql]
socket=/tmp/mysql.sock
![image.png](/uploads/projects/lanyangyangguodanian@mvig19/87479371f5511f9ae3a124c126cc2747.png)
/opt/mysql/bin/mysqld --initialize --user=mysql --datadir=/opt/mysql/data/
![image.png](/uploads/projects/lanyangyangguodanian@mvig19/2d6b54262120e30d1a4cb0e311381779.png)
[Unit]
Description=MySQL server by lzh
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[ Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/opt/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE=5000
![image.png](/uploads/projects/lanyangyangguodanian@mvig19/2c5f6ad035a7e73b33d2e1fed1ce19e5.png)
![image.png](/uploads/projects/lanyangyangguodanian@mvig19/32f4cb3b62f0409ce8b4d95427d7228b.png)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';
![image.png](/uploads/projects/lanyangyangguodanian@mvig19/c9ee37dafca6c3b90728242f18d2e675.png)