Linux學習筆記：LAMP 2 安裝Mysql

參考這篇文章

本機環境：ubuntu12.04,fedora-17

MYSQL版本:5.5.28

CMAKE版本:2.8.9

一.下載最新版本的cmake,解壓後編譯安裝.

sudo ./configure --prefix=/usr/local/etc/cmake-2.8.9sudo makesudo make install
sudo ln -s /usr/local/etc/cmake-2.8.9/bin/cmake /usr/local/bin/cmake

 現在可以使用cmake命令了!

如果出現以下提示，請先安裝g++。

---------------------------------------------CMake 2.8.9, Copyright 2000-2011 Kitware, Inc.C compiler on this system is: cc ---------------------------------------------Error when bootstrapping CMake:Cannot find appropriate C++ compiler on this system.Please specify one using environment variable CXX.See cmake_bootstrap.log for compilers attempted.---------------------------------------------Log of errors: /usr/local/src/cmake-2.8.9/Bootstrap.cmk/cmake_bootstrap.log---------------------------------------------

ubuntu下用

sudo apt-get install g++

redhat系列下用

sudo yum install gcc-c++

 

下載最新的mysql源碼包，解壓後，進入其跟目錄

sudo cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/etc/mysql-5.5.28 \  -DMYSQL_DATADIR=/usr/local/etc/mysql-5.5.28/data \   -DEXTRA_CHARSETS=all \  -DDEFAULT_CHARSET=utf8 \  -DDEFAULT_COLLATION=utf8_general_ci \ -DMYSQL_TCP_PORT=3306 \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \  -DWITH_INNOBASE_STORAGE_ENGINE=1 \

# 這裡附上一行版的，方便粘貼
# 註：此處路徑為/opt下，如果要和上面保持一致，請手動修改
# sudo cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql-5.5.28 -DMYSQL_DATADIR=/opt/mysql-5.5.28/data -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1

sudo make
sudo make install

如果編譯過程出現如下錯誤 需安裝libncurses5-dev

-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH) CMake Error at cmake/readline.cmake:83 (MESSAGE):  Curses library not found.  Please install appropriate package,      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:127 (FIND_CURSES)  cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT)  CMakeLists.txt:268 (MYSQL_CHECK_READLINE)-- Configuring incomplete, errors occurred!

sudo apt-get install libncurses5-dev
#刪除編譯緩衝資訊
sudo rm -rf CMakeCache.txt

 

編譯完成後進入源碼解壓目錄

sudo cp support-files/my-medium.cnf /etc/my.cnf

然後初始化資料庫,不過在此之前，我們要先建立一個mysql使用者

sudo useradd mysql
sudo ./scripts/mysql_install_db --user=mysql --data=/usr/local/etc/mysql-5.5.28/datasudo ./support-files/mysql.server startsudo ./bin/mysql -u root -p

本機環境：ubuntu12.04,fedora-17

MYSQL版本:5.5.28

CMAKE版本:2.8.9

一.下載最新版本的cmake,解壓後編譯安裝.

sudo ./configure --prefix=/usr/local/etc/cmake-2.8.9sudo makesudo make install
sudo ln -s /usr/local/etc/cmake-2.8.9/bin/cmake /usr/local/bin/cmake

 現在可以使用cmake命令了!

如果出現以下提示，請先安裝g++。

---------------------------------------------CMake 2.8.9, Copyright 2000-2011 Kitware, Inc.C compiler on this system is: cc ---------------------------------------------Error when bootstrapping CMake:Cannot find appropriate C++ compiler on this system.Please specify one using environment variable CXX.See cmake_bootstrap.log for compilers attempted.---------------------------------------------Log of errors: /usr/local/src/cmake-2.8.9/Bootstrap.cmk/cmake_bootstrap.log---------------------------------------------

ubuntu下用

sudo apt-get install g++

redhat系列下用

sudo yum install gcc-c++

 

下載最新的mysql源碼包，解壓後，進入其跟目錄

sudo cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/etc/mysql-5.5.28 \  -DMYSQL_DATADIR=/usr/local/etc/mysql-5.5.28/data \   -DEXTRA_CHARSETS=all \  -DDEFAULT_CHARSET=utf8 \  -DDEFAULT_COLLATION=utf8_general_ci \ -DMYSQL_TCP_PORT=3306 \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \  -DWITH_INNOBASE_STORAGE_ENGINE=1 \

# 這裡附上一行版的，方便粘貼
# 註：此處路徑為/opt下，如果要和上面保持一致，請手動修改
# sudo cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql-5.5.28 -DMYSQL_DATADIR=/opt/mysql-5.5.28/data -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1

sudo make
sudo make install

如果編譯過程出現如下錯誤 需安裝libncurses5-dev

-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH) CMake Error at cmake/readline.cmake:83 (MESSAGE):  Curses library not found.  Please install appropriate package,      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:127 (FIND_CURSES)  cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT)  CMakeLists.txt:268 (MYSQL_CHECK_READLINE)-- Configuring incomplete, errors occurred!

sudo apt-get install libncurses5-dev
#刪除編譯緩衝資訊
sudo rm -rf CMakeCache.txt

 

編譯完成後進入源碼解壓目錄

sudo cp support-files/my-medium.cnf /etc/my.cnf

然後初始化資料庫,不過在此之前，我們要先建立一個mysql使用者

sudo useradd mysql
sudo ./scripts/mysql_install_db --user=mysql --data=/usr/local/etc/mysql-5.5.28/datasudo ./support-files/mysql.server startsudo ./bin/mysql -u root -p

來源：http://www.cnblogs.com/hereami/archive/2012/10/09/2716633.html