Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÕÒ»Ømysql µÄroot ÃÜÂë

£¨1£©ÒÔubuntuµÄrootÓû§µÇ½
£¨2£©Í£Ö¹MYSQL·þÎñÆ÷£º
        /etc/init.d/mysql stop
£¨3£©Ìø¹ýÊÚȨ±íÖ´ÐÐMYSQL·þÎñÆ÷£º
       mysqld_safe --skip-grant-tables --skip-networking &
 (×¢£º²ÎÊý--skip-grant-tablesÎªÌø¹ýÊÚȨ±í£»--skip-networkingΪ²»¼àÌýTCP/IPÁ¬½Ó)>
 £¨4£©Ö´ÐÐMYSQL¿Í»§¶Ë£º
      mysql
£¨5£©¸üÐÂrootÃÜÂë
      update mysql.user set passWord=password('ÐÂÃÜÂë') where user='root';
      flush privileges;
£¨6£©¹Ø±Õmysql·þÎñÆ÷£¬ÓÃÕý³£·½ÊÔÆð¶¯


Ïà¹ØÎĵµ£º

ÀûÓÃFederatedÒýÇæ½øÐÐmysql¸´ÖÆ

Accessing Distributed Data with the Federated Storage Engine
http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html
Federated´æ´¢ÒýÇæ¿ÉÒÔʹ¼¸Ì¨Êý¾Ý¿âÂß¼­ÉÏ×é³ÉÒ»¸öÊý¾Ý¿â£¬Æä×÷ÓÃÏ൱ÓÚOracleµÄÊý¾Ý¿âÁ´½Ó£¬Í¨Ë×µØËµ£¬¼´ÔÚ±¾µØ½¨Á¢Ô¶³ÌµÄÊý¾Ý¿â±íµÄÒýÓá£
MysqlÐèÒª5.0ÒÔÉÏ
£¨1£©²é¿´ÊÇ ......

MySQL´æ´¢ÒýÇæ

MySQL³£ÓõĴ洢ÒýÇæÎªMyISAM¡¢InnoDB¡¢MEMORY¡¢MERGE£¬ÆäÖÐInnoDBÌṩÊÂÎñ°²È«±í£¬ÆäËû´æ´¢ÒýÇæ¶¼ÊÇ·ÇÊÂÎñ°²È«±í¡£
MyISAMÊÇMySQLµÄĬÈÏ´æ´¢ÒýÇæ¡£MyISAM²»Ö§³ÖÊÂÎñ¡¢Ò²²»Ö§³ÖÍâ¼ü£¬µ«Æä·ÃÎÊËٶȿ죬¶ÔÊÂÎñÍêÕûÐÔûÓÐÒªÇó¡£
InnoDB´æ´¢ÒýÇæÌṩÁ˾ßÓÐÌá½»¡¢»Ø¹öºÍ±ÀÀ£»Ö¸´ÄÜÁ¦µÄÊÂÎñ°²È«¡£µ«ÊÇ±ÈÆðMyISAM´æ´¢Òý ......

MySql´´½¨º¯Êý

Ê×ÏÈÐèÒª²é¿´Ò»Ï´´½¨º¯ÊýµÄ¹¦ÄÜÊÇ·ñ¿ªÆô£º
mysql> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name                          ......

PHP5ºÍMySQLѧϰ 2010.3.2

Ò»ÏîÄ¿¿ª·¢
ÐèÇó·ÖÎö¡¢ÏµÍ³·ÖÎö¡¢ÏµÍ³Éè¼Æ¡¢³ÌÐò¿ª·¢¡¢¼¯³ÉºÍ²âÊÔ
¶þ¡¢ÏîÄ¿·Ö¹¤
³ÌÐòÉè¼Æ¡¢¹²ÓÃ×é¼þÉè¼Æ¡¢Êý¾Ý¿â¡¢ÃÀ¹¤¡¢Îļþ±àд¡¢Êý¾ÝÊäÈë¡¢°²×°Î¬»¤¿Í·þ
Èý¡¢MySQL
Ëٶȿ죬֧³Ö¶àÏß³ÌÓë¶àÓû§Í¬Ê±ÔÚÏߵĹØÏµÊý¾Ý¿â¹ÜÀíϵͳ
»ù±¾µÄMySQLÃüÁîµÄ¼ÇÒä
ËÄ¡¢HTML
»ù±¾htmlµÄÓï¾ä ......

MySQL´íÎóÐÅÏ¢

ת×Ô: http://www.phpweblog.net/lemon2maple/archive/2007/07/29/1397.html
mysqlµÄ³ö´í´úÂë±í£¬¸ù¾ÝmysqlµÄÍ·Îļþmysql/include/mysqld_error.hÕûÀí¶ø³É¡£´íÎóÖ®´¦£¬Çë´ó¼ÒÖ¸Õý¡£
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ