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

MySQL¿Í»§¶ËÔ¶³ÌÁ¬½Ó1045µÄ´íÎó

×î½üÐèҪʹÓÃMySQL£¬Ö»ºÃ¸Ï½ôѧϰһÏ¡£ÄÄÀïÖªµÀµÚÒ»²½¾Í¿¨×¡ÁË¡£×°ÁËÒ»¸ö¿Í»§¶Ë£¬Á¬²»ÉÏ£¬±¨1045µÄ´íÎó¡£
´ÓÍøÉÏÕÒÁËһϣ¬Èý²½¾ÍºÃ¡£
INSERT INTO `user` VALUES ('%','root','*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
GRANT ALL PRIVILEGES ON *.* TO root@"%";
FLUSH PRIVILEGES;
µÚÒ»²½ÎҸijÉinsertÁË¡£
»¹ÓоÍÊǶÔMySQL²»ÊìϤ£¬²»ÖªµÀÕâ¸öUSER±íµÄ¾ßÌåÓ÷¨£¬¾ÍÏȵ¼³öÀ´£¬¸´ÖÆÁËÒ»Ìõ¡£
µ¼³öµ¹ÊǺܷ½±ã£º
# mysqldump -uroot -ppass mysql > mysql.sql


Ïà¹ØÎĵµ£º

Mysql³£ÓÃÃüÁî

ËäÈ»ºÜ¶àÈËÓÃmysql front£¬ µ«ÊǸöÈ˾õµÃmysql»¹ÊÇÃüÁîÐÐϱȽϺÃÓ㬱Ͼ¹Êý¾Ý¿âÔÚÃüÁîÐÐϲÙ×÷±È½ÏÍõµÀ¶øÇÒmysqlÍêÈ«Ãâ·Ñ¡£¡£
ÏÂÃæ½éÉÜһЩmysqlÃüÁîÐÐϳ£ÓõÄÃüÁÓÐһЩÊý¾Ý¿â»ù´¡µÄ£¬¼´Ê¹ÊǵÚÒ»´ÎÓÃmysql¶ÔÕÕÏÂÃæµÄÃüÁî²Ù×÷Ò²ÍêÈ«¿ÉÒÔ£¬Èç¹ûÎÒ·¢ÏÖ»¹ÓÐÆäËüÃüÁîÒ²ÊǾ­³£Óõ½µÄÎÒ»á½Ðø¸üС£¡£¡£
·þÎñÆ÷£º
1. Æô¶¯m ......

»ùÓÚMySQLÊý¾Ý¿âµÄUTF8ÖÐÎÄÍøվȫÎļìË÷µÄʵÏÖ


http://hi.baidu.com/xiyouwang/blog/item/9f15bbee99b0ce202df5349e.html
ÏÖÔڵĻ¥ÁªÍøÉÏ£¬ºÜ¶àÍøÕ¾¶¼ÌṩÁËÈ«ÎÄËÑË÷¹¦ÄÜ£¬ä¯ÀÀÕß¿ÉÒÔͨ¹ýÊäÈë¹Ø¼ü×Ö»òÕßÊǶÌÓïÀ´ËÑË÷Ìض¨µÄ×ÊÁÏ¡£ÔÚPHP+MySQL¹¹¼ÜµÄÍøÕ¾ÖУ¬Í¨³£µÄ×ö·¨ÊÇͨ¹ýSELECT²éѯµÄLikeÓï¾äÀ´½øÐÐËÑË÷£¬ÕâÒ»°ì·¨´æÔÚËÑË÷²»¹»¾«È·¡¢ÒÔ¼°Ð§Âʷdz£µÍϵÄȱµã¡£±ÈÈç¶Ô ......

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö

PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕ߶¼Í³Ò»²ÅÐУ ......

pbÁ¬½ÓmySqlÊý¾Ý¿â

PBÁ¬½ÓMySQLÊý¾Ý¿â
 
È¥mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØodbc connector(http://dev.mysql.com/downloads/connector/odbc/)
ÏÂÔصÄÊÇmysql-connector-odbc-noinstall-5.1.6-win32.zip
½âѹºóÖ±½ÓÔËÐÐÎļþ¼ÐÖÐµÄ Install.bat Åú´¦ÀíÎļþ
mysql-connectorÓкü¸ÖÖ£¬Ñ¡ÔñÒ»¸ö×Ô¼ºÏ²»¶µÄ¼´¿É¡£
ÔÚxpÖдò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......

mysql Êý¾Ýͬ²½

  Êý¾Ýͬ²½ÎÊÌâÖÕÓÚ½â¾ö£º
תÌû£ºA·þÎñÆ÷£º host 192.168.1.101 port 3306 B·þÎñÆ÷£º host 192.168.1.102 port 3306 1,ÊÚȨÓû§£º A·þÎñÆ÷ mysql>grant replication slave,file on *.* to 'repl9'@'192.168.1.102' identified by '1234569'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Qu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ