linux下mysql的安装编译问题总结
(一)#./configure --prefix=/usr/local/mysql-5.1.54
(mysql指定路径安装报错：)
以下：
checking for termcap functions library... configure: error: No curses/termcap library found
安装:
ncurses-devel.***.rpm 包规画
#cd /media/CentOS_5.5_Final/CentOS/
#ls ncurses-devel*
找到这个包并用rpm安装。
# rpm -ivh ncurses-devel-5.5-24.20060715.i386.rpm
（年夜概来下载一个ncurses-5.6.tar.gz，
wget http://ftp.gnu.org/pub/gnu/ncurses/ncurses-5.6.tar.gz> 解压并安装）
(二)
make时出错
../depcomp: line 571: exec: g++: not found
make: *** 弊端 127
make: Leaving directory `/usr/local/src/mysql/mysql-5.1.32/mysys`
make: *** 弊端 1
规画：
#yum install gcc-c++ 可规画成绩。
从新指定安装路径：
#./configure --prefix=/usr/local/mysql-5.0.90
make
make install
?
-----------------------------------------------------------
gcc -DMYSQL_CLIENT_NO_THREADS -DHAVE_CONFIG_H -DNO_KILL_INTR -I. -I../../include -I../../include -I../../include -I../.. -g -O2 -DUNIV_LINUX -MT tilde.o -MD -MP -MF .deps/tilde.Tpo -c -o tilde.o tilde.c
在包孕自 tilde.c：55 的文件中:
xmalloc.h:29:31: 弊端：readline/rlstdc.h：没有那个文件或目次
make: *** 弊端 1
make: Leaving directory `/root/nginx/mysql-5.5.3-m3/cmd-line-utils/readline"
make: *** 弊端 1
make: Leaving directory `/root/nginx/mysql-5.5.3-m3/cmd-line-utils"
make: *** 弊端 1
规画方法：
在linux下编译时，假定出现弊端：readline/readline.h：没有那个文件或目次
可以直接更新
yum installreadline-devel
然后再从新编译即可。
在包孕自 libmysql.c：30 的文件中:
../include/violite.h:98:30: 弊端：openssl/opensslv.h：没有那个文件或目次
../include/violite.h:114:25: 弊端：openssl/ssl.h：没有那个文件或目次
../include/violite.h:115:25: 弊端：openssl/err.h：没有那个文件或目次
In file included from libmysql.c:30:
../include/violite.h:127: 弊端：expected specifier-qualifier-list before ‘SSL_CTX’
make: *** 弊端 1
make: Leaving directory `/root/nginx/mysql-5.5.3-m3/libmysql"
make: *** 弊端 2
make: Leaving directory `/root/nginx/mysql-5.5.3-m3/libmysql"
make: *** 弊端 1
yum install openssl*
(三)
初始化数据库时出错：
# 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
"--skip-locking" is deprecated and will be removed in a future> external-locking" instead.
?
(规画方法：将my.cnf 中的"--skip-locking" 换成"--skip-external-locking" 便可以了。)
?
(四)建改/etc/my.cnf 的配置文件：
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
port = 3306
socket = /tmp/mysql.sock
basedir=/usr/local/mysql-5.1.54
datadir=/usr/local/mysql-5.1.54/data
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
(五：提示：)
出错时，可实时查看弊端日记：
vi /usr/local/mysql-5.1.54/data/localhost.localdomain.err
显现以下：
110107 22:06:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.1.54/data
110107 22:06:31 "--skip-locking" is deprecated and will be removed in a future> "--skip-external-locking" instead.
/usr/local/mysql-5.1.54/libexec/mysqld: Table "mysql.plugin" doesn"t exist
110107 22:06:31 Can"t open the mysql.plugin table. Please run mysql_upgrade to create it.
110107 22:06:31 Can"t start server : Bind on unix socket: No such file or directory
110107 22:06:31 Do you already have another mysqld server running on socket: var/lib/mysql/mysql.sock
?
110107 22:06:31 Aborting
?
小结1：
mysql 的启动体例：
(1)
#cd /usr/local/mysql-5.1.54/libexec
#./mysqld --defaults-file=../my.cnf --user=mysql
(2)
#cd /usr/local/mysql-5.1.54/bin
#./mysqld_safe --defaults-file=../my.cnf --user=mysql
(3)
#mysql -S /tmp/mysql.sock
(4)
#cd /usr/local/mysql-5.1.54/share/mysql
#./mysql.server start
(可以将mysql减减的系统办事中)
#cp ./mysql.server /etc/init.d/mysql
#chkconfig --add mysql
#service mysql start
文章来源http://blog.sina.com.cn/s/blog_da7cec590101q1ne.html
页:
[1]