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ҲллÀǸ磬¸ã¶¨À²
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏ ֱ½ÓÓÃMYSQLDUMP±¸·Ý OR ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£ http://dev.mysql.com/doc/re ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
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 ......