mysql 不检查host_MySQLÎÞ·¨Æô¶¯£ºTable mysql.host doesn t exist

MySQLÎÞ·¨Æô¶¯£ºTable mysql.host doesn t exist

2019/10/10/17:34:15  ÔĶÁ£º1211  À´Ô´£º¹È¸èSEOËã·¨  ±êÇ©£º

΢ÐŹ«ÖÚºÅ

MySQLÎÞ·¨Æô¶¯£ºTable \'mysql.host\' doesn\'t exist,ÏÂÃæÎÒÀ´½éÉÜÈçºÎ½â¾öÕâ¸öÎÊÌâ,°²×°ºÜ˳Àûµ«ÎÞ·¨Æô¶¯£¬ÏëÁËÏë¿ÉÄÜÊÇ֮ǰÎó²Ù×÷/var/Ŀ¼µÄȨÏÞ,µ¼ÖÂûÓÐдȨÏÞµ¼ÖµÄ,µ«ÖØÐÂÉèÖÃдȨÏÞÖ®ºóÈÔ²»ÄÜÕýÈ·Æô¶¯.

Ìáʾ:Timeout error occurred trying to start MySQL Daemon.Starting MySQL: [FAILED]

¼ì²éÁËMySQLµÄÈÕÖ¾£¨cat /var/log/mysqld.log£©·¢ÏÖÌáʾһ¸ö´íÎó£¨[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist£©

²Â²â¿ÉÄÜÊÇMySQLµÄĬÈÏÊý¾Ý¿âûÕý³£°²×°£¬µ«Ð¶ÔØMySQL£¨yum remove mysql-server£©ÔÙÖØ×°(yum install mysql-server)»¹ÊDz»ÐУ¬ÏÖÏóºÍÔ­À´Ò»Ñù¡£ºóÀ´ÕÒµ½Ò»¸öרÃÅ°²×°Ä¬ÈÏÊý¾Ý¿âµÄÃüÁmysql_install_db£¬Ö´ÐÐÖ®ºó£¬ÔÙÆô¶¯MySQL£¨/etc/init.d/mysqld start£©ÖÕÓÚ¿´µ½¾ÃÎ¥µÄOK,´úÂëÈçÏÂ:#/etc/init.d/mysqldstart

StartingMySQL:[OK]

ÎÊÌâ¶þ,ÓÃsafe_mysqldqÆô¶¯µÄʱºò,³öÏÖ:

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

×îÖÕ½â¾ö·½·¨ÈçÏÂ:

ÔÚmysqlµÄ°²×°Ä¿Â¼ÏÂ,ÎÒµÄÊÇ/usr/local/mysql,´úÂëÈçÏÂ:

./scripts/mysql_install_db --usrer=mysql --datadir=/usr/local/mysql/data/

Ô­ÒòÊÇÖØ×°µÄʱºòÊý¾ÝĿ¼²»Ò»Öµ¼ÖÂ.

ÎÊÌâÈý,˵һÏÂÎÒ½â¾öµÄ¹ý³Ì,°´ÕÕmysqlµÄ°²×°²½Öè,´úÂëÈçÏÂ:shell>groupaddmysql

shell>useradd-gmysqlmysql

shell>gunzip

shell>cdmysql-VERSION

shell>./configure--prefix=/usr/local/mysql

shell>make

shell>makeinstall

shell>scripts/mysql_install_db--user=mysql

shell>chown-Rroot/usr/local/mysql

shell>chown-Rmysql/usr/local/mysql/var

shell>chgrp-Rmysql/usr/local/mysql

shell>cpsupport-files/my-medium.cnf/etc/my.cnf

shell>/usr/local/mysql/bin/mysqld_safe--user=mysql&

--phpfensi.com

ÕâÑù±ê×¼½øÐÐÏÂÀ´ÊÇûÓÐÎÊÌâµÄ,µ«ÔÚ×îºóÒ»²½Æô¶¯mysqlµÄʱºòÎÒÏ£Íû½«Êý¾Ý¿âµÄÊý¾ÝÎļþ·ÅÔÚÁíÍâÒ»¸öĿ¼ÏÂÃæ,Æô¶¯ÃüÁîÐÞ¸ÄΪ,´úÂëÈçÏÂ:

shell>/usr/local/mysql/bin/mysqld_safe --user=mysql --log-error=/u01/mysql/mysql_error/error --datadir=/u01/mysql/data

Õâ¸öʱºò¾Í³öÏÖÎÊÌâÁË,ÒòΪÔÚ½øÐгõʼ»¯Êý¾Ý¿âȨÏÞ±íµÄÄÇÒ»²½µÄʱºòĬÈÏ´´½¨µÄȨÏÞ±íÔÚĬÈÏĿ¼/usr/local/mysql/varÏÂÃæ,Õâ¾ÍÔì³ÉÁË,ÉÏÃæµÄ´íÎóÎÞ·¨ÕÒµ½ ȨÏÞ±í£ºCan't open and lock privilege tables:Table 'mysql.host' doesn't exist

½â¾ö°ì·¨:ÔÚÔËÐгõʼ»¯È¨ÏÞ±íµÄʱºòʹÓÃÔö¼Ó²ÎÊý--datadir,ÃüÁî¸ñʽΪ:

shell> scripts/mysql_install_db --user=mysql --datadir=/u01/mysql/data