论坛首页 综合技术论坛

ubuntu 升级到12.04引起的mysql错误

浏览 3697 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
作者 正文
   发表时间:2012-04-28  

ubuntu12.04中将mysql升级到5.5.22导致原先的mysql加载失败

解决方法:

1.完全卸载原先的mysql

sudo apt-get remove mysql-server
sudo apt-get autoremove --purge mysql-server
sudo apt-get remove mysql-common(这步比较重要)
dpkg -l | grep ^rc | awk '{print $2}' | sudo xargs dpkg -P
 

2.重新安装mysql(安装前最好重启)

sudo apt-get install mysql-server
sudo apt-get install mysql-workbench(原先的client无法使用)
 

3原先gem中的mysql2需要重新编译安装

gem uninstall mysql2
gem install mysql2
 

4.安装mysql2时可能出现以下错误

Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.

/homexxx/.rbenv/versions/1.9.3-p125/bin/ruby extconf.rb 
checking for rb_thread_blocking_region()... yes
checking for rb_wait_for_single_fd()... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lmygcc... no
checking for mysql_query() in -lmysqlclient... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers.  Check the mkmf.log file for more
details.  You may need configuration options.

 解决方法:

sudo apt-get install libmysql-ruby
sudo apt-get install libmysqlclient-dev
gem install mysql
 
论坛首页 综合技术版

跳转论坛:
Global site tag (gtag.js) - Google Analytics