mysql:10959
From: "T.Nakatuka" <"T.Nakatuka" <nakatuka@xxxxxxxxxx>>
Date: Sat, 12 Feb 2005 18:40:28 +0900
Subject: [mysql 10959] ½é¿´¼Ô¤ÇLAN¤¸¤ç¤¦¤«¤éMysql¤òinstall¤µ¤ì¤¿µ¡³£¤ËÀܳ¤Ç¤¤Þ¤»¤ó¡£
ÀèÆü¤âÅê¹Æ¤·¤«¤±¤Æ¡¢MYSQLÆþ¤ê¸ý¤¬Ê¬¤«¤é¤º¡¢ÃæÅÓȾü¤Ë¼ÁÌä¤ò ½ª¤¨¤¿¡¡ÃæÄͤǤ¹¡£ ºÆÅٽ鿴¼Ô¤Ç¤¹¤¬¸½¾õ¤òÀâÌÀ¤·¤Þ¤¹¤Î¤Ç¡¢²þ¤á¤Æ¤ª¶µ¤¨¤Ç¤Ç¤¤ëÊý¤¬¤ª¤¤¤Ç¤Ë¤Ê¤ì¤Ð ¤è¤í¤·¤¯¤ª´ê¤¤¤ò¤¤¤¿¤·¤Þ¤¹¡£ ¸½¾õ¤Ï¡¢OS¡¡¡§¡¡redhat9.0¤Ë¤è¤êinstall¤·¤¿linux MYSQL¤Ïrpm¤Ë¤è¤ê4.1.7¤òinstall¤ò¹Ô¤¤¤Þ¤·¤¿¡£ ¤¦¤Þ¤¯install¤Ç¤¤Æ¤¤¤ë¤¤¤ë¤Ä¤â¤ê¤Ê¤Î¤Ç¤¹¤¬¡£ root¤Î¥×¥í¥ó¥×¥È¤è¤ê mysqladmin ping ¤òtype¤¹¤ë¤È mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' ¥¨¥é¡¼¤òÊÖ¤·¤Þ¤¹¡£ ¤¿¤À¡¢UNIX¤Î¼Â¹Ô¥×¥í¥»¥¹¤ò¸«¤ì¤Ð ps ax | grep mysqld¡¡¤ò¸«¤ì¤Ð 3861 ? S 0:00 [mysqld-max] 24837 pts/0 R 0:00 grep mysqld ¤Èɽ¼¨¤µ¤ìmysql¤ÏÆ°¤¤¤Æ¤¤¤¤¤ëÍͤˤª¤â¤ï¤ì mysql -uroot -p mysql Enter password: ***** ¤ÈType¤¹¤ë¤È Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.7-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ¤¦¤Þ¤¯¤Ä¤Ê¤¬¤Ã¤Æ¤¤¤ëÍͤ˻פ¤¤Þ¤¹¡£ ¤³¤Î¾õÂ֤ϡ¢LAN¾å¤ÎWindows¤Îµ¡³£¤«¤éÀܳ½ÐÍè¤Æ¤¤¤ë¤Î¤«¡¢¤Ç¤¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«¡© -------------------------------------------------- /etc/my.conf ¤Îµ½Ò¡×ÆâÍƤϸ½ºß [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M ¤Î¤è¤¦¤ÊÉôʬ¤¬¼ç¤ÊÉôʬ¤È»×¤Ã¤Æ¤ª¤ê¤Þ¤¹¤¬¡¦¡¦¡¦¡¦¡¦ ¤Ê¤ª¡¢socket¤Ï¤½¤ì¤¾¤ì¤ÎÉôʬ¤Ë¥Ñ¡¼¥ß¥Ã¥·¥ç¥ó755¤Ç¤¢¤ê¤Þ¤¹¡£ »²¹Í¤Ç¤¹¤¬¡¢webmin¤«¤é¤ÏMysql¤ÏÆ°¤¤¤Æ¤¤¤ë¤è¤¦¤Ë¸«¤¨¤Þ¤¹¡£ ¤è¤í¤·¤¯¤´»ØƳ¤¯¤À¤µ¤¤¡£ +------------------------------- From T.Nakatuka E-Mail nakatuka@xxxxxxxxxx
-> 10959 2005-02-12 18:40 ["T.Nakatuka" <nakatu] ½é¿´¼Ô¤ÇLAN¤¸¤ç¤¦¤«¤éMysql¤òinstall¤µ¤ì¤¿µ¡³£¤ËÀܳ¤Ç¤¤Þ¤»¤ó¡£ 10960 2005-02-12 19:25 ¨²[Sumito_Oda <oda@xxxx] 10961 2005-02-12 19:35 ¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 10964 2005-02-13 03:34 ¡¡¨±["T.Nakatuka" <nakatu] 10965 2005-02-13 06:32 ¡¡¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 10968 2005-02-13 14:27 ¡¡¡¡¡¡¨±["T.Nakatuka" <nakatu] 10969 2005-02-13 14:57 ¡¡¡¡¡¡¡¡¨²[SUGIMURA Takashi ¿ùÂ] 10974 2005-02-13 20:45 ¡¡¡¡¡¡¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]