http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
°øÁö»çÇ×  
´º½º  
Áú¹®°ú ´äº¯
DBA
Developer
Cluster
ÅäÅ©¹Ú½º  
À̺¥Æ®  
¼­Æ÷Æ® ƼÄÏ  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
Áú¹®°ú ´äº¯ (DBA) > Ä¿¹Â´ÏƼ Á¸ > Áú¹®°ú ´äº¯ (DBA)
Can't open and lock privilege tables: Table 'mysql.host' doesn't exist ¿¡·¯ ¸Þ¼¼Áö
±Û¾´ÀÌ : ÃÊ¿ø   ³¯Â¥ : 19-05-09 05:04   Á¶È¸¼ö : 5514
¾È³çÇϼ¼¿ä MySqlÀ» ±â¹ÝÀ¸·Î DB¸¦ »ç¿ëÁß¿¡ »ç¿ëÀÌ ºÒ°¡ÇÏ¿© È®ÀÎÇÏ´Ï ¾Æ·¡¿Í °°Àº Log °¡ ±â·ÏµÇ¾ú½À´Ï´Ù.

90507 11:13:20 mysqld_safe Starting mysqld daemon with databases from /mnt/VOL1/MySql
190507 11:13:20 InnoDB: The InnoDB memory heap is disabled
190507 11:13:20 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
190507 11:13:20 InnoDB: Compressed tables use zlib 1.2.1
190507 11:13:20 InnoDB: Initializing buffer pool, size = 128.0M
190507 11:13:20 InnoDB: Completed initialization of buffer pool
190507 11:13:20 InnoDB: highest supported file format is Barracuda.
190507 11:13:20 InnoDB: 1.1.8 started; log sequence number 84063280
190507 11:13:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
190507 11:13:20 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
190507 11:13:20 [Note] Server socket created on IP: '0.0.0.0'.
190507 11:13:20 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
190507 11:13:20 mysqld_safe mysqld from pid file /mnt/VOL1/MySql/ipTimeNAS2.pid ended

MySQL server´Â NAS2  (Iptime) ¿¡ ±¸ÃàÀ» ÇØ¼­ »ç¿ëÁßÀ̾ú½À´Ï´Ù. ¹öÁ¯Àº 5.2.  ÀÔ´Ï´Ù.   
°í¼ö´ÔµéÀÇ ¸¹Àº °¡¸£Ä§ ±â´Ù¸®°Ú½À´Ï´Ù.

royster
MySQL 5.2 ¹öÀüÀº ¸±¸®Áî µÈ ÀûÀÌ ¾ø´Â°ÍÀ¸·Î ¾Æ´Âµ¥¿ä^^
¿À·ù³»¿ëÀº mysql.host Å×À̺íÀ» ÀνÄÇÒ ¼ö ¾ø´Ù´Â ¿À·ù¸Þ¼¼ÁöÀÔ´Ï´Ù.
mysql.host Å×À̺íÀº 5.5.x ¹öÀü±îÁö¸¸ Á¸ÀçÇϸç 5.6.x ÀÌÈĺÎÅÍ´Â Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù.
±×·¯¹Ç·Î  5.0 , 5.1, 5.5 ¹öÀüÁß ÇϳªÀÎµí ½Í±¸¿ä
/MySQL-DataDir/mysql  µð·ºÅ丮¿¡  host.frm , host.MYD , host.MYI ÆÄÀϵéÀÌ Á¸ÀçÇÏ´ÂÁö ºÎÅÍ È®ÀÎÇϼ¼¿ä
ÀÌÀü±Û mysql server ¼³Ä¡ ÇÏ´ÂÁß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. 
´ÙÀ½±Û µà¾ó¸¶½ºÅÍ ±¸¼º ½Ã ÀϺΠÅ×ÀÌºí µ¥ÀÌÅÍ µ¿±âÈ­°¡ ¾ÈµÇ¾úÀ» ½Ã Á¶Ä¡ ¹æ¹ý 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.