{"id":1834,"date":"2013-08-22T20:11:14","date_gmt":"2013-08-22T11:11:14","guid":{"rendered":"http:\/\/je1sgh.dyndns.info\/?page_id=1834"},"modified":"2013-08-22T20:11:14","modified_gmt":"2013-08-22T11:11:14","slug":"mysql","status":"publish","type":"page","link":"https:\/\/je1sgh.mydns.jp\/?page_id=1834","title":{"rendered":"MySQL"},"content":{"rendered":"

CMake\u306e\u30aa\u30d7\u30b7\u30e7\u30f3<\/h2>\n

MySQL 5.5.x\u3067\uff0cSlackware\u6e96\u62e0\uff0e<\/p>\n

CFLAGS=\"-O2 -march=i486 -mtune=i686\" \\\nCXXFLAGS=\"-O2 -march=i486 -mtune=i686 -felide-constructors -fno-exceptions -fno-rtti\" \\\nCXX=gcc \\\ncmake \\\n -DBUILD_CONFIG=mysql_release \\\n -DFEATURE_SET=\"community\" \\\n -DINSTALL_LAYOUT=\"RPM\" \\\n -DCMAKE_INSTALL_PREFIX=\/usr \\\n -DINSTALL_LIBDIR=lib \\\n -DINSTALL_SBINDIR=libexec \\\n -DINSTALL_INCLUDEDIR=include\/mysql \\\n -DINSTALL_MYSQLSHAREDIR=share\/mysql \\\n -DINSTALL_SQLBENCHDIR= \\\n -DINSTALL_MYSQLTESTDIR=mysql-test \\\n -DINSTALL_INFODIR=info \\\n -DINSTALL_MANDIR=man \\\n -DINSTALL_PLUGINDIR=\"lib\/mysql\/plugin\" \\\n -DINSTALL_SCRIPTDIR=bin \\\n -DINSTALL_SUPPORTFILESDIR=share\/mysql \\\n -DINSTALL_MYSQLDATADIR=\"\/var\/lib\/mysql\" \\\n -DMYSQL_DATADIR=\"\/var\/lib\/mysql\" \\\n -DMYSQL_UNIX_ADDR=\"\/var\/run\/mysql\/mysql.sock\" \\\n -DWITH_EXTRA_CHARSETS=complex \\\n -DWITH_INNOBASE_STORAGE_ENGINE=1 \\\n -DENABLED_LOCAL_INFILE=ON \\\n -DWITH_EMBEDDED_SERVER=ON \\\n -DWITH_READLINE=ON \\\n -DWITH_SSL=system \\\n -DWITH_ZLIB=system \\\n ..\/<\/pre>\n
Password\u5909\u66f4\u30002011-03-30<\/h2>\n
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';\nFLUSH PRIVILEGES;<\/pre>\n
\u521d\u56de<\/h3>\n
\u307e\u305a\uff0cmysql_install_db\u3092\u5b9f\u884c\uff0e\u305d\u3057\u3066\uff0c<\/p>\n
cd \/var\/lib\nchown -Rv mysql:mysql mysql<\/pre>\n
\u305d\u3057\u3066\uff0c<\/p>\n
\/etc\/rc.d\/rc.mysqld start\n\n\/usr\/bin\/mysqladmin -u root password 'new-passwd'<\/pre>\n
\u30cd\u30c3\u30c8\u304b\u3089\u3064\u306a\u304c\u3089\u306a\u3044\u30002012-08-03<\/h2>\n
Slackware 13.37\u306erc.mysqld\u306b\u306f\uff0c–skip-networking\u304c\u3042\u308b\u306e\u3067\u524a\u9664\uff0e<\/p>\n
\u4f55\u5ea6\u3082\u3084\u3063\u3066\u307e\u3059^^;<\/p>\n
\u30e1\u30e2<\/h2>\n
\u8a8d\u8a3c\u306b\u95a2\u3059\u308b\u30d0\u30b0\u30002012-06-12<\/h3>\n
\u8a8d\u8a3c\u306b\u95a2\u3059\u308b\u8106\u5f31\u6027\u304c\u3042\u308b\u3068\u3044\u3046\u3053\u3068\u306a\u306e\u3067\uff0c5.5.25\u306b\u4e0a\u3052\u307e\u3057\u305f\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
CMake\u306e\u30aa\u30d7\u30b7\u30e7\u30f3 MySQL 5.5.x\u3067\uff0cSlackware\u6e96\u62e0\uff0e CFLAGS=”-O2 -march=i486 -mtune=i686″ \\ CXXFLAGS=”-O2 -march=i486 -mtune=i686 -felide-constructors -fno-exceptions -fno-rtti” \\ CXX=gcc \\ cmake \\ -DBUILD_CONFIG=mysql_release \\ -DFEATURE_SET=”community” \\ -DINSTALL_LAYOUT=”RPM” \\ -DCMAKE_INSTALL_PREFIX=\/usr \\ -DINSTALL_LIBDIR=lib \\ -DINSTALL_SBINDIR=libexec \\ -DINSTALL_INCLUDEDIR=include\/mysql \\ -DINSTALL_MYSQLSHAREDIR=share\/mysql \\ -DINSTALL_SQLBENCHDIR= \\ -DINSTALL_MYSQLTESTDIR=mysql-test \\ -DINSTALL_INFODIR=info \\ -DINSTALL_MANDIR=man \\ -DINSTALL_PLUGINDIR=”lib\/mysql\/plugin” \\ -DINSTALL_SCRIPTDIR=bin \\ -DINSTALL_SUPPORTFILESDIR=share\/mysql \\ -DINSTALL_MYSQLDATADIR=”\/var\/lib\/mysql” \\ -DMYSQL_DATADIR=”\/var\/lib\/mysql” \\ -DMYSQL_UNIX_ADDR=”\/var\/run\/mysql\/mysql.sock” \\ -DWITH_EXTRA_CHARSETS=complex … Continue reading “MySQL”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1110,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-1834","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages\/1834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1834"}],"version-history":[{"count":0,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages\/1834\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=\/wp\/v2\/pages\/1110"}],"wp:attachment":[{"href":"https:\/\/je1sgh.mydns.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}