普通用户权限下安装mysql

参考http://www.leoox.com/?p=256

１、准备

Centos7 minimal 环境下，在普通用户权限的情况下，安装mysql5.5，在进行mysql安装已完成了cmake的安装

 

 

２、安装具体过程

(１)

Cmake　-DCMAKE_INSTALL_PREFIX=$HOME/local/mysql-5.5.37-DMYSQL_DATADIR=$HOME/data/mysql-5.5.37 -DSYSCONFDIR=$HOME/etc/mysql-5.5.37

 

在运行这个命令中会产生CMakeCache.txt文件，如果要进行再一次执行时，一定要删除CMakeCache.txt这个文件才可以。

（２）、执行make和make install两个命令

（３）、编辑my.cnf

$vi $HOME/etc/mysql-5.5.37/my.cnf

[client]

#password       = your_password

port            = 3306

socket         = $HOME/tmp/mysql.sock

# Here follows entries for some specificprograms

 

# The MySQL server

[mysqld]

port            = 3306

socket          = $HOME/tmp/mysql.sock

skip-external-locking

key_buffer_size = 384M

max_allowed_packet = 1M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size =8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

# Try number of CPU's*2 forthread_concurrency

thread_concurrency = 12

datadir = $HOME/data/mysql-5.5.37

 

 

[mysql]

#no-auto-rehash

auto-rehash

 

[mysqld_safe]

log-error=$HOME/logs/mysqld_safe/mysqld.log

pid-file=$HOME/data/mysql-5.5.37/mysqld.pid

（４）、在安装目录运行，进行初始化

$./scripts/mysql_install_db --no-defaults --defaults-file=$HOME/etc/mysql-5.5.37/my.cnf

$./bin/mysqld_safe &

在客户端运行./mysql -uroot -p

３、一些问题

如果遇到　Warning: Bison executable not found in PATH　这个错误信息，可以用

# yum install bison

来解决

如果遇到

-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH)

CMake Error at cmake/readline.cmake:83(MESSAGE):

 Curses library not found.  Pleaseinstall appropriate package,

 

     remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name islibncurses5-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:355 (MYSQL_CHECK_READLINE)

可以用

#yum install ncurses-devel

来解决