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

mysqlÐÞ¸ÄÃÜÂëÎÊÌâ

ÎÊÌâÊÇÕâÑùµÄ£¬ÏÖÔÚÓиöÓû§mysql ÃÜÂëΪ¿Õ£¬È»ºóÎÒÏȰÑËü¸Ä³É123£¬ÕâÑùдΪʲô²»ÄܸÄmysqladmin -u mysql password 123£¬½á¹û³öÏÖmysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'¡£´ó¼Ò°ïÎÒ¿´¿´ÎªÊ²Ã´
ÔÚ[root@localhost /]# ÕâÀïÊäÈë  ÄѵÀ»¹ÐèҪʲôȨÏÞÂð

mysqladmin -u root -p oldpassword newpasswd

¿´´íÁË£¬²»ÊÇÖØÖÃ
mysqladmin -u root password "ÃÜÂë"

Â¥É쵀 ÄãÕâÊǸørootÉèÖÃÃÜÂëµÄ£¬µ«ÎÒÏÖÔÚÊÇÒª¸ømysqlÓû§ÉèÖÃÃÜÂëµÄ  ÆäʵԭÀíÒ²¸úÕâ¸öÒ»Ñùmysqladmin -u mysql password 123  µ«¾ÍÊDz»ÐÐ

hello,
mysqladmin   -u   mysql   password   123   µÄÒâ˼ÊÇÒÔmysql   µÄÉí·ÝµÇ¼£¬¸ü¸ÄÃÜÂëÓ¦¸ÃÊÇÒÔrootµÇ¼°É
ÓÃÒÔϵķ½Ê½ÊÔÊÔ¿´
shell>   /usr/local/mysql/bin/mysql   -u   root   -p123456
mysql>   use   mysql
mysql>   update   user   set   password   =   password( '123 ')   where   user   =   'mysql ';



'Access denied; you need the SUPER privilege for this operation'
·ÃÎʽûÖ¹¡£ÄãÐèÒª³¬¼¶È¨ÏÞÀ´Ö´Ðд˲Ù×÷¡£

ËùÒÔ±ØÐëÒÔrootÓû§À´Ö´ÐÐÄãµÄÃüÁî


Ïà¹ØÎÊ´ð£º

javaµ÷ÓÃmysqlÃüÁîµ¼ÈëÊý¾Ý

Java code:

public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......

javaÔõôµ÷ÓÃmysql´´½¨µÄ±í

Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

MySQL±àÂëµÄÎÊÌâ

ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ