{"id":7,"date":"2007-05-06T23:47:00","date_gmt":"2007-05-06T14:47:00","guid":{"rendered":"http:\/\/160.251.178.57\/index.php\/2007\/05\/06\/sun_linux_mysql_1\/"},"modified":"2018-02-07T17:43:48","modified_gmt":"2018-02-07T08:43:48","slug":"sun_linux_mysql_1","status":"publish","type":"post","link":"https:\/\/tsk-server.com\/?p=7","title":{"rendered":"SUN LINUX \u306b mysql \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"

1\u3001\u30bd\u30fc\u30b9\u306eDOWNLOAD<\/strong>
\n\u3053\u3053<\/a>\u304b\u3089tar\u30dc\u30fc\u30eb\u3092DL\u3059\u308b\u3002
\n2.\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u9069\u5f53\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30b3\u30d4\u30fc\u3057\u3001\u89e3\u51cd\u3059\u308b <\/strong>$ tar zxvf mysql-5.0.37.tar.gz
\n3.\u89e3\u51cd\u5f8c\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5fdc\u3058\u305f\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u79fb\u52d5<\/strong>
\ncd\u3000mysql-5.0.37\/
\n4,\u65b0\u898f\u30e6\u30fc\u30b6\u3001\u30b0\u30eb\u30fc\u30d7\u3092\u751f\u6210 <\/strong>
\n# groupadd mysql
\n# useradd -g mysql mysql
\n# passwd mysql
\n5.configure<\/strong>
\n$ .\/configure –prefix=\/usr\/local\/mysql\u3000–with-charset=ujis–with-extra-charsets=all–with-mysqld-user=mysql
\n\u3000
\n6,\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/strong>
\n#make
\n# make install
\n7.\u521d\u671f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/strong>
\n#mysql-5.0.37\/scripts\/mysql_install_db
\nInstalling all prepared tables
\nFill help tables
\nTo start mysqld at boot time you have to copy support-files\/mysql.server
\nto the right place for your system
\nPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
\nTo do so, start the server, then issue the following commands:
\n\/usr\/local\/bin\/mysqladmin -u root password ‘new-password’
\n\/usr\/local\/bin\/mysqladmin -u root -h localhost.localdomain password ‘new-password’
\nSee the manual for more instructions.
\nNOTE: If you are upgrading from a MySQL <= 3.22.10 you should run\nthe \/usr\/local\/bin\/mysql_fix_privilege_tables. Otherwise you will not be\nable to use the new GRANT command!\nYou can start the MySQL daemon with:\ncd \/usr\/local ; \/usr\/local\/bin\/mysqld_safe &\nYou can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:\ncd sql-bench ; perl run-all-tests\nPlease report any problems with the \/usr\/local\/bin\/mysqlbug script!\nThe latest information about MySQL is available on the web at\nhttp:\/\/www.mysql.com\nSupport MySQL by buying support\/licenses at http:\/\/shop.mysql.com\n[root@localhost var]# mysql -u root\nERROR 2002 (HY000): Can't connect to local MySQL server through socket '\/tmp\/mysql.sock' (61)\n\u3053\u306e\u30a8\u30e9\u30fc\u306e\u3068\u304d\u306f\u3000mysql\u304c\u3042\u304c\u3063\u3066\u306a\u3044\u3089\u3057\u3044\u3002\n8.mysql\u306e\u8d77\u52d5<\/strong>
\n# \/usr\/local\/mysql\/bin\/mysqld_safe &
\n\u3053\u3053\u3067\u3000\u554f\u984c\u767a\u751f\uff01\u4ee5\u4e0b\u306e\u30a8\u30e9\u30fc\u3067\u3000DB\u8d77\u52d5\u305b\u305a\u3002
\n[root@localhost var]# Starting mysqld daemon with databases from \/usr\/local\/var
\nSTOPPING server from pid file \/usr\/local\/var\/localhost.localdomain.pid
\n070506 14:21:15 mysqld ended
\nmysql\u306e\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u898b\u308b\u3068\u3001access rights\uff08 \u30a2\u30af\u30bb\u30b9\u6a29\uff09\u304c\u306a\u3044\u3068\u3042\u3063\u305f\u3002
\n070506 13:22:37 mysqld started
\n070506 13:22:38 InnoDB: Operating system error number 13 in a file operation.
\nInnoDB: The error means mysqld does not have the access rights to
\nInnoDB: the directory.
\nInnoDB: File name .\/ibdata1
\nInnoDB: File operation call: ‘create’.
\nInnoDB: Cannot continue operation.
\n070506 13:22:38 mysqld ended
\n\u30a8\u30e9\u30fc\u306b\u51fa\u3066\u3044\u308b\u3001\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u30aa\u30fc\u30ca\u30fc\u3001\u30d1\u30fc\u30df\u30c3\u30b7\u30e7\u30f3\u3092\u78ba\u8a8d\u3059\u308b\u3068\u3001
\nroot\u306b\u306a\u3063\u3066\u3044\u305f\u306e\u3067\u3001mysql\u306b\u5909\u66f4\u3057\u3001\u307b\u304b\u3000\u30d1\u30fc\u307f\u30b7\u30e7\u30f3\u3092\u8abf\u6574\u3002
\n\u518d\u5ea6
\n[root@localhost var]# \/usr\/local\/bin\/mysqld_safe &
\n[1] 15343
\n[root@localhost var]# Starting mysqld daemon with databases from \/usr\/local\/var
\n9,mysql -u root\u3067\u3000DB\u306b\u30a2\u30af\u30bb\u30b9<\/strong>
\n[root@localhost \/root]#
\n[root@localhost \/root]# mysql -u root
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 1
\nServer version: 5.0.37 Source distribution
\nType ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.
\nmysql>
\n[root@localhost local]# mysql -V
\nmysql Ver 14.12 Distrib 5.0.37, for unknown-linux-gnu (sparc) using EditLine wrapper
\n[root@localhost local]#<\/p>\n","protected":false},"excerpt":{"rendered":"

1\u3001\u30bd\u30fc\u30b9\u306eDOWNLOAD \u3053\u3053\u304b\u3089tar\u30dc\u30fc\u30eb\u3092DL\u3059\u308b\u3002 2.\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u9069\u5f53\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30b3\u30d4\u30fc\u3057\u3001\u89e3\u51cd\u3059\u308b $ tar zxvf mysql-5.0.37.tar.gz 3.\u89e3\u51cd\u5f8c\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u306b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3,4],"tags":[],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-linux","category-4"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":1,"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":1520,"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions\/1520"}],"wp:attachment":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}