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

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ҲллÀǸ磬¸ã¶¨À²


Ïà¹ØÎÊ´ð£º

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

¹ØÓÚMYSQLµÄinnodb±í±¸·ÝµÄÎÊÌâ

ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý

Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......

mysqlÊý¾Ý¿â - Java / 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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ