image.png

    1. [mysqld]
    2. basedir=/opt/mysql
    3. datadir=/opt/mysql/data
    4. socket=/tmp/mysql.sock
    5. server_id=1
    6. port=3306
    7. log_error=/opt/mysql/data/mysql_err.1og
    8. explicit_defaults_for_timestamp=true
    10. [mysql]
    11. socket=/tmp/mysql.sock

    image.png

    1. /opt/mysql/bin/mysqld --initialize  --user=mysql --datadir=/opt/mysql/data/

    image.png

    2. [Unit]
    3. Description=MySQL server by lzh
    4. Documentation=man:mysqld(8)
    5. Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
    6. After=network.target
    7. After=syslog.target
    9. [ Install]
    10. WantedBy=multi-user.target
    12. [Service]
    13. User=mysql
    14. Group=mysql
    15. ExecStart=/opt/mysql/bin/mysqld   --defaults-file=/etc/my.cnf
    16. LimitNOFILE=5000

    image.png
    image.png

    1. ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';

    image.png