LINUX环境下MYSQL5.5源码安装
来源:互联网 发布:oracle调用java web 编辑:程序博客网 时间:2024/05/21 09:59
首先到http://www.cmake.org/cmake/resources/software.html
cd /mysql
1.安装cmake
1)下载cmake
#wget http://www.cmake.org/files/v2.8/cmake-2.8.7.tar.gz
2)解压cmake
#tar -zvxf cmake-2.8.7.tar.gz
3)配置编译
#cd cmake-2.8.7
#yum -y install gcc
#yum -y install gcc-c++
#./configure
#make
#make install
2.安装MYSQL
1)下载MYSQL
#cd /mysql
#wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.21.tar.gz/from/http://mysql.mirror.rafal.ca/
2)解压mysql-5.5.21.tar.gz
#tar -zvxf mysql-5.5.21.tar.gz
创建数据目录(mysql5.5默认已经没有data目录了)
mkdir /mysql/mysql/data
3)配置编译
#cd mysql-5.5.21
#cmake . ##这个方法,安装路径默认
或
#cmake . \
-DCMAKE_BUILD_TYPE:STRING=Release \
-DCMAKE_INSTALL_PREFIX:PATH=/mysql/mysql \
-DCOMMUNITY_BUILD:BOOL=ON \
-DENABLED_PROFILING:BOOL=ON \
-DENABLE_DEBUG_SYNC:BOOL=OFF \
-DINSTALL_LAYOUT:STRING=STANDALONE \
-DMYSQL_DATADIR:PATH=/mysql/mysql/data \
-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 \
-LH
如果出现一下错误:
cmake .
-- MySQL 5.5.21
-- 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, 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:256 (MYSQL_CHECK_READLINE)
-- Configuring incomplete, errors occurred!
安装:
# yum -y install ncurses-devel
#make
#make install
#groupadd mysql
#useradd -r -g mysql mysql
#cd /mysql/mysql
#chown -R mysql:mysql .
#scripts/mysql_install_db --user=mysql
#chown -R root .
#chown -R mysql data
#cp ./support-files/my-small.cnf ./my.cnf
#cp support-files/mysql.server mysql; chmod +x mysql
#chown -R mysql:root .
#./mysql start
#./bin/mysqladmin -u root password
错误解决
1) ./scripts/mysql_install_db
Installing MySQL system tables...
101223 14:28:49 [ERROR] ./bin/mysqld: unknown option '--skip-locking'
101223 14:28:49 [ERROR] Aborting
101223 14:28:49 [Note] ./bin/mysqld: Shutdown complete
由于是以前安装过mysql ,所以存在/etc/my.cnf,而且mysql的环境变量和现在的不一样,
从而影响 现在的,解决方法是:rm -rf /etc/my.cnf
2 ) ./scripts/mysql_install_db --basedir/mysql/mysql/ --datadir/mysql/mysql/data/mysql --user=mysql
查看原因:cat data/xcw.err
101223 15:39:18 mysqld_safe Starting mysqld daemon with databases from /w/mysqld558/data
/w/mysqld558/bin/mysqld: Table 'mysql.plugin' doesn't exist
101223 15:39:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
101223 15:39:18 InnoDB: Using Linux native AIO
101223 15:39:18 InnoDB: Initializing buffer pool, size = 128.0M
101223 15:39:18 InnoDB: Completed initialization of buffer pool
101223 15:39:18 InnoDB: highest supported file format is Barracuda.
101223 15:39:18 InnoDB: 1.1.4 started; log sequence number 1588771
101223 15:39:18 [ERROR] //mysql/mysql/bin/mysqld: unknown option '--skip-locking'
101223 15:39:18 [ERROR] Aborting
原因同上,处理也同上
3) 启动mysql服务时出现:
Starting MySQL.The server quit without updating PID file (/w/mysqld558/xcw.pid).[FAILED]
原因是由于data没有设置好,解决:vi mysql : datadir=/w/mysqld558 fix to datadir=/mysql/mysql/data
大功告成!
- LINUX环境下MYSQL5.5源码安装
- Linux环境下源码编译安装MySQL5.5
- ubuntu/ linux下源码安装mysql5.5
- Linux下SOURCE源码安装mysql5.5
- Linux环境下源码编译安装MySQL5.1
- LINUX 环境下源码方式安装mysql5.6
- Linux 源码安装Mysql5.5
- linux 源码安装mysql5.5
- linux下通过源码包安装MySql5.5
- Linux下MySQL5.6源码安装
- linux下Mysql5.6源码安装
- Linux下源码安装MySQL5.6.30
- Linux下源码安装MySQL5.6.30
- Linux下源码安装mysql5.7.17
- Linux环境下安装压缩版MYSQL5.5
- linux环境下安装和卸载Mysql5.5
- Linux环境下MySQL5.1安装步骤:
- Linux 环境下编译安装MySQL5.6
- 20141226 N2
- 天数计算器 JS
- 全功能的Java剖析工具(profiler)
- ASCII,UTF-8,Unicode字符串相互转换
- 展览设计如何凸显特色
- LINUX环境下MYSQL5.5源码安装
- STL中的set容器的一点总结在set中每个元素的值都唯一
- linode的网卡丢失问题解决了(终极解法)
- boost::condition的使用
- Plus One (Java)
- Django POST CSRF verification failed. Request abort
- win10如何设置自己喜欢图片为桌面背景
- 51单片机学习总结系列(一)之驱动流水灯(1)
- activeMQ消费者独占