
 |
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 ÆÐŰÁö°¡ ÇÊ¿äÇØ¼ ¹ß»ýÇÏ´Â ¿¡·¯
¼³Ä¡½Ãµð¸¦ ³ÖÀ¸½Ã°í ¼³Ä¡¸¦ Çϸé ÇØ°áµÈ´Ù.
----------------------------------------------------------------------------------- | |
|
|
|
|
|
|