mysql²»ÄÜ´´½¨´æ´¢¹ý³Ì
DELIMITER $$ DROP PROCEDURE IF EXISTS `shopping`.`pp` $$ CREATE PROCEDURE `shopping`.`pp` () BEGIN END $$ DELIMITER ; ÎÒÏë´´½¨Ê± ÀÏÊDZ¨ÏÂÃæÕâ¸ö´íÎó Script line: 4 Access denied for user 'root'@'%' to database 'shopping'
ûÓÐȨÏÞ´´½¨´æ´¢¹ý³Ì£¬show grants¿´Ò»ÏÂÄãÓÐÄÄЩȨÏÞ¡£ ÈçÂ¥ÉÏÖ¸³ö£¬Ã»ÓÐȨÏÞ¡£ ÄãÐèÒª´ÓÄãµÄMYSQLÊý¾Ý¿â±¾»úÒÔROOTÔٵǼÉÏÈ¥ grant all on *.* to 'root'@'%' ; ÎÒÊÇÒÔÓû§ÃûΪroot ÃÜÂë123µÇ½½øÈ¥µÄ ÔõôÉèÖòÅÄÜ´´½¨´æ´¢¹ý³Ì ÉÏÃæÐÖµÜÄÜ˵¾ßÌåµãÂðÒýÓà ÎÒÊÇÒÔÓû§ÃûΪroot ÃÜÂë123µÇ½½øÈ¥µÄ ¿ÉÊÇÄãÊÇ´ÓÆäËü»úÆ÷ÉϵǼµÄ¡£ÐèÒª´ÓMYSQL±¾»úµÇ¼ȥÊÚȨ¡£ ²»Ã÷°×°¡ »¹ÓÐmysql±¾»ú°¡ ÀÇÐÖ˵µÄÊÇ£¬ÈÃÄãÔÚmysql·þÎñÆ÷µÄ»úÆ÷ÉÏÖ´ÐÐgrant all on *.* to 'root'@'%' ; ¸øËùÓÐÓ÷þÎñÆ÷µÄ»úÆ÷¿ª·ÅȨÏÞ£¬ ÕâÑùÔÚÆäËü»úÆ÷¾Í¿É´´½¨´æ´¢¹ý³ÌÁË ²¹³äÒ»¾ä£¬ÕâôдÐèÒªÖØÆôÏÂmysql ллpurple3196ҲллÀǸ磬¸ã¶¨À²
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿ PHP code: <?php $str="select * from product wh ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......