MYSQL service details
MYSQL configuration file location (my. cnf configuration file is automatically added by default during installation)
/Etc/my. cnf
MYSQL configuration file storage location (when the configuration file is deleted by mistake, it can be copied from the following location)
/Usr/share/doc/mysql-server-5.1.61
File list
My-huge.cnf
My-innodb-heavy-4G.cnf
My-large.cnf
My-medium.cnf
My-small.cnf
Perform the following operations to add a system configuration file for MYSQL:
# Cp/usr/share/mysql/my-medium.cnf/etc/my. cnf
MYSQL service startup script location
Execute the following operations to start MYSQL
#/Usr/bin/mysql
#/Etc/init. d/mysqld restart
# Service mysqld restart
MYSQL installation home directory
/Usr/share/mysql
MYSQL data and log Directory
/Var/lib/mysql/
File list
Ibdata1
Ib_logfile0
Ib_logfile1
Test // database file test Database (empty database)
Mysql // database file mysql authorization table and other information
Mysql-bin.000001 // binary log file
Mysql-bin.index // binary log file
Localhost. localdomain. err // MYSQL error message log
/Var/log/mysqld. log // MYSQL daily log
Other MYSQL information directories
/Usr/lib/mysql
Libmysqlclient_r.so.16-> libmysqlclient_r.so.16.0.0
Libmysqlclient_r.so.16.0.0 // Very important file
Libmysqlclient. so.16-> libmysqlclient. so.16.0.0
Libmysqlclient. so.16.0.0 // Very important file
Mysqlbug
Mysql_config
BitsCN.com