linux编译安装mysql容易出现的问题解决方法

《linux编译安装mysql容易出现的问题解决方法》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、(一)#./configure--prefix=/usr/local/mysql-5.1.54(mysql指定路径安装报错：)如下：checkingfortermcapfunctionslibrary...configure:error:Nocurses/termcaplibraryfound安装:ncurses-devel.***.rpm包解决#cd/media/CentOS_5.5_Final/CentOS/#lsncurses-devel*找到这个包并用rpm安装。#rpm-ivhncurses-devel-5.5-24.200607

2、15.i386.rpm（或者去下载一个ncurses-5.6.tar.gz，wgethttp://ftp.gnu.org/pub/gnu/ncurses/ncurses-5.6.tar.gz解压并安装）(二)make时出错../depcomp:line571:exec:g++:notfoundmake[1]:***[my_new.o]错误127make[1]:Leavingdirectory`/usr/local/src/mysql/mysql-5.1.32/mysys`make:***[all-recursive]错误1解决：#yumin

3、stallgcc-c++可解决问题。重新指定安装路径：#./configure--prefix=/usr/local/mysql-5.0.90makemakeinstall?(三)初始化数据库时出错：#scripts/mysql_install_db--user=mysql或#bin/mysql_install_db--basedir=/usr/local/mysql-5.1.54--datadir=/usr/local/mysql-5.1.54/data--user=mysql[Warning]'--skip-locking'isdepr

4、ecatedandwillberemovedinafuturerelease.Pleaseuse'--skip-external-locking'instead.?(解决方法：将my.cnf中的'--skip-locking'换成'--skip-external-locking'就可以了。)?(四)修改/etc/my.cnf的配置文件：[client]#password=your_passwordport=3306socket=/tmp/mysql.sock#Herefollowsentriesforsomespecificprograms

5、#TheMySQLserver[mysqld]port=3306socket=/tmp/mysql.sockbasedir=/usr/local/mysql-5.1.54datadir=/usr/local/mysql-5.1.54/dataskip-external-lockingkey_buffer_size=16Mmax_allowed_packet=1Mtable_open_cache=64sort_buffer_size=512Knet_buffer_length=8Kread_buffer_size=256Kread_rnd_b

6、uffer_size=512Kmyisam_sort_buffer_size=8M[mysql]no-auto-rehash#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL#safe-updates(五：提示：)出错时，可及时查看错误日志：vi/usr/local/mysql-5.1.54/data/localhost.localdomain.err显示如下：11010722:06:31mysqld_safeStartingmysqlddaemonwithdatabasesfr

7、om/usr/local/mysql-5.1.54/data11010722:06:31[Warning]'--skip-locking'isdeprecatedandwillberemovedinafuturerelease.Pleaseuse'--skip-external-locking'instead./usr/local/mysql-5.1.54/libexec/mysqld:Table'mysql.plugin'doesn'texist11010722:06:31[ERROR]Can'topenthemysql.pluginta

8、ble.Pleaserunmysql_upgradetocreateit.11010722:06:31[ERROR]Can'tstartserver:Bindonunixsock