龍芯2F源碼安裝mysql-5.5.10

loongson-gz

上mysql的網(wǎng)站下載mysql最新版本

http://dev.mysql.com/downloads/mysql/

選擇Source Code

下載mysql-5.5.10.tar.gz

#mkdir -p /usr/local/mysql

＃cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/

會出現(xiàn)以下錯誤：

remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):

  cmake/readline.cmake:126 (FIND_CURSES)

  cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT)

  CMakeLists.txt:250 (MYSQL_CHECK_READLINE)

解決辦法：

可能是缺少libncurses5-dev包

我們安裝ncurses包

http://ftp.gnu.org/pub/gnu/ncurses/

下載ncurses

我們下載最新的ncurses-5.8.tar.gz

#mkdir -p /usr/local/ncurses-5.8

#./configure --prefix=/usr/local/ncurses-5.8/

#make

#make install

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ -DMYSQL_DATADIR=/usr/local/mysql/data -DCURSES_INCLUDE_PATH=/usr/local/ncurses-5.8/include/ -DCURSES_LIBRARY=/usr/local/ncurses-5.8/lib/libncurses.a

#make

#make install

# groupadd mysql
# usradd -g mysql mysql
# chown -R mysql:mysql /usr/local/mysql
# cp support-files/my-medium.cnf /etc/my.cnf

安裝完后啟動mysql

＃/usr/local/mysql/scripts/mysql_install_db --user=root --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ &

＃/usr/local/mysql/bin/mysqld_safe --user=root

#cd /usr/local/mysql/bin/mysql -u root

即可啟動mysql，出現(xiàn)一下標志：

>mysql

在這里一定要使用root用戶

不然會出現(xiàn)如下錯誤：

mysqld_safe Logging to '/usr/local/mysql/data/localhost.localdomain.err'.

101020 10:32:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

101020 10:32:11 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended

在/usr/local/mysql/data/localhost.localdomain.err中提示

101020 10:32:11 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open     register  file.

101020 10:32:11 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the in    dex file.

101020 10:32:11 [ERROR] Aborting

這里是文件訪問權限的問題

                                                                                                                                                                                                                                                     huguohu