mysql configuration - liamlamth/blog GitHub Wiki

  • configuration file: 
    /etc/my.cnf
/etc/my.cnf.d/
  • move bin folder 
    /etc/my.cnf.d/client.cnf > [client] > socket
/etc/my.cnf.d/mysql-server.cnf > [mysqld] > datadir
/etc/my.cnf.d/mysql-server.cnf > [mysqld] > socket
    • if moving mysql to a individual lvm, consider to build lvm to original location: /var/lib/mysql, no modification is needed in config file
    • use systemctl start/stop mysqld, do not use mysql shutdown,
      otherwise misconfiguration may easily lead to process hang issue, such as systemctl start/stop mysqld, yum remove mysql-server mysql
⚠️ **GitHub.com Fallback** ⚠️