Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ҲллÀǸ磬¸ã¶¨À²


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

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

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

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

´Ómysql¶ÁͼƬ·¾¶µ«ÊÇÎÞ·¨ÏÔʾ

´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:

<?php
$str="select * from product wh ......

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ºÅ