¸¶½ºÅÍÆ÷À¯(Master4U)
Monday, 17 of January
 

·Î±×ÀÎ Category
MYSQL ½ÇÇà½Ã ³ªÅ¸³ª´Â ¿À·ù ¹× ´ë󹿹ý[Æß]
°ü¸®ÀÚ  2012-08-25 12:45:09 Hit:7697
¸µÅ© #1: http://search.naver.com/search.naver?where=nexearch&query=+Fatal+error%3A+Can%27t+open+and+lock+privilege+tabl&sm=top_hty&fbm=1&
¸µÅ© #2: http://cafe.naver.com/elysions/123


1. ./configure ½Ã¿¡ ¿¡·¯
Áõ»ó1

checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure: error: No curses/termcap library found
[root@localhost mysql-4.0.13]# make
make: *** No targets specified and no makefile found. stop.

Q1 : ¿Ö ÀÌ·± ¸Þ¼¼Áö°¡ ¶ß³Ä?

A1: gcc°¡ ¾ø´øÁö PATH°¡ ¾ÈÀâÇô ÀÖ´Â °æ¿ì



Q2 : configure: error: no acceptable C compiler found in $PATH
¼³Ä¡¸¦ À߸ø ÇѰǰ¡?
[root@localhost mysql-4.0.13]make ½ÇÇà ½Ã
make: *** No targets specified and no makefile found.  ¸ØÃã.
¸Þ¼¼Áö ¶ß´Âµ¥ ¾îÄÉ?

A2 : ¸®´ª½º¿¡ gcc°¡ ¼³Ä¡µÆ´ÂÁö È®ÀÎÇ϶ó.
# rpm -qa| grep gcc

2. ¼Ò½º ¼³Ä¡½Ã "NOTE: This is a MySQL binary distribution." ¶ó´Â ¸Þ½ÃÁöÀÇ °æ¿ì
Q : It's ready to run, you don't need to configure it! ³ª¿É´Ï´Ù. ÀÌÀ¯°¡?

A : ÄÄÆÄÀÏÀÌ ÇÊ¿ä¾ø´Â ¹ÙÀ̳ʸ®¸¦ ¹ÞÀº°Å °°´Ù. ÀÌ¹Ì ÄÄÆÄÀÏÇÑ °Å´Ù.
  ¾ÐÃàÇ®°í Àû´çÇÑ À§Ä¡·Î À̵¿½ÃÄѶó.

tar zxvf mysql-xx.xx.tar.gz
mv mysql-xx.xx /usr/local/
ln -s /usr/local/mysqlxx.xx /usr/local/mysql

3. mysqlÀ» ½ÇÇàÇϸé (2)¹ø ¿¡·¯
Q : ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock' (2) ¹«½¼ ¿¡·¯ÀÎÁö¿ä?

A : µ¥¸ó ±¸µ¿½Ã ./safe_mysqld --user=mysql & ½ÇÇà ½ÃÄѺ¸¶ó.
±×·¡µµ ¿¡·¯°¡ ³¯ °æ¿ì ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock ÇØº¸¶ó.

4. mysql.sock Áß¿¡ (40)¹ø¿¡·¯
Q : ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock' (40)

A : chown mysql.mysql -R /var/lib/mysql ¸¦ Çϱ⠹ٶõ´Ù.
±×¸®°í Âü°í·Î php¿¡¼­ÀÇ mysql socket Àº /etc/php.ini ¿¡¼­ °æ·Î¸¦ ¼öÁ¤ÇÒ ¼ö ÀÖ´Ù.

5. mysql µ¥¸óÀÌ Á×¾î¹ö¸±¶§
Q : # ./mysqld_safe &
    chown mysql .. <-- ºñ½ÁÇÑ ¿À·ù°¡ ¶ß¸é¼­ µ¥¸óÀÌ Á×¾î¹ö¸°´Ù.¾îÄÉ?



A : ·¹µåÇÞ ¸®´ª½º¶ó¸é groupadd ¿Í useradd ¿¡ '-r' ¿É¼ÇÀ» »ç¿ëÇ϶ó.
# useradd -r -d /usr/local/mysql mysql
ÀÌ·¸°Ô Çϸé 500 º¸´Ù ÀÛÀº UID, GID¸¦ °¡Áø mysql ±×·ì°ú »ç¿ëÀÚ°¡ »ý¼ºµÈ´Ù.


6. mysql ½ÇÇà½Ã µ¥¸ó ¹Ù·Î Á×À½
Q :

030527 22:33:39  mysqld started
030527 22:33:39  Can't start server: Bind on TCP/IP port: ÁÖ¼Ò°¡ ÀÌ¹Ì »ç¿ë Áß

030527 22:33:39  Do you already have another mysqld server running on port: 3306 ?
030527 22:33:39  Aborting
030527 22:39:50  /usr/local/mysql/libexec/mysqld: Shutdown ÀÌ ¿Ï·áµÊ!
030527 22:39:50  mysqld ended

A : 3306 Æ÷Æ®¿¡ ÀÌ¹Ì ´Ù¸¥ mysqld °¡ ½ÇÇàµÇ°í ÀÖ´Ù.
# vi /mysql/scripts/mysql_config À» ¿­¾î¼­ Æ÷Æ®¹øÈ£ ¼öÁ¤.


7. mysql-4.0.12 ¼³Ä¡ÈÄ µ¥¸óÀÌ ¾È¶ç¿öÁö°í ¹Ù·Î Á×À» °æ¿ì.
Q Á¤»óÀûÀ¸·Î ¼Ò½º ¼³Ä¡ÇÏ°í ³ª¼­,,
  /usr/local/mysql/bin/mysqld_safe & ½ÇÇàÇϸé,,, µ¥¸óÀÌ ½ÃÀÛÇÏÀÚ ¸¶ÀÚ ¹Ù·Î Á״´Ù.
./safe_mysqld Starting mysqld daemon with databases from /usr/local/mysql/var
   mysqld ended
¿¡·¯ ¸Þ¼¼Áö¸¦ º¸±â À§ÇØ /usr/local/mysql/var ·Î À̵¿  vinnylover.err ÆÄÀÏÀ» ¿­¾îº¸´Ï

¾Æ·¡¿Í °°Àº ¸Þ¼¼Áö°¡ ÀÖ´õ±º.
mysqld started
InnoDB: Started
Fetal error: Can't open privilege tables: Can't find file: ' ./mysql/host.frm'(errno: 13)'
Aborting

A : mysql_install_db ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇØ¼­ Ãʱâ Å×À̺íÀ» »ý¼º.
   # ./mysql_install_db ÇÏ¸é µÈ´Ù. (/usr/local/mysql/bin ¾Æ·¡¿¡¼­ Ç϶ó)

8. mysql sock ¿¡·¯ ¹®Á¦ÀÇ È®½ÇÇÑ ÇØ°á¹ý
Q : Á¢¼ÓÇϸé >/var/lib/mysql/mysql.sock ... (111)


A : µð·ºÅ丮 ÆÛ¹Ì¼Ç ¹®Á¦
# killall mysqld
# chmod 755 -R /var/lib/mysql

# chown mysql.mysql -R /var/lib/mysql
# mysqld_safe --language=korean &

9. make ¸í·É¾î¸¦ ½ÇÇàÇÏ¸é ¼³Ä¡°¡ ÇØÁ¦

Q : make[2]: *** No rule to make target `ctype-euc_kr.lo', needed by `bmove_upp.lo'. ¸ØÃã.
make[2]: ³ª°¨ `/usr/local/down/mysql-3.23.38/libmysql' µð·ºÅ丮
make[1]: *** [all-recursive] ¿À·ù 1
make[1]: ³ª°¨ `/usr/local/down/mysql-3.23.38' µð·ºÅ丮
make: *** [all-recursive-am] ¿À·ù 2

A : ¸ÕÀú LD_LIBRARY_PATH¿¡ ¸ðµç ¶óÀ̺귯¸® °æ·Î°¡ µé¾î°¡ ÀÖ¾î¾ß ÇÑ´Ù.
ÀÌ·± °æ¿ì¶§¹®¿¡ ÇÊ¿äÇÑ ¶óÀ̺귯¸®¸¦ ãÁö¸øÇØ ¿¡·¯°¡ ¹ß»ý.
°ÅÀÇ ÇÊ¿äÇÑ ÆÐŰÁö¸¦ ¼³Ä¡Çߴµ¥µµ ¿¡·¯°¡ ³ª¸é LD_LIBRARY_PATH¸¦ È®ÀÎÇØº¼ Çʿ䰡 ÀÖ´Ù.

10. mysql ¼³Ä¡½Ã gcc¿¡·¯³ª´Âµ¥ ÇØ°áÃ¥

Q :

# ./configure --prefix=/usr/local/mysql --with-charset=euc_kr
checking for c++... c++
checking whether the C++ compiler (c++   ) works... no
configure: error: installation or configuration problem: C++ compiler cannot create executables.

A : rpmÀ¸·Î ã¾Æ¼­ ´Ù ¼³Ä¡ÇÏ°í ³ª¼­ ÄÄÆÄÀÏ ÇÏ¸é µÈ´Ù.
rpmfind.net¿¡¼­ ãÀ¸½Ç ¼ö ÀÖ½À´Ï´Ù. ¿¡·¯ º¸°í ÇϳªÇϳª ´Ù ¼³Ä¡ÇÏ¸é µÈ´Ù.

11. ÀνºÅç ¼³Ä¡µµÁß 103 ¿¡·¯
Q : an error occured move data process: -103
compenent : server

A : mysql ¼³Ä¡µÈ Æú´õ¸¦ ¿ÏÀü½Ã »èÁ¦ ÈÄ À缳ġ

12. mysql¼³Ä¡ ½Ã invalid user ¿À·ù

Q : chown: mysql: invalid user
Starting mysqld daemon with databases from /usr/local/mysql/data
030417 11:42:35  mysqld ended

A : mysql À̶õ À¯Á®°¡ À¯È¿ÇÏÁö ¾Ê´Ù¶ó´Â ¿¡·¯·Î½á ÇöÀç mysqlÀ̶õ °èÁ¤ÀÌ Á¸ÀçÇÏÁö ¾Ê±â¶§¹®¿¡ ³ª´Â ¿¡·¯

# /usr/sbin/useradd mysql -M -s /bin/false

# chown -R root /usr/local/mysql
# chown -R mysql /usr/local/mysql/var
# chgrp -R mysql /usr/local/mysql

13. mysql 4.0.12 ¼³Ä¡ ½Ã "Check your system clock" ¿À·ù
Q

# ./configure --prefix=/usr/local/mysql --with-charset=euc_kr
ÀÌ·¸°Ô Çߴµ¥ ´ÙÀ½°ú °°Àº ¸Þ¼¼ÁöÀÇ °æ¿ì....
checking build system type... i686-pc-linux
checking host system type... i686-pc-linux
checking target system type... i686-pc-linux
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... configure: error: newly created file is older than distributed files!
Check your system clock

A : mysqlÀÌ °³¹ßµÈ ½Ã°£º¸´Ù ÇöÀç½Ã°£ Â÷ÀÌ·Î »ý±â´Â ¹®Á¦
ÀÎÅͳÝ(³×Æ®¿÷)ÀÌ µÇ´Â »óȲÀ̶ó¸é
# date

# rdate -s time.bora.net   => rdate -s time.nuri.net¿Í °°ÀÌ ´Ù¸¥¼­¹ö·Î ÇØµµ µÈ´Ù.

# date


14. ¼³Ä¡½Ã configure: error: no acceptable cc found in $PATH ¿¡·¯
Q :

configure: error: no acceptable cc found in $PATH


A : cc Áï c complier °¡ ¾ø´Ù
c ÄÄÆÄÀÏ·¯°¡ PATH¿¡ ¾ÈÀâÇô ÀÖÀ» ¼ö ÀÖ´Ù. path¸¦ Ãß°¡Çϰųª gcc¸¦ À缳ġ

# vi /etc/profile

PATH=$PATH:.:/usr/local/mysql/bin

15. config½Ã ERROR: 1062 Duplicate entry 'localhost-root' for key 1
Q : mysql ¼Ò½º¼³Ä¡ config½Ã ¿¡·¯ÀÇ °æ¿ì

rpm¹öÀü »èÁ¦Çߴµ¥ µ¥¸óÀÌ »ì¾Æ ÀÖ³ª? ps -ax | grep mysql ÇÏ¸é ¾Ï°Íµµ ¾È³ª¿Â´Ù.
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
030312 14:58:03 ./bin/mysqld: Shutdown Complete

A : ij½Ã¿¡ ÀÌÀüµ¥¸óÀÌ »ì¾ÆÀֱ⠶§¹®ÀÌ´Ù.
kill  ¶Ç´Â killall ¸í·ÉÀ¸·Î ÇÁ·Î¼¼½º¸¦ ¿ÏÀüÈ÷ Á×ÀÌ°í ¼³Ä¡Ç϶ó

16. configure ¿¡·¯·Î "error : No curses/termcap library found" ¿¡·¯?
Q : checking for termcap functions library...
configure: error : No curses/termcap library found

A : libtermcap-devel-xxx ÆÐŰÁö°¡ ÇÊ¿äÇØ¼­ ¹ß»ýÇÏ´Â ¿¡·¯
¼³Ä¡½Ãµð¸¦ ³ÖÀ¸½Ã°í ¼³Ä¡¸¦ Çϸé ÇØ°áµÈ´Ù.

-----------------------------------------------------------------------------------
º»¹®Àμ⺻¹®¸ÞÀϹ߼Û
¡â mysql ¼ÒÀ¯ Å×ÀÌºí ¸ðµÎ »èÁ¦ÇÏ´Â ½ºÅ©¸³Æ®
¡ä had no or invalid character set, and default character set is multi-byte
Copyright 1999-2025 Zeroboard / skin by ChanBi