|
001.========================Centos 6.2(x64)下编译安装<a href="http://www.it165.net/database/dbmy/" target="_blank"class="keylink">MySQL</a>-5.5.22========================
002.软件源码包存放位置 /usr/local
003.源码包编译安装位置 /usr/local/mysql
004.
005.
006.
007.
008.
009.我们所需要的软件源码包有以下：
010.cmake-2.8.7.tar.gz
011.mysql-5.5.22.tar.gz（mysql版本可以更新）
012.1、安装Cmake
013.
014.yum -y install ntp vim-enhanced gcc gcc-c++ flex bison autoconf automake bzip2-devel
015.ncurses-devel zlib-devel libjpeg-devel libpng-devel libtiff-devel freetype-devel
016.libXpm-devel gettext-devel pam-devel libtool libtool-ltdl openssl openssl-devel
017.fontconfig-devel libxml2-devel curl-devel libicu libicu-devel libmcrypt libmcrypt-devel
018.libmhash libmhash-devel
019.安装 mcrypt时如果提示libmcrypt没有找到 运行
020.export LD_LIBRARY_PATH=/usr/local/libmcrypt/lib:/usr/local/mhash/lib
021.export LDFLAGS="-L/usr/local/mhash/lib/ -I/usr/local/mhash/include"
022.export CFLAGS="-I/usr/local/mash/include/"
023../configure --prefix=/usr/local/mcrypt --with-libmcrypt --prefix=/usr/local/libmcrypt
024.
025.
026.tar zxvf cmake-2.8.7.tar.gz
027.cd cmake-2.8.7
028../configure && make && make install
029.2、编译安装配置MySQL
030.创建所需目录 mkdir -pv /usr/local/mysql/data //同时创建mysql和data两个目录并输出创建信息
031.创建mysql组 groupadd mysql
032.创建mysql用户 useradd -g mysql -s /sbin/nologin mysql
033.
034.
035.cd /usr/src/mysql目录
036.
037.
038.cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5 -DMYSQL_UNIX_ADDR=/usr/local/mysql5/mysql.sock
039.-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all
040.-DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1
041.-DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql5/data
042.-DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306
043.
044.==============================================================================
045.参数说明:
046.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql //安装目录
047.-DMYSQL_DATADIR=/usr/local/mysql/data //数据库存放目录
048.-DWITH_MYISAM_STORAGE_ENGINE=1 //安装myisam存储引擎
049.-DWITH_INNOBASE_STORAGE_ENGINE=1 //安装innodb存储引擎
050.-DWITH_ARCHIVE_STORAGE_ENGINE=1 //安装archive存储引擎
051.-DWITH_BLACKHOLE_STORAGE_ENGINE=1 //安装blackhole存储引擎
052.-DENABLED_LOCAL_INFILE=1 //允许从本地导入数据
053.-DDEFAULT_CHARSET=utf8 //使用utf8字符
054.-DDEFAULT_COLLATION=utf8_general_ci //校验字符
055.-DEXTRA_CHARSETS=all //安装所有扩展字符集
056.-DMYSQL_TCP_PORT=3306 //MySQL监听端口
057.-DMYSQL_USER=mysql //MySQL用户名
058.-DWITH-EMBEDDED_SERVER=1 //编译成embedded MySQL library (libmysqld.a)
059.-DSYSCONFDIR=/etc //MySQL配辑文件
060.-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock //Unix socket 文件路径
061.-DWITH_READLINE=1 //快捷键功能
062.-DWITH_SSL=yes //SSL
063.-DWITH_MEMORY_STORAGE_ENGINE=1 //安装memory存储引擎
064.-DWITH_FEDERATED_STORAGE_ENGINE=1 //安装frderated存储引擎
065.-DWITH_PARTITION_STORAGE_ENGINE=1 //安装数据库分区
066.-DINSTALL_PLUGINDIR=/usr/local/mysql/plugin //插件文件及配置路径
067.=========================================================================================
068.
069.make && make install
070.
071.
072.cp support-files/my-medium.cnf /etc/my.cnf
073.
074.chmod +x /usr/local/mysql
075.chown -R mysql:mysql /usr/local/mysql
076.chown -R mysql:mysql /usr/local/mysql/data
077.
078.cp support-files/mysql.server /etc/init.d/mysqld
079.chmod +x /etc/init.d/mysqld
080.chkconfig --add mysqld
081.chkconfig mysqld on
082.
083.vim /etc/my.cnf
084.
085.datadir = /usr/local/mysql/data
086.log-error = /usr/local/mysql/data/error.log
087.pid-file = /usr/local/mysql/data/www.pid //(此处的pid文件名称要与主机名称一致)
088.user = mysql
089.tmpdir = /tmp
090.
091.
092.
093./usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql
094.--datadir=/usr/local/mysql/data
095.
096.
097.service mysqld start
098.加入环境变量，在/etc/profile文件中最后加入：
099.
100.export PATH=/usr/local/mysql/bin:$PATH
101.修改默认的mysql最大连接数（默认只有151），打开/etc/my.cnf文件，在[mysqld]的下面加入：
102.max_connections=1000，然后重启mysql即可生效，查看最大连接数：
103.
104.mysql>show VARIABLES LIKE '%conn%';
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.ps -ef | grep mysql
124.
125.netstat -tnlp | grep 3306
126.如果提示[ERROR] Plugin 'InnoDB' init function returned error，把安装目录下面的ib_logfile0
127.和ib_logfile1删除或者重命名
128.重启Mysqld服务
129.设置Mysql程序执行路径
130.export PATH=$PATH:/usr/local/mysql/bin
131.echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
132.
133.
134.===========================到此MySQL编译安装完成=========================================
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
(责任编辑：IT) |
