MySQL 5.5编译安装

MYSQL数据库安装方法

• yum/rpm方式安装mysql

只要执行yum install mysql-server即可。

yum/rpm方式安装mysql应用场景：yum/rpm安装适用对数据库要求不太高的场合，例如并发不大，公司内部，企业内部的一些应用场景。

• 常规编译安装mysql

5.0-5.1系列是常规编译方式

• 采用cmake方式编译安装mysql

5.5-5.6系列是cmake编译方式

• 采用二进制方式免编译安装mysql

 1、安装相关软件

cmake软件

[root@localhost /]# tar xf cmake-2.8.8.tar.gz 
[root@localhost /]# cd cmake-2.8.8
[root@localhost cmake-2.8.8]# ./configure 
-- Build files have been written to: /cmake-2.8.8
---------------------------------------------
CMake has bootstrapped.  Now run gmake.
[root@localhost cmake-2.8.8]# gmake
[root@localhost cmake-2.8.8]# gmake install

 

[root@localhost cmake-2.8.8]# which cmake
/usr/local/bin/cmake

 

安装依赖包

[root@localhost cmake-2.8.8]# yum install ncurses-devel -y

 

安装mysql

创建用户和组

[root@localhost cmake-2.8.8]# groupadd mysql
[root@localhost cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql

 

解压、编译

[root@localhost cmake-2.8.8]# cd /
[root@localhost /]# tar xf mysql-5.5.32.tar.gz 
[root@localhost /]# cd mysql-5.5.32
[root@localhost mysql-5.5.32]# cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 -DMYSQL_DATADIR=/application/mysql-5.5.32/data -DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITH_FAST_MUTEXES=1 -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0
[root@localhost mysql-5.5.32]# make && make install
[root@localhost mysql-5.5.32]# ln -s /application/mysql-5.5.32/ /application/mysql

 

选择配置文件

测试环境选择晓得，生产环境可以根据硬件选择，例如：my-innodb-heavy-4G.cnf

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

 

配置环境变量

[root@localhost /]# echo 'export PATH=/application/mysql/bin:$PATH'  >> /etc/profile
[root@localhost /]# tail -1 /etc/profile
export PATH=/application/mysql/bin:$PATH
[root@localhost /]# source /etc/profile
[root@localhost /]# echo $PATH
/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

 

初始化

[root@localhost /]# ll /application/mysql/data/
total 4
drwxr-xr-x. 2 root root 4096 Sep 28 01:25 test
[root@localhost /]# chown -R mysql.mysql /application/mysql/data/
[root@localhost /]# chmod -R 1777 /tmp/
[root@localhost /]# cd /application/mysql/scripts/
[root@localhost scripts]# ./mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql

 

• 添加系统服务

[root@localhost scripts]# cd /mysql-5.5.32
[root@localhost mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql-5.5.32]# chmod +x /etc/rc.d/init.d/mysqld 
[root@localhost mysql-5.5.32]# chkconfig --add mysqld
[root@localhost mysql-5.5.32]# /etc/init.d/mysqld start
Starting MySQL.... SUCCESS! 
[root@localhost mysql-5.5.32]# /etc/init.d/mysqld status
 SUCCESS! MySQL running (1475)     
[root@localhost mysql-5.5.32]# netstat -anpt | grep mysqld
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      1475/mysqld     
    

[root@localhost /]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.32 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>