MYsql and WHM Print

  • #whm, #sysadmin#system administration#system engineer#compsci#computer
  • 0

MYSQL

  • Conf - /etc/my.cnf (includes global values for the server), /root/.my.cnf (addendum to the main my.cnf file)

  • Program - /usr/sbin/mysqld (Daemon), /usr/bin/mysqld_safe (Startup script)

  • Init script : /etc/rc.d/init.d/mysql

  • cPanel script to restart MySQL - /scripts/restartsrv mysql

  • Log - /var/lib/mysql/<hostname>.err (Startup errors)

  • Data directory - /var/lib/mysql (All databases are stored here)

  • Database naming convention - <username>_<dbname> (Example: testcp_dbmysql)


Was this answer helpful?

« Back

Powered by WHMCompleteSolution