MySQL 5.5.30的源码编译安装过程

MySQL 5.5.30的源码编译安装过程2014-10-240、安装cmake

[root@lyq314 ~]# tar -zxvf cmake-2.8.11.2.tar.gz

[root@lyq314 cmake-2.8.11.2]# ./configure

[root@lyq314 cmake-2.8.11.2]# make

[root@lyq314 cmake-2.8.11.2]# make install

1、添加mysql用户和组

[root@lyq314 ~]#groupadd mysql

[root@lyq314 ~]#useradd -g mysql mysql

2、编译MySQL程序

[root@lyq314 tar_mysql]# tar -zxvf mysql-5.5.30.tar.gz

[root@lyq314 ~]# cd mysql-5.5.30/

/usr/local/bin/cmake

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5

-DMYSQL_UNIX_ADDR=/tmp/mysql.sock

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk,gb2312

-DWITH_MYISAM_STORAGE_ENGINE=1

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_READLINE=1

-DENABLED_LOCAL_INFILE=1

-DMYSQL_DATADIR=/home/mysql/data

-DWITH_DEBUG=0

[root@lyq314 mysql-5.5.30]# make && make install

本栏目更多精彩内容：http://www.bianceng.cn/database/MySQL/

3、拷贝数据库的配置文件并做修改

[root@lyq314 ~]# cp -ar /usr/local/mysql5.5/support-files/my-medium.cnf /usr/local/mysql5.5/etc/lyq314.cnf

4、初始化数据库

/usr/local/mysql5.5/scripts/mysql_install_db --defaults-file=/usr/local/mysql5.5/etc/lyq314.cnf --basedir=/usr/local/mysql5.5/ --datadir=/home/mysql/data --user=mysql

5、添加环境变量

[root@lyq314 ~]# echo "export PATH=$PATH:/usr/local/mysql5.5/bin" >> /etc/profile

[root@lyq314 ~]# source /etc/profile

6、mysql的启动

/usr/local/mysql5.5/bin/mysqld_safe --defaults-file=/usr/local/mysql5.5/etc/lyq314.cnf --datadir=/home/mysql/data --user=mysql &

7、查看mysql服务端口

# netstat -tunlp

[root@localhost etc]# netstat -nltp |grep 3306

tcp 00 0.0.0.0:3306 0.0.0.0:* LISTEN24752/mysqld

8、设置管理员密码

/usr/local/mysql5.5/bin/mysqladmin -u root password "1q2w3e4r"

#/usr/local/mysql5.5/bin/mysqladmin -u root -p1q2w3e4r password "123456"

9、登陆数据库进行测试

[root@lyq314 mysql-5.5.30]# /usr/local/mysql5.5/bin/mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 11

Server version: 5.5.30-log Source distribution

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> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| test |

+--------------------+

4 rows in set （0.02 sec）

mysql>

10、MySQL 的关闭

[root@lyq314 mysql-5.5.30]# /usr/local/mysql5.5/bin/mysqladmin -uroot -p shutdown

Enter password:

130717 00:31:09 mysqld_safe mysqld from pid file /home/mysql/data/lyq314.pid ended