ÕÒ»Ø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·þÎñÆ÷£¬ÓÃÕý³£·½ÊÔÆð¶¯
Ïà¹ØÎĵµ£º
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³£ÓõĴ洢ÒýÇæÎªMyISAM¡¢InnoDB¡¢MEMORY¡¢MERGE£¬ÆäÖÐInnoDBÌṩÊÂÎñ°²È«±í£¬ÆäËû´æ´¢ÒýÇæ¶¼ÊÇ·ÇÊÂÎñ°²È«±í¡£
MyISAMÊÇMySQLµÄĬÈÏ´æ´¢ÒýÇæ¡£MyISAM²»Ö§³ÖÊÂÎñ¡¢Ò²²»Ö§³ÖÍâ¼ü£¬µ«Æä·ÃÎÊËٶȿ죬¶ÔÊÂÎñÍêÕûÐÔûÓÐÒªÇó¡£
InnoDB´æ´¢ÒýÇæÌṩÁ˾ßÓÐÌá½»¡¢»Ø¹öºÍ±ÀÀ£»Ö¸´ÄÜÁ¦µÄÊÂÎñ°²È«¡£µ«ÊÇ±ÈÆðMyISAM´æ´¢Òý ......
Ê×ÏÈÐèÒª²é¿´Ò»Ï´´½¨º¯ÊýµÄ¹¦ÄÜÊÇ·ñ¿ªÆô£º
mysql> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name   ......
Ò»ÏîÄ¿¿ª·¢
ÐèÇó·ÖÎö¡¢ÏµÍ³·ÖÎö¡¢ÏµÍ³Éè¼Æ¡¢³ÌÐò¿ª·¢¡¢¼¯³ÉºÍ²âÊÔ
¶þ¡¢ÏîÄ¿·Ö¹¤
³ÌÐòÉè¼Æ¡¢¹²ÓÃ×é¼þÉè¼Æ¡¢Êý¾Ý¿â¡¢ÃÀ¹¤¡¢Îļþ±àд¡¢Êý¾ÝÊäÈë¡¢°²×°Î¬»¤¿Í·þ
Èý¡¢MySQL
Ëٶȿ죬֧³Ö¶àÏß³ÌÓë¶àÓû§Í¬Ê±ÔÚÏߵĹØÏµÊý¾Ý¿â¹ÜÀíϵͳ
»ù±¾µÄMySQLÃüÁîµÄ¼ÇÒä
ËÄ¡¢HTML
»ù±¾htmlµÄÓï¾ä ......
ת×Ô: http://www.phpweblog.net/lemon2maple/archive/2007/07/29/1397.html
mysqlµÄ³ö´í´úÂë±í£¬¸ù¾ÝmysqlµÄÍ·Îļþmysql/include/mysqld_error.hÕûÀí¶ø³É¡£´íÎóÖ®´¦£¬Çë´ó¼ÒÖ¸Õý¡£
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾ ......