Install, configure, and disassemble mysql using the rpm package in Linux

The new project was launched. It was a hosted call center and analyzed the business processes of competitors. It was probably developed based on asterisk. A while ago, we saw an open-source project asterCRM, some

Call Center and CRM functions, so create a new Linux environment analysis, the RedHat 4 has been installed yesterday, then I need to install MySQL:

Detailed process of installing, configuring, and detaching mysql through rpm packages.

Take MySQL-server-4.0.14-0.i386.rpm as an example, put it under the/usr/src directory

Cd/usr/src

Rpm-ivh MySQL-server-4.0.14-0.i386.rpm

After installation is complete, there will be a mysql STARTUP script in the/usr/share/mysql directory mysql. server and sample configuration files (such as my-huge.cnf, my-large.cnf, my-medium.cnf)

Copy an example configuration file as the mysql configuration file:

Cp/usr/share/mysql/my-medium.cnf/etc/my. cnf

After the rpm package is installed, mysql is automatically installed as a system service. Therefore, you can run the following command to start or stop mysql:

Start mysql

/Etc/init. d/mysql start or service mysql start

Stop mysql

/Etc/init. d/mysql stop or service mysql stop

At this point, the mysql service has been installed and configured.

Install the mysql client

Rpm-ivh MySQL-client-4.0.14-0.i386.rpm

After mysql is installed, the directory structure is as follows:

The tool program is in the/usr/bin directory --- ls/usr/bin/mysql *

Server program/usr/sbin/mysqld

Data directory/var/lib/mysql

By default, mysql writes the Error Log File, binary log file and process file in the/var/lib/mysql directory, such as localhost. err, localhost. pid, localhost-bin.001, etc.

To change these conditions, modify the/etc/my. cnf file.

For example, to write a log file in the/var/log directory, you can add the following two lines to the my. cnf file:

[Mysqld_safe]

Err-log =/var/log/mysqld. log

There is a utility/usr/bin/mysql_install_db which can be used to initialize the mysql database, that is, to create the/var/log/mysql directory and to create the mysql database (mysql authorization table and other information) and test Database (empty database), If you accidentally delete the/var/log/mysql directory, you can use this program to initialize.

Uninstall mysql

Rpm-qa | grep-I mysql

Rpm-ev MySQL-server-4.0.14-0 MySQL-client-4.0.14-0

Data in/var/lib/mysql and/etc/my. cnf will not be deleted after uninstallation. If it is determined that it is useless, it will be deleted manually.

Rm-f/etc/my. cnf

Rm-rf/var/lib/mysql