{"id":1388,"date":"2024-05-08T09:58:35","date_gmt":"2024-05-08T01:58:35","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1388"},"modified":"2024-05-08T10:00:57","modified_gmt":"2024-05-08T02:00:57","slug":"cmake-%e5%ae%89%e8%a3%85mysql-5-6-21","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1388","title":{"rendered":"cmake \u5b89\u88c5mysql.5.6.21"},"content":{"rendered":"<p>groupadd mysql<br \/>\nuseradd -r -g mysql mysql<br \/>\nyum install gcc gcc-c++ libtool autoconf automake imake libxml2-devel expat-devel ncurses-devel cmake bison<br \/>\nyum -y install patch make gcc gcc-c++ gcc-g77 flex bison file<br \/>\nyum -y install libtool libtool-libs autoconf kernel-devel<br \/>\nyum -y install libjpeg libjpeg-devel libpng libpng-devel libpng10 libpng10-devel gd gd-devel<br \/>\nyum -y install freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel<br \/>\nyum -y install glib2 glib2-devel bzip2 bzip2-devel libevent libevent-devel<br \/>\nyum -y install ncurses ncurses-devel curl curl-devel e2fsprogs<br \/>\nyum -y install e2fsprogs-devel krb5 krb5-devel libidn libidn-devel<br \/>\nyum -y install openssl openssl-devel vim-minimal nano sendmail<br \/>\nyum -y install fonts-chinese gettext gettext-devel<br \/>\nyum -y install ncurses-devel<br \/>\nyum -y install gmp-devel pspell-devel<br \/>\nyum -y install unzip<\/p>\n<p>1.\u4e0b\u8f7d\u5b89\u88c5\u5305\uff1a<br \/>\n\u89e3\u538b\uff1a<\/p>\n<p>2.\u5378\u8f7d\u539f\u6765\u7684<br \/>\nrpm -qa |grep -i  mysql<br \/>\nrpm -e mysql-devel-5.1.71-1.el6.x86_64<br \/>\nrpm -e mysql-community-release-el7-5.noarch<br \/>\nrpm -e mysql-server-5.1.71-1.el6.x86_64<br \/>\nrpm -e mysql-5.1.71-1.el6.x86_64<br \/>\nrpm -e perl-DBD-MySQL-4.013-3.el6.x86_64<br \/>\nrpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64<\/p>\n<p>3\u3002\u5b89\u88c5<\/p>\n<p>cmake . \\<br \/>\n-DCURSES_LIBRARY=\/lib64\/ -DCURSES_INCLUDE_PATH=\/usr\/lib64\/ -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql  -DMYSQL_DATADIR=\/mysql\/data\/ -DMYSQL_UNIX_ADDR=\/tmp\/mysql\/mysqld.sock -DDEFAULT_CHARSET=utf8 \\<br \/>\n-DEXTRA_CHARSETS=all \\<br \/>\n-DDEFAULT_COLLATION=utf8_general_ci \\<br \/>\n-DWITH_MYISAM_STORAGE_ENGINE=1 \\<br \/>\n-DWITH_SPHINX_STORAGE_ENGINE=1 \\<br \/>\n-DWITH_INNOBASE_STORAGE_ENGINE=1 \\<br \/>\n-DWITH_MEMORY_STORAGE_ENGINE=1 \\<br \/>\n-DMYSQL_USER=mysql<\/p>\n<p>make<\/p>\n<p>make install<\/p>\n<p>4.\u521d\u59cb\u5316MySQL<br \/>\ncd \/usr\/local\/mysql\/script<\/p>\n<p>.\/mysql_install_db --basedir=\/usr\/local\/mysql\/ --datadir=\/mysql\/data\/ --user=mysql<br \/>\nchown -R mysql.mysql .<br \/>\ncp support-files\/my-defualt.cnf \/etc\/my.cnf<br \/>\nbin\/mysqld_safe --user=mysql &amp;   #\u7528netstat -tnl\u67e5\u770b\u4e00\u4e0b3306\u7aef\u53e3<br \/>\ncp support-files\/mysql.server \/etc\/init.d\/mysqld<br \/>\ncd \/usr\/local\/bin<br \/>\nln -fs \/usr\/local\/mysql\/bin\/mysql mysql<\/p>\n<p>5.\u628aMySQL\u6dfb\u52a0\u7cfb\u7edf\u670d\u52a1\u542f\u52a8<br \/>\nexport PATH=$PATH:\/usr\/local\/mysql\/bin<\/p>\n<p>cp \/usr\/local\/mysql\/support-files\/mysql.server \/etc\/rc.d\/init.d\/mysqld<br \/>\nchkconfig --add mysqld<br \/>\nservice mysqld start\/stop   \/\/\u542f\u505cmysql<\/p>\n","protected":false},"excerpt":{"rendered":"<p>groupadd mysql useradd -r -g mysql mysql yum install gcc gcc-c++ libtool autoconf automake imake libxml2-devel expat-devel ncurses-devel cmake bison yum -y install patch make gcc gcc-c++ gcc-g77 flex bison file yum -y install libtool libtool-libs autoconf kernel-devel yum -y install libjpeg libjpeg-devel libpng libpng-devel libpng10 libpng10-devel gd gd-devel yum -y install freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel yum -y install glib2 glib2-devel bzip2 bzip2-devel libevent libevent-devel yum -y install ncurses ncurses-devel curl curl-devel e2fsprogs yum -y install e2fsprogs-devel krb5 krb5-devel libidn libidn-devel yum -y install openssl openssl-devel vim-minimal nano sendmail yum -y install fonts-chinese gettext gettext-devel yum -y install ncurses-devel yum -y install gmp-devel pspell-devel yum -y install unzip 1.\u4e0b\u8f7d\u5b89\u88c5\u5305\uff1a \u89e3\u538b\uff1a 2.\u5378\u8f7d\u539f\u6765\u7684 rpm -qa |grep -i mysql rpm -e mysql-devel-5.1.71-1.el6.x86_64 rpm -e mysql-community-release-el7-5.noarch rpm -e mysql-server-5.1.71-1.el6.x86_64 rpm -e mysql-5.1.71-1.el6.x86_64 rpm -e perl-DBD-MySQL-4.013-3.el6.x86_64 rpm -e &#8211;nodeps mysql-libs-5.1.71-1.el6.x86_64 3\u3002\u5b89\u88c5 cmake . \\ -DCURSES_LIBRARY=\/lib64\/ -DCURSES_INCLUDE_PATH=\/usr\/lib64\/ -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql -DMYSQL_DATADIR=\/mysql\/data\/ -DMYSQL_UNIX_ADDR=\/tmp\/mysql\/mysqld.sock -DDEFAULT_CHARSET=utf8 \\ -DEXTRA_CHARSETS=all \\ -DDEFAULT_COLLATION=utf8_general_ci \\ -DWITH_MYISAM_STORAGE_ENGINE=1 \\ -DWITH_SPHINX_STORAGE_ENGINE=1 \\ -DWITH_INNOBASE_STORAGE_ENGINE=1 \\ -DWITH_MEMORY_STORAGE_ENGINE=1 \\ -DMYSQL_USER=mysql make make install 4.\u521d\u59cb\u5316MySQL cd \/usr\/local\/mysql\/script .\/mysql_install_db &#8211;basedir=\/usr\/local\/mysql\/ &#8211;datadir=\/mysql\/data\/ &#8211;user=mysql chown -R mysql.mysql . cp support-files\/my-defualt.cnf \/etc\/my.cnf bin\/mysqld_safe &#8211;user=mysql &amp; #\u7528netstat -tnl\u67e5\u770b\u4e00\u4e0b3306\u7aef\u53e3 cp support-files\/mysql.server \/etc\/init.d\/mysqld cd \/usr\/local\/bin ln -fs \/usr\/local\/mysql\/bin\/mysql mysql 5.\u628aMySQL\u6dfb\u52a0\u7cfb\u7edf\u670d\u52a1\u542f\u52a8 export PATH=$PATH:\/usr\/local\/mysql\/bin cp \/usr\/local\/&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1388","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1388"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1388\/revisions"}],"predecessor-version":[{"id":1389,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1388\/revisions\/1389"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}