MySQL error caused by Ubuntu upgrade to 12.04

Upgrading MySQL to 5.5.22 in Ubuntu 12.04 causes the original MySQL loading to fail.

Solution:

1. completely uninstall the original MySQL

1. Sudo apt-get remove mysql-server
2. Sudo apt-get autoremove -- purge mysql-server
3. Sudo apt-get remove mysql-common (this step is important)
4. Dpkg-l | grep ^ rc | awk'{Print $2 }'| Sudo xargs dpkg-P

2. reinstall mysql (restart before installation)

Sudo apt-get install mysql-server
Sudo apt-get install mysql-workbench (the original client cannot be used)

Run the following command to check whether the installation is successful:

Sudo netstat-tap | grep mysql

3. mysql2 in the original gem needs to be re-compiled and installed

1. Gem uninstall mysql2
2. Gem install mysql2

4. the following error may occur during mysql2 installation:

1. Gem: Installer: ExtensionBuildError: ERROR: Failed to build gem native extension.
3. /Homexxx/. rbenv/versions/1.9.3-p125/bin/ruby extconf. rb
4. CheckingForRb_thread_blocking_region ()... yes
5. CheckingForRb_wait_for_single_fd ()... yes
6. CheckingForMysql_query ()In-Lmysqlclient... no
7. CheckingForMain ()In-Lm... yes
8. CheckingForMysql_query ()In-Lmysqlclient... no
9. CheckingForMain ()In-Lz... yes
10. CheckingForMysql_query ()In-Lmysqlclient... no
11. CheckingForMain ()In-Lsocket... no
12. CheckingForMysql_query ()In-Lmysqlclient... no
13. CheckingForMain ()In-Lnsl... yes
14. CheckingForMysql_query ()In-Lmysqlclient... no
15. CheckingForMain ()In-Lmygcc... no
16. CheckingForMysql_query ()In-Lmysqlclient... no
17. * ** Extconf. rb failed ***
18. CocouldNotCreate Makefile due to some reason, probably lack
19. Necessary librariesAnd/OrHeaders. Check the mkmf. log fileForMore
20. Details. You may need configuration options.

Solution:

1. Sudo apt-get install libmysql-ruby
2. Sudo apt-get install libmysqlclient-dev
3. Gem install mysql

For more information about Ubuntu, see Ubuntu special page http://www.bkjia.com/topicnews.aspx? Tid = 2