Linux upgrade Mysql error conflict with file how to do?

mysql server prompts upgrade, many Linux users after upgrading mysql found always prompted conflict with file from package, just did not care, but can not directly start mysql server The first task is to understand what the error message is and then find a solution.

First incompatibilities package, so you want to remove libs package conflicts, then go install!

Code as follows

rpm -e --nodeps mysql-5.0.95-5.el5_9.x86_64

Or use

yum -y remove mysql -libs-5.0.95*

Then we install mysql5.1 just fine

rpm -ivh mysql-5.1.58-jason.1.i386.rpm

It is not recommended to install mysql5.5, the compatibility of the first team program is not very good, the compatibility of the team centos is not very good!

There is a VPS in front of the test that will appear incompatible with the program! Webmin configuration is a weapon, bad configuration is garbage!

If the database fails to start or is wrong in the configuration, you can check out the following article:

Solution 1:

Insert mysql.servers table using sql statement

Solve the problem of not creating databases/users.

When webmin backs up the database, there will be an error message, but the sql file will still be generated.

Can be modified on SSH without mysql:

Solution 2:

ssh text operation method

mysql_upgrade -u root -p “MYSQL- ROOT password & rdquo;

For example:

mysql_upgrade -uroot -p 123456

Completely solved! !

The above is the solution to the error conflict with file from package after Linux upgrade mysql, this article provides two solutions to avoid the first method is invalid.