Mysql:Got error 28 from storage engine
½ñÌìÒ»´óÔ磬Áìµ¼¸øÎÒ´òµç»°£¬ËµÏµÍ³½ø²»È¥ÁË£¬±¨¸öGot error 28 from storage engineµÄ´íÎó¡£
¿´µ½Õâ¸ö´íÎó£¬Ó¦¸Ã²»ÊÇ×òÌì¸üгÌÐòÔì³ÉµÄ¡£¿´ÆðÀ´ÊÇMYSQL³öÎÊÌâÁË¡£ÓÃmysqlµÄ¿Í»§¶ËÈí¼þnavicat³¢ÊÔÁ¬½ÓÊý¾Ý¿â£¬µÃµ½Í¬ÑùµÄ´íÎó¡£
°Ù¶Èһϣ¬·¢ÏÖÓÐÈËÓöµ½´Ë´íµÄÔÒòÊÇ´ÅÅ̿ռäÂúÁË£¬SSHÉϵ½·þÎñÆ÷£¬¹ûÈ»·¢ÏÖ¸ùĿ¼ÒÑÂú¡£Çåµô¸ùϵÄijÓû§ÏµĴóÎļþºó£¬ÎÊÌâµÃµ½½â¾ö¡£
Ïà¹ØÎĵµ£º
1¡¢ÏÂÔØMySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¨²»ÓñàÒ룩
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´´½¨MySQL×飬½¨Á¢MySQLÓû§²¢¼ÓÈëµ½mysql×éÖÐ
£¨²»Í¬°æ±¾µÄUnixÖУ¬groupaddºÍuseraddµÄÓï·¨¿ÉÄÜ»áÉÔÓв»Í¬¡££©
#groupadd mysql
#useradd -g mysql mysql
3¡¢½øÈëĿ¼/usr/local£¬½âѹËõÃâ°²×°°æ£¬²¢ÔÚ ......
mysql> flush privileges;ʲôÒâ˼£¿
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';
mysql> flush privileges;
mysql> quit
´ð:
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......
myphpadmin¹¦ÄÜËäÈ»ÒѾºÜÇ¿£¬µ«Óû§ÌåÑé·½Ãæ²¢²»ºÜºÃ¡£
SQLyog
Mysql-front
EMS MySQL Manager
Mysqlcc
Navicat for MySQL
mysql-gui-tools
MySQL ͼÐι¤¾ß½éÉÜ£¨×ªÔØ£©
1¡¢Navicat
NavicatÊÇÒ»¸öÇ¿´óµÄMySQLÊý¾Ý¿â¹ÜÀíºÍ¿ª·¢¹¤¾ß¡£Navicatµ¼º½Îª×¨Òµ¿ª·¢ÕßÌṩÁËÒ»Ì×Ç¿´óµÄ×ã¹»¼â¶ËµÄ¹¤¾ß£¬µ«Ëü¶ÔÓÚÐÂÓû§ÈÔÈ» ......
ǰЩÌì¿´ÁËÀî¸Õ<struts2+hibernate+spring>ÄÇÊéÉϵÄhibernate£¬ÅäÖÃÎļþÒ²Êǰ´ÕÕÉÏÃæÇýøhibernate.cfg.xmlÎļþµÄ£¬Student.javaÅäÖõÄStudent.hbm.xmlÎļþ¾õµÃҲûʲôÎÊÌ⣬µ«²»Öªµ½Ôõô»ØÊ¾ÍÊDZ¨ connection can not open¡£ÓôÃÆ°¡£¬ºóÀ´ÎҾͰÑÊéÀïÃæµÄÅäÖÃÎļþºÍÔ´Â룬¸´ÖƵ½MyEclipseÏÂÃæµÄÒ»¸öÐÂwebÏîÄ¿ÖУ¬ÔËÐ ......