[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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]