Linux下Mysql 5.5.8安装手记
Mysql 5.5.8使用了新的cmake编译方式
Setup 1:检查是否安装好了cmake——cmake -i
安装cmake
wget -c
http://www.cmake.org/files/v2.8/cmake-2.8.3.tar.gz
tar -zxvf cmake-2.8.3.tar.gz
cd cmake-2.8.3
./bootstrap
./configure
make && make install
cmake version 2.8.3
//
今天安装cmake 完成之后, 使用时遇到一个问题:command not found
很奇怪,cmake已经安装了,为什么会有这个提示,查找internet发现:
1.9.3 has a dependency on cmake. If you aren't root on the box you
can download cmake fromhttp://www.cmake.org/,
configure and install it using --prefix=~/cmake/ then export
PATH=~/cmake/bin/:$PATH to install cmake in your home directory and
use it to configure Anope.
我把cmake
安装在了/opt/下也就是/opt/cmake
按照提示需要在终端执行 命令:export
PATH=/opt/cmake/bin:$PATH
OK,再执行cmake软件编译就没有错误提示了。
//
Setup 2:
安装MYSQL 5.5.8
wget -c http://.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.8.tar.gz
tar -zxvf mysql-5.5.8.tar.gz
cd mysql-5.5.8/
cmake .
-DCMAKE_BUILD_TYPE:STRING=Release
-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql
-DCOMMUNITY_BUILD:BOOL=ON -DENABLED_PROFILING:BOOL=ON
-DENABLE_DEBUG_SYNC:BOOL=OFF -DINSTALL_LAYOUT:STRING=STANDALONE
-DMYSQL_DATADIR:PATH=/var/run/mysql
-DMYSQL_MAINTAINER_MODE:BOOL=OFF -DWITH_EMBEDDED_SERVER:BOOL=ON
-DWITH_EXTRA_CHARSETS:STRING=all -DWITH_SSL:STRING=bundled
-DWITH_UNIT_TESTS:BOOL=OFF -DWITH_ZLIB:STRING=bundled
-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_READLINE=1
-DENABLED_LOCAL_INFILE=1 -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306
-LH
/
报错:
-- Could NOT find Curses
(missing: CURSES_LIBRARY
CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:82 (MESSAGE):
Curses library not found. Please install
appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is
libncurses5-dev ,
onRedHatand 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:256 (MYSQL_CHECK_READLINE)
-- Configuring incomplete, errors occurred!
=======================
没有安装 ncurses-devel
/
make
make install
慢长的等待过后终于完成了
groupadd mysql
useradd -g mysql mysql
cp /usr/local/mysql/support-files/my-medium.cnf
/etc/my.cnf
vim /etc/my.cnf #需要加入basedir,和datadir否则会出问题
[mysqld]
basedir =/usr/local/mysql
datadir =/usr/local/mysql/data
/usr/local/mysql/scripts/mysql_install_db
–user=mysql
chown -R mysql /usr/local/mysql/data
chgrp -R mysql /usr/local/mysql/.
cp /usr/local/mysql/support-files/mysql./etc/init.d/mysql
chmod 755 /etc/init.d/mysql
chkconfig –level 345 mysql on
echo “/usr/local/mysql/lib/mysql” >>
/etc/ld.so.conf
echo “/usr/local/lib” >>/etc/ld.so.conf
ldconfig
/etc/init.d/mysql start
/usr/local/mysql/bin/mysqladmin -u root password
你的MYSQL密码
/etc/init.d/mysql restart
/etc/init.d/mysql stop
OK终于完成~
常见问题:
1. /etc/init.d/mysql: line 256: my_print_defaults: command not
found
解决方法: 检查/etc/my.cnf是否存在datadir和basedir如果没有请增加
datadir和basedir目录路径.
如下
[mysqld]
port = 3306
basedir =/usr/local/mysql
datadir =/usr/local/mysql/data
This entry was posted in Mysql. Bookmark the permalink.
///
[root@host102 mysql-5.5.35]# cd /usr/local/mysql/
[root@host102 mysql]# groupadd mysql
[root@host102 mysql]# useradd -g mysql mysql
[root@host102 mysql]# cp
/usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
[root@host102 mysql]# vi /etc/my.cnf
[root@host102 mysql]# chgrp -R mysql /usr/local/mysql/data
[root@host102 mysql]# chown -R mysql
/usr/local/mysql/data
[root@host102 mysql]# /usr/local/mysql/scripts/mysql_install_db
--user=mysql
[root@host102 mysql]# cp
/usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@host102 mysql]# chmod 755 /etc/init.d/mysql
[root@host102 mysql]# chkconfig --level 345 mysql on
[root@host102 mysql]# echo "/usr/local/mysql/lib/mysql" >>
/etc/ld.so.conf
[root@host102 mysql]# echo "/usr/local/lib" >>
/etc/ld.so.conf
[root@host102 mysql]# ldconfig
[root@host102 mysql]# /etc/init.d/mysql start
Starting MySQL.... SUCCESS!
[root@host102 mysql]# /usr/local/mysql/bin/mysqladmin -u root
password root
[root@host102 mysql]# /etc/init.d/mysql restart
Shutting down MySQL. SUCCESS!
Starting MySQL.. SUCCESS!
[root@host102 mysql]#