모노모노 :: Mysql 에러 - Timeout error occurred trying to start MySQL Daemon.

Mysql 에러 - Timeout error occurred trying to start MySQL Daemon.

리눅스/Mysql 2011. 11. 29. 14:41

/var/log/mysqld.log

mysqld started
[Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
[Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
mysqld ended

해결방법

/usr/bin/mysql_install_db --user=mysql

mysql_install_db ==> mysql 권한 테이블을 생성
위 명령어를 실행 후 mysql 데몬 실행을 다시 한다.

'리눅스 > Mysql' 카테고리의 다른 글

ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO (0)	2014.07.03
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist (0)	2013.07.17
mysqldump: Got error: 145: Table './user/DB명' is marked as crashed and should be repaired when using LOCK TABLES (0)	2013.02.06
Mysql 'is marked as crashed and should be repaired' 에러 (그누보드 로그인안됨) (0)	2012.05.29
Mysql 에러 - Timeout error occurred trying to start MySQL Daemon. (1)	2011.11.29
mysql 사이트 메뉴얼 (0)	2011.05.17