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

mysql:4055

From: Michiya KOUNO <Michiya KOUNO <kholrabi@xxxxxxxxxx>>
Date: Wed, 25 Jul 2001 23:33:26 +0900
Subject: [mysql 04055] Re: root ¤«¤é¥¢¥¯¥»¥¹¤Ç¤­¤Þ¤»¤ó (MacOSX)

µÜÀ¤ó¡¢¥ì¥¹¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
>> [localhost:~] hoge% /usr/local/bin/mysqladmin -u root -p password 
>> 'hogehoge'
>
> ¤³¤Î -p ¤Ï¤¤¤é¤Ê¤¤¤Ç¤·¤ç¤¦¡£

> -p ¤òñÆȤǤĤ±¤ë¤È¡¢¥Ñ¥¹¥ï¡¼¥É¤Ä¤­Ç§¾Ú¤ò¤·¤è¤¦¤È¤·¤Æ¡¢¥Ñ¥¹¥ï¡¼¥É
> ÆþÎϤòµá¤á¤é¤ì¤Æ¤·¤Þ¤¦¤«¤é¤Ç¤¹¡£

¤³¤Î¥Ñ¥¹¥ï¡¼¥ÉÀßÄê¤Ïmysql_install_db¤ò¼Â¹Ô¤·¤¿¸å¤Ë½Ð¤ë¥á¥Ã¥»¡¼¥¸¤ÎÃæ¤Î
¥³¥Þ¥ó¥É¤Ç¤¹¤¬¡£
¤½¤ì¤¬´Ö°ã¤Ã¤Æ¤¤¤ë¤È¤¤¤¦¤³¤È¤Ç¤·¤ç¤¦¤«?
¤´»Ø¼¨Ä̤ê-p¤ò¤Ï¤º¤·¤Æ¤ä¤Ã¤Æ¤ß¤Þ¤·¤¿¤¬¡¢°Ê²¼¤Î¤è¤¦¤Ë¤À¤á¤Ç¤·¤¿¡£
¤Þ¤¿¤È¤ß¤¿¤µ¤ó¤«¤é¶µ¤¨¤Æ¤¤¤¿¤À¤¤¤¿ mysql -u nobody¡¡¤Ç¤¹¤¬¡¢mysql¤Ë
¥¢¥¯¥»¥¹¤Ç¤­¤¿¤â¤Î¤Î
Ãæ¤Î¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤Ë¤Ï¥¢¥¯¥»¥¹¤Ç¤­¤Þ¤»¤ó¡£mysqld¤Î-Sg¥ª¥×¥·¥ç¥ó¤â¸ú
¤­¤Þ¤»¤ó¡£

¤Þ¤¿¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
----- °Ê²¼¤Ï¥í¥°-----------
[localhost:~] hoge% /usr/local/bin/mysqladmin -u root password 'hogehoge'
[localhost:~] hoge% mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[localhost:~] hoge% su
Password:
[localhost:/Users/hoge] root# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[localhost:/Users/hoge] root# /usr/local/libexec/mysqld -Sg
010725 23:01:04  Can't start server: Bind on TCP/IP port: Address 
already in use
010725 23:01:04  Do you already have another mysqld server running on 
port: 3306 ?
010725 23:01:04  Aborting

010725 23:01:04  /usr/local/libexec/mysqld: Shutdown Complete

[localhost:/Users/hoge] root# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[localhost:/Users/hoge] root# mysql -u nobody
Welcome to the MySQL monitor.  Commands end with ; or Ùïõò ÍùÓÑãïîîåãôéïî éä éó ôï óåòöåò öåòóéïîº ³®²³®³
Ôùðå §èåìð»ïò ¤Â
íùóñì¾ õóäåáìéîÅÒÒϱ°´´Áããåóó äåîéåä æïõóåò§Àìïãáìèïóô§ ôï äáôáâáóå §äåáìéîçíùóñì¾ óèï÷ äáôáâáóåó»
«­­­­­­­­­­­Äáôáâáóå  «­­­­­­­­­­­äåáìéî  íåîáçåòéíùóñ    ôåóô      «­­­­­­­­­­­òï÷ó éî ó娰®°óåã©

íùóñì¾ õóíåîáçåòéÅÒÒϱ°´´Áããåóó äåîéåä æïõóåò§Àìïãáìèïóô§ ôï äáôáâáóå §íåîáçåòéåíùóñì¾
­­­­°Ê¾å-----------


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

      4009 2001-07-15 16:28 [²ÏÌîÄÌÌï <kholrabi@x] root ¤«¤é¥¢¥¯¥»¥¹¤Ç¤­¤Þ¤»¤ó (MacOSX)    
      4010 2001-07-15 20:40 ¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                                       
      4053 2001-07-25 00:18 ¡¡¨±["Michiya KOUNO" <kho]                                     
      4054 2001-07-25 00:28 ¡¡¡¡¨±[Tatsuhiko Miyagawa <]                                   
->    4055 2001-07-25 23:33 ¡¡¡¡¡¡¨±[Michiya KOUNO <kholr]                                 
      4056 2001-07-26 00:40 ¡¡¡¡¡¡¡¡¨±[Tatsuhiko Miyagawa <]                               
      4057 2001-07-26 01:36 ¡¡¡¡¡¡¡¡¡¡¨±[Michiya KOUNO <kholr]                             
      4058 2001-07-26 02:48 ¡¡¡¡¡¡¡¡¡¡¡¡¨±[Tatsuhiko Miyagawa <]                           
      4066 2001-07-26 23:41 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[Michiya KOUNO <kholr]