源码安装mysql5.5_Linux源码安装MySQL5.5.11

环境

系统版本：cenos 6.2

MySQL版本：mysql-5.5.11

一、准备环境

1.建立mysql安装目录及数据存放目录

[root@localhost local]# mkdir -p /usr/local/mysql 　　　　　　　　　　　　　　　　　　//安装mysql

[root@localhost local]# mkdir -p /usr/local/mysql/data 　　　　　　　　　　　　　　　 //存放数据库

2.创建myql用户和用户组

[root@localhost local]# groupadd mysql

[root@localhost local]# useradd -g mysql mysql

3.赋予数据存放目录权限

[# chown -R root:mysql . //把当前目录中所有文件的所有者设为root,所属组为mysql]

[root@localhost local]# chown mysql:mysql -R /usr/local/mysql/data

4.安装cmake[mysql5.5以后是通过cmake来编译的]

可以在http://www.cmake.org网站下载cmake-2.8.4.tar.gz,上传并移动至/usr/local目录下

[root@localhost local]# tar zxvf cmake-2.8.4.tar.gz

[root@localhost local]# cd cmake-2.8.4

[root@localhost cmake-2.8.4]# ./configure  --prefix=/usr/local/cmake

CMake has bootstrapped.  Now run gmake.

[root@localhost cmake-2.8.4]# gmake

[root@localhost cmake-2.8.4]# gmake install

[root@localhost cmake-2.8.4]# ln -s /usr/local/cmake/bin/cmake /usr/local/bin/cmake

[root@localhost cmake-2.8.4]# cmake --version

cmake version 2.8.4

二、安装mysql

上传并移动至/usr/local/mysql目录下

2.解压mysql-5.5.20

[root@localhost local]#tar zxvf mysql-5.5.20.tar.gz

[root@localhost local]# cd mysql-5.5.20

[root@localhost mysql-5.5.20]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql  -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1

[root@localhost mysql-5.5.20]# make

[root@localhost mysql-5.5.20]# make instll

参数说明：

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql        //安装目录

-DINSTALL_DATADIR=/usr/local/mysql/data         //数据库存放目录

-DDEFAULT_CHARSET=utf8                    　　　　//使用utf8字符

-DDEFAULT_COLLATION=utf8_general_ci            //校验字符

-DEXTRA_CHARSETS=all                        　　　　//安装所有扩展字符集

-DENABLED_LOCAL_INFILE=1                    　　  //允许从本地导入数据

注意事项：

重新编译时，需要清除旧的对象文件和缓存信息。

[root@localhost mysql-5.5.20]# make clean

[root@localhost mysql-5.5.20]# rm -f CMakeCache.txt

[root@localhost mysql-5.5.20]# rm -rf /etc/my.cnf

4.把mysql的启动服务设置为系统服务

[root@localhost mysql-5.5.20]# cp support-files/my-medium.cnf /etc/my.cnf

5.初始化数据库

#cd /user/local/mysql

# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

注：basedir:mysql安装路径  datadir:数据库文件储存路径

6.设置开机自启动

[root@localhost mysql]# cp support-files/mysql.server  /etc/init.d/mysql

# chmod 755 /etc/init.d/mysql

# chkconfig mysql on

7.配置环境变量

将mysql的bin目录加到PATH中，有利于以后管理与维护，在/etc/profile中加入mysql/bin,同时增加两个别名方便操作：

# export PATH=/usr/local/mysql/bin:$PATH

# alias mysql_start="mysqld_safe&"

# alias mysql_stop="mysqladmin -u root -p shutdown"

8.启动mysql服务

# /etc/init.d/mysql start

启动之后用ps -ef|grep mysql命令查看是否启动

9.登录mysql

# mysql -u root -p

三、安装遇到的问题

1.没有安装 gcc 和 gcc-c++，安装MYSQL执行cmake报如下错误：

[root@ice mysql-5.5.27]# cmake .

-- The C compiler identification is unknown

-- The CXX compiler identification is unknown

CMake Error: your C compiler: "CMAKE_C_COMPILER-NOTFOUND" was not found.   Please set CMAKE_C_COMPILER to a valid compiler path or name.

CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found.   Please set CMAKE_CXX_COMPILER to a valid compiler path or name.

.

-- Configuring incomplete, errors occurred!

==================================================

解决方法：安装gcc和gcc-c++

[root@localhost mysql-5.5.20]yum install gcc

[root@localhost mysql-5.5.20]yum install gcc-c++

#删除cache文件，不删除还会报错

[root@localhost mysql-5.5.20]rm CMakeCache.txt

[root@localhost mysql-5.5.20]#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1

2.没有安装 ncurses-devel，安装MYSQL执行cmake报如下错误：

-- 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:257 (MYSQL_CHECK_READLINE)

-- Configuring incomplete, errors occurred!

解决方法：

[root@localhost mysql-5.5.20]#yum -y install ncurses-devel

[root@localhost mysql-5.5.20]#rm CMakeCache.txt

[root@localhost mysql-5.5.20]#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1

3.bash:mysql:command not find

原因是mysql命令的路径在/usr/local/mysql/bin下面，所以你直接使用mysql命令时，系统在/usr/bin下面查此命令，所以找不到了。

解决方法：做个软链接即可。

# ln -s /usr/local/mysql/bin/mysql /usr/bin

4.如果myql不能远程连接，出现错误mysql error number 1130，则加入下面语句试试：

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;

5.[root@localhost mysql]# /etc/init.d/mysql status

ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

解决方法：rm -rf /var/lock/subsys/mysql

然后启动mysql,一切正常了，这里的可能原因就是可能和log文件有关，于是将log文件给移除了，再重启MySQL终于OK了。

6.[root@localhost init.d]# /etc/init.d/mysql start

Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).

未解决。