mysql 编译安装

tongy

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

新建用户和用户组

[iyunv@centos ]#groupadd mysql

[iyunv@centos ]#useradd -g mysql mysql

安装编译工具：

bison

cmake

make

bzr

autoconf

automake

ncurses-devel

mysql-5.6.12.tar.bz2

[iyunv@centos ]#yum install bison cmake make bzr autoconf automake ncurses-devel

[iyunv@centos ]#tar jzxf mysql-5.6.12.tar.bz2 -C /usr/src

[iyunv@centos ]#cd /usr/src/mysql-5.6.12

[iyunv@centos ]#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/usr/local/mysql/data/ \

-DSYSCONFDIR=/etc \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysqld.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DEXTRA_CHARSETS=all

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DMYSQL_USER=mysql

//参数参考：http://dev.mysql.com/doc/refman/ ... ration-options.html

[iyunv@centos ]#make && make install

--------------------------------------------------------------------------------

修改权限：

[iyunv@centos ]#chown mysql:mysql /etc/my.cnf

[iyunv@centos ]#chown -R mysql:mysql /usr/local/mysql/mysqldir

修改配置文件：

[iyunv@centos ]#vim /etc/my.cnf

   序号18 basedir = /usr/local/mysql/mysqldir

19 datadir = /usr/local/mysql/mysqldir/data

20 port = 3306

21 server_id = 1

22 socket = /usr/local/mysql/mysqld.sock

创建系统数据库的表:

[iyunv@centos ]#/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

添加系统服务

[iyunv@centos ]#cp support-files/mysql.server /etc/init.d/mysqld  

[iyunv@centos ]#vim /etc/init.d/mysqld

46 basedir==/usr/local/mysql/mysqldir

47 datadir=/usr/local/mysql/mysqldir/data

[iyunv@centos ]#chkconfig --add mysqld

[iyunv@centos ]#chkconfig mysql on

[iyunv@centos ]#service mysqld start

设置环境变量

[iyunv@centos ]#vim ~/.bash_profile

第10行 PATH=$PATH:$HOME/bin:/usr/local/mysql/mysqldir/bin

登陆mysql:

[iyunv@centos ]#cd /usr/local/mysql/mysqldir/bin

[iyunv@centos ]#./mysqladmin -u root password '123456' //设置root用户密码为123456

[iyunv@centos ]#./mysql -u root -p     （提示输入密码后登陆成功）

[iyunv@centos ]#

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

出错：

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!

缺少包：ncurses-devel

解决：

[iyunv@centos ]#yum install ncurses-devel

[iyunv@centos ]#rm -f CMakeCache.txt   (前面已安装但仍出问题直接执行这句)

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

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock

解决1：mysql -u 你的mysql用户名 -p -S /usr/local/mysql/mysqldir/mysql.sock  (my.cnf中socket目录)

解决2：my.cnf中改为socket =/tmp/mysql.sock

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

my.conf配置详解

http://www.iyunv.com/toby/articles/2198697.html

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

mysql允许远程连接

[iyunv@centos ]/usr/local/mysql/mysqldir/bin/mysql -u root -p  (进入mysql)  

mysql>use mysql;  

mysql>SELECT `Host`,`User` FROM user;  

mysql>UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;  

mysql>flush privileges;  

jlthlx

有竞争才有进步嘛

得过且过

站的更高，尿的更远。

qq591577286

穿别人的鞋，走自己的路，让他们找去吧。

efn阿克说

怀揣两块，胸怀500万！

cxwpf200

美女未抱身先走,常使色狼泪满襟。。。。。。

chunjihong

爱你不用合情理但愿用直觉本能去抓住你