MYSQL service details _ MySQL

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