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Óû§À´Ö´ÐÐÄãµÄÃüÁî
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Java code:
public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......
ÎÒÔÚ°²×°ÂÛ̳µÄʱºò£¬Ð½¨ÁËÒ»¸öMYSQLÓû§£¬È¨ÏÞÊÇALL£¨grant all ¡¡£©£¬ÏÖÔÚÂÛ̳°²×°ºÃÁË£¬ÎÒÏëÈÃÕâ¸öÓû§Ö»ÄܲÙ×÷Ìض¨Êý¾Ý¿â£¨·ÃÎʺÍÐ޸ģ¬°üÀ¨´´½¨É¾³ý±í£¬×îºÃ²»ÄÜɾ³ýÊý¾Ý¿â£¬µ«×ö²»µ½¾ÍËãÁË£©£¬ÀýÈçtestÊý¾Ý ......
ÎÒµÄMySQL±àÂ룬ÎÒÔÚmy.iniÖÐÉèÖõÄΪutf8,ÔÚ´´½¨Êý¾Ý¿âʱѡÔñµÄ±àÂëΪutf8_Unicode_ci£¬ÎÒÔÚ¡¢´ÓÒ³Ãæ²åÈëÊý¾Ý¿â£¬ÔÚÒ³ÃæÉÏÏÔʾÕý³££¬µ«´ÓphpmyadminÖУ¬²é¿´Ê±£¬ÏÔʾΪÂÒÂ루ÎÒÎÒ¡£& ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......