Linux configuration MySQL Database detailed

How to configure the MySQL database under Linux system, the distribution used below is Centos5.8.

1. Yum installation yum install mysql* in order to ensure that the process is not a problem, we use the mysql* of the relevant are loaded

2. The advantage of Linux system is that it can automatically install MySQL for us Unlike Windows to manually configure their own, after the installation of the following prompts:

3. Restart the MySQL service after installation, may reboot failed. An error occurred

Linux system boot MySQL error: Neither host ' localhost.localdomain ' nor ' localhost ' could be looked

Solutions

To see what files cat/etc/hosts found, edit the content-related configuration.

Vim/etc/hosts Enter the following: 127.0.0.1localhost.localdomain localhost

Then restart MySQL

4. After reboot, you can run normally, and then modify the initial password. Just finished installed is not a password, we can directly enter the MySQL login:

5. After the normal operation of the test, we quit to modify the initial password, after the change, and then directly enter the MySQL test:

6. Use the new set of password 123456 to log on normally:

The above is the Linux system to configure the installation of MySQL some simple steps!