CentOS Install MySQL

First spit trough under a company's machine environment, channel machine What is the most annoying! Make a securefx is not good to use!! The egg-ache MySQL installation Ah, basically is Linux the right struggle.

1. Yum one MySQL, start service .... I'm using a mysql.server boot.

2. Congratulations: starting mysql.manager of Pid-file quit without updating file. [FAILED] This error means that MySQL is not up, you guess the reason?

3. The process is sad, all MySQL-related configurations are already in the clean/repair system, like /etc/my.cnf, check the path correctness of each configuration, the best of these two paragraphs, or there will be encoding conversion problem .....

[Client]default-character-set=utf8[mysql]default-character-set=utf8

And this, if the previous system loaded MySQL: Direct violence to find Find-name mysql-bin.index, and delete it.

Or this is the reason: SELinux needs to be closed, selinux I have not studied, is said to be a very complex authority system, find/etc/selinux/config, change selinux=enforcing to selinux= Disabled after saving to restart the machine

4. More sadly, since the user's permissions are not root, the change my.cnf is set to "All users can write". But MySQL is very witty, will prompt:world-writable config file '/etc/my.cnf ' is ignored, thanks to MySQL.

5. The next step is to start and log in to MySQL and create a remote user. There is a small pit: the first time you log in, if you enter-u-p then the user you logged in is not the root user of MySQL, but the "@ ' localhost ' username is an empty account. So or mysql-h 127.0.0.1-u root-p login, prompted to enter the password directly enter, is the root account.

CentOS Install MySQL