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 code:
public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......
Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = ......
ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......
ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......