linux中mysql与eclipse_在Linux的Eclipse上安装配置MySQL+MySQL++ | 学步园

在Linux的Eclipse上安装配置MySQL+MySQL++

步骤：

1. 安装MySQL服务器和开发环境 (具体请参考下载下来的压缩包里的INSTALL-BINARY):

(二进制方式)

1) 下载MySQL (mysql-5.0.89-linux-i686-glibc23.tar.gz)到/usr/local

http://dev.mysql.com/downloads/mysql/5.0.html#linux

以下操作在/usr/local

2) 解压

shell> tar -zxvf mysql-5.0.89-linux-i686-glibc23.tar.gz

3) 安装

shell> groupadd mysql

shell> useradd -g mysql mysql

shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -

shell> ln -s full-path-to-mysql-VERSION-OS mysql

shell> cd mysql

shell> chown -R mysql .

shell> chgrp -R mysql .

shell> scripts/mysql_install_db --user=mysql

shell> chown -R root .

shell> chown -R mysql data

shell> bin/mysqld_safe --user=mysql &

4)进入/usr/local/lib

shell> ln -s /usr/local/mysql/lib/libmysqlclient.so libmysqlclient.so

shell> ln -s /usr/local/mysql/lib/libmysqlclient_r.so.15 libmysqlclient_r.so.15

shell> ln -s /usr/local/mysql/lib/libmysqlclient.so.15 libmysqlclient.so.15

(源码编译)

1)下载(mysql-5.1.45.tar.gz)

2)解压到/usr/local/mysql-5.1.45

以下操作在/usr/local/mysql-5.1.45

3) configure

shell>./configure --with-named-curses-libs=/usr/lib/libncursesw.so.5 --without-server

4) make

shell>make

5) make install

shell>make install

2. 安装Mysql++

1) 下载MySQL (mysql++-3.0.9.tar.gz)到/usr/local

http://tangentsoft.net/mysql++/releases/mysql++-3.0.9.tar.gz

2) 解压

shell> tar -zxvf mysql++-3.0.9.tar.gz

3) 安装

shell> ln -s mysql++-3.0.9 mysql++

shell> cd mysql++

shell> ./configure

shell> make

shell> make install

4) 配置

在文件etc/ld.so.conf的最后加上一行：

/usr/local/lib

3. 配置Eclipse的include路径

右击要用Mysql++的项目，选Property/C/C++Build/Setting/GCC C++ Compiler/Directories/，在Include Paths里加入：

/usr/local/include/mysql++

/usr/local/include/mysql

右击要用Mysql++的项目，选Property/C/C++Build/Setting/GCC C++ Linker/Labraries/，在Labraries里加入：

mysqlclient

mysqlpp

注意：

我用的Linux版本为Red Hat Enterprise Linux 5，在此版本上，第1步也可以替换为用Server+devel+share的RPM包安装，我试了以下三个包(下载自)：

MySQL-shared-community-5.1.41-0.rhel5.i386.rpm

(下载自：http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-shared-community-5.1.41-0.rhel5.i386.rpm/from/ftp://gd.tuwien.ac.at/db/mysql/)

MySQL-devel-community-5.5.0-1.rhel5.i386.rpm

(下载自：http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-devel-community-5.1.41-0.rhel5.i386.rpm/from/ftp://gd.tuwien.ac.at/db/mysql/)

MySQL-server-community-5.5.0-1.rhel5.i386.rpm

(下载自：http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-community-5.1.41-0.rhel5.i386.rpm/from/ftp://gd.tuwien.ac.at/db/mysql/)