yum -y install make gcc-c++ cmake bison-devel ncurses-devel gcc kernel-devel readline-devel pcre-devel openssl-devel openssl zlib zlib-devel pcre-develgroupadd mysql && useradd -r -g mysql mysqlmkdir -p /usr/local/mysqlmkdir -p /data/mysqldbcmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DMYSQL_DATADIR=/data/mysqldb \-DMYSQL_TCP_PORT=3306 \-DENABLE_DOWNLOADS=1make && make installcd /usr/local/mysqlchown -R mysql:mysql .chown -R mysql:mysql /data/mysqldbscripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --ldata=/var/lib/mysqlcp support-files/mysql.server /etc/init.d/mysqld && chmod +x /etc/init.d/mysqldcat >> /etc/profile << "EOF"PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATHexport PATHEOFsource /etc/profileservice mysqld start chkconfig --level 35 mysqld onln -s /var/lib/mysql/mysql.sock /usr/local/mysql/mysql.sockln -s /var/lib/mysql/mysql.sock /tmp/mysql.sockcat >> /etc/rc.local << "EOF"ln -s /var/lib/mysql/mysql.sock /usr/local/mysql/mysql.sockln -s /var/lib/mysql/mysql.sock /tmp/mysql.sockEOF1.例如你的 root用户现在没有密码,你希望的密码修改为123456,那么命令是:mysqladmin -u root password 1234562.如果你的root现在有密码了(123456),那么修改密码为abcdef的命令是:mysqladmin -u root -p password abcdef注意,命令回车后会问你旧密码,输入旧密码123456之后命令完成,密码修改成功。-DCMAKE_INSTALL_PREFIX=dir_name 设置mysql安装目录-DMYSQL_UNIX_ADDR=file_name 设置监听套接字路径,这必须是一个绝对路径名。默认为/tmp/mysql.sock-DDEFAULT_CHARSET=charset_name 设置服务器的字符集。缺省情况下,MySQL使用latin1的(CP1252西欧)字符集。cmake/character_sets.cmake文件包含允许的字符集名称列表。-DDEFAULT_COLLATION=collation_name 设置服务器的排序规则。-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 存储引擎选项:MyISAM,MERGE,MEMORY,和CSV引擎是默认编译到服务器中,并不需要明确地安装。静态编译一个存储引擎到服务器,使用-DWITH_engine_STORAGE_ENGINE= 1可用的存储引擎值有:ARCHIVE, BLACKHOLE, EXAMPLE, FEDERATED, INNOBASE (InnoDB), PARTITION (partitioning support), 和PERFSCHEMA (Performance Schema)-DMYSQL_DATADIR=dir_name 设置mysql数据库文件目录-DMYSQL_TCP_PORT=port_num 设置mysql服务器监听端口,默认为3306-DENABLE_DOWNLOADS=bool 是否要下载可选的文件。例如,启用此选项(设置为1),cmake将下载谷歌所使用的测试套件运行单元测试。
本文转自 freeterman 51CTO博客,原文链接:http://blog.51cto.com/myunix/1697214,如需转载请自行联系原作者