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 front£¬ µ«ÊǸöÈ˾õµÃmysql»¹ÊÇÃüÁîÐÐϱȽϺÃÓ㬱Ͼ¹Êý¾Ý¿âÔÚÃüÁîÐÐϲÙ×÷±È½ÏÍõµÀ¶øÇÒmysqlÍêÈ«Ãâ·Ñ¡£¡£
ÏÂÃæ½éÉÜһЩmysqlÃüÁîÐÐϳ£ÓõÄÃüÁÓÐһЩÊý¾Ý¿â»ù´¡µÄ£¬¼´Ê¹ÊǵÚÒ»´ÎÓÃmysql¶ÔÕÕÏÂÃæµÄÃüÁî²Ù×÷Ò²ÍêÈ«¿ÉÒÔ£¬Èç¹ûÎÒ·¢ÏÖ»¹ÓÐÆäËüÃüÁîÒ²ÊǾ³£Óõ½µÄÎÒ»á½Ðø¸üС£¡£¡£
·þÎñÆ÷£º
1. Æô¶¯m ......
http://hi.baidu.com/xiyouwang/blog/item/9f15bbee99b0ce202df5349e.html
ÏÖÔڵĻ¥ÁªÍøÉÏ£¬ºÜ¶àÍøÕ¾¶¼ÌṩÁËÈ«ÎÄËÑË÷¹¦ÄÜ£¬ä¯ÀÀÕß¿ÉÒÔͨ¹ýÊäÈë¹Ø¼ü×Ö»òÕßÊǶÌÓïÀ´ËÑË÷Ìض¨µÄ×ÊÁÏ¡£ÔÚPHP+MySQL¹¹¼ÜµÄÍøÕ¾ÖУ¬Í¨³£µÄ×ö·¨ÊÇͨ¹ýSELECT²éѯµÄLikeÓï¾äÀ´½øÐÐËÑË÷£¬ÕâÒ»°ì·¨´æÔÚËÑË÷²»¹»¾«È·¡¢ÒÔ¼°Ð§Âʷdz£µÍϵÄȱµã¡£±ÈÈç¶Ô ......
PHP³ÌÐòºÍ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Êý¾ÝÔ´¹ÜÀíÆ÷£¨¿ØÖ ......
Êý¾Ýͬ²½ÎÊÌâÖÕÓÚ½â¾ö£º
תÌû£º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 ......