centos6.2编译安装mysql5.5.25a

《centos6.2编译安装mysql5.5.25a》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、centos6.2编译安装mysql-5.5.25a（傻瓜版）想在linux上安装个mysql5.5.25a网上找了一堆资料，就是安装不好，后来看到lavafree的博客上的文章，整理出100%成功的傻瓜安装方法1.安装准备l安装系统：centos6.2-x86_64l安装软件：mysql-5.5.25al需要环境：gcc，cmake，bison，ncurses2.开始安装2.1.安装gcc，ncursesyum-yinstallgcc-c++yum-yinstallncurses-devel2.2下载cmake，biso，h

2、ttp://kuai.xunlei.com/d/QDMXLCVGJKAF下载解压后有三个文件，上传到系统opt目录下安装cmakecd/opttarzxvfcmake-2.8.8.tar.gzcdcmake-2.8.8./bootstrap========滚====屏====处====理========gmake========滚====屏====处====理========gmakeinstall========滚====屏====处====理========安装bisoncd/opttarzxvfbison-2.5.tar

3、.gzcdbison-2.5./configure========滚====屏====处====理========make========滚====屏====处====理========makeinstall========滚====屏====处====理========完成后如下图安装mysql1.添加mysql账户/usr/sbin/groupaddmysql/usr/sbin/useradd-gmysqlmysql2.解压cd/opt/tarzxvfmysql-5.5.25a.tar.gzcdmysql-5.5.25a/

4、3.编译cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_UNIX_ADDR=/tmp/mysql.sock-DDEFAULT_CHARSET=gbk-DDEFAULT_COLLATION=gbk_chinese_ci-DWITH_EXTRA_CHARSETS:STRING=gbk,gb2312,utf8-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_READLINE=1

5、-DENABLED_LOCAL_INFILE=1-DMYSQL_DATADIR=/opt/mysql/data========滚====屏====处====理========make========滚====屏====处====理========makeinstall========滚====屏====处====理========4.设置权限增加文件夹chmod+w/usr/local/mysqlchown-Rmysql:mysql/usr/local/mysqlmkdir-p/opt/mysql/data/mkdir-p

6、/opt/mysql/log/chown-Rmysql:mysql/opt/mysql/5.拷贝my.cnd文件（一定要根据自己的内存拷贝这个配置文件，否则mysql无法启动）#my-small.cnf(内存<=64M)#my-medium.cnf(内存128M)#my-large.cnf(内存512M)#my-huge.cnf(内存1G-2G)#my-innodb-heavy-4G.cnf(内存4GB)我的内存是1.5G，所以我拷贝my-huge.cnfcdsupport-files/cpmy-huge.cnf/etc/my

7、.cnfcpmysql.server/etc/init.d/mysqld6.初始化安装/usr/local/mysql/scripts/mysql_install_db--defaults-file=/opt/mysql/my.cnf--basedir=/usr/local/mysql--datadir=/opt/mysql/data--user=mysql7.编辑启动文件vi/etc/init.d/mysqldbasedir=/usr/local/mysqldatadir=/opt/mysql/datachmod+x

8、/etc/init.d/mysqld到这里mysql已经安装完成了servicemysqldstart看看后续处理1.加入开机启动chkconfig--addmysqldchkconfig--level345mysqldon2.修改root密码mysqladmin-uroot