MYsql and WHM

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)

  • #whm, #sysadmin#system administration#system engineer#compsci#computer
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

WHM Directory Structure

1. Apache 2. Exim 3. ProFTPD 4. Pure-FTPD 5. MySQL 6. PostgreSQL 7. SSHD 8. Perl 9. PHP...

Apache and whm

Configuration files (httpd.conf, php.conf) - /usr/local/apache/conf Apache binaries...

WHM and Exim

Conf - /etc/exim.conf (Exim's main configuration file. It is recommended that you do not edit...

Pro FTP and Pure FTP

Pro FTP Conf - /etc/proftpd.conf Program - /usr/sbin/proftpd Init Script -...

cPanel installation directory structure

cPanel installation directory structure The below directories can be located under...

Powered by WHMCompleteSolution