MySQLС¼¼ÇÉ 1
1,Íü¼ÇrootÃÜÂë,Èç¹ûÄÜ»¹ÄܽøÈëmysqlÇÒ»¹ÓÐmysql¿âµÄȨÏÞ,ÄÇô¾ÍÖ±½ÓÖ´ÐÐ update user set password=password(¡®XXX¡¯) where user=¡¯root¡¯ and host=¡¯XX¡¯; flush privileges; ¼´¿É.Èç¹û²»ÄܽøÈëmysql,ÐèÒªÓÐmysqlÆô¶¯µÄȨÏÞ,ÔÚÆô¶¯mysqlµÄʱºò¼ÓÉÏ--skip-grant-tablesÑ¡Ïî,´Ëʱ½øÈëmysqlÎÞÐèÃÜÂë,ÔÙÖØ¸´ÉÏÊö²Ù×÷¼´¿É. 2,Èç¹ûÓÐÄÚ´æ±í,ÓÃÀ´²éѯÓõĿì±í,ÄÇôÐèÒªÆô¶¯µÄʱºò°ÑÊý¾Ýµ¼ÈëÄÚ´æ±í,mysqlÓиöÑ¡Ïî½Ð--init-fileÑ¡ÏîÕâʱºòºÜ¹ÜÓÃ,°ÑÒªÖ´ÐеÄsqlдµÀÎļþÖÐ,È»ºóÆô¶¯¼ÓÉÏinit-file='/path/to/file'¿ÉÒÔдµÀmy.cnfÖÐ,ÕâÑù¾Í²»±ØÃ¿´Î¶¼×Ô¼ºÊÖдÁË.
Ïà¹ØÎĵµ£º
ÏÂÔØmysql-4.1.14-win32.zip½âѹºóµÃµ½mysql-4.1.14-win32Îļþ¼Ð£¬´ò¿ª´ËÎļþ¼ÐÔËÐÐsetup.exeÎļþ£¬Next£¬Custom¡¢Next£¬Change£¬½«Â·¾¶¸ÄΪd:\MySQL\MySQL Server 4.1\£¬OK£¬Next£¬Install£¬Íê³ÉºóÌø³ö´°¿ÚÈçͼ£º
µãÒ»ÏÂCancel£¬ÔÙÖ±µãFinish¡£ÏÖÔÚÌø³öÉèÖÃmysqlµÄ´°¿Ú£¬Èçͼ£º
Next£¬Next£¬Next£¬next£¬Next£¬Èç ......
gNBpPFgyOw9Rwt/ozsnjgM7tJNo2 bhaaAThangemMkaz2tQhq3/f7dZ7 Vj29WeGHjuupj/AhYqymjAuokhYi X1T/fG+q1yR22PdcEP39dxU3ovEo lLLzwIZlQr9oJYwUf5eG4x5e1bMP nfIaIl8reszQPHFNbrxBjCVrBEXL TyBLehxzUpVI672t3LjX8q4ytCRC ezcoZQfMAc0DulJzNREbwlcf0Rco N0zW3ojBUxGsplBBZZPrD7/bPhkM rjtS8Bxym+HeV1TJDTXuiL8QLg== ......
javaÓëmysqlÂÒÂëµÄÎÊÌâ
javaÓëmysqlÂÒÂëµÄÎÊÌâ
¹Ø¼ü×Ö: javaÓëmysqlÂÒÂëµÄÎÊÌâ
½â¾ö·½·¨Ò»:(×îÖØÒªµÄÒ»ÖÖ·½·¨)
Äã¿´ÏÂmy.ini£¬ÓÐÎÞ
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
È»ºó½¨Á¢±íʱ£¬Ò²ÒªÓ㨱ÈÈ磩
DROP TABLE IF ......
Ô´µØÖ·: http://www.pcppc.cn/shujuku/mysql/shujuku_163919.html
ÄúÕýÔÚ¿´µÄMySQL½Ì³ÌÊÇ:MySQLÊý¾Ý¿âѧϰ±Ê¼Ç¡£
¡¡¡¡MySQLÊý¾Ý¿âѧϰ±Ê¼Ç
(ʵÑé»·¾³:Redhat9.0,MySQL3.23.54)
¸ÙÒª£º
Ò»£¬Á¬½ÓMySQL
¶þ£¬MySQL¹ÜÀíÓëÊÚȨ
Èý£¬Êý¾Ý¿â¼òµ¥²Ù×÷
ËÄ, ......
×î½üÊÕµ½·´À¡£¬ºÜ¶à¿Í»§Á¬MySql¶¼ÎÞ·¨ÕýÈ·°²×°¡£ÊÕµ½ÈÎÎñ£¬Òª½«MySql´òµ½²úÆ·ÖУ¬ºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ£¬À¿ª¼Ü
ʽ¸É°É£¬Ã»·¨×Ó¡£
Ñо¿Ò»Õ󣬷¢ÏÖ½«°²×°ºÃµÄMySqlÎļþ¼ÐCopyµ½ÆäËüµçÄÔÉÏ£¬ÔÙ½â¾öºÃÁ½¸öÎÊÌâÓ¦¸Ã¾Í¿ÉÒԺͰ²×°°æÒ»ÑùÕý³£Ê¹Óá£
1.Copyµ½ÁËÆäËüµçÄÔÉϵIJ»Í¬Ä¿Â¼£¬Ó¦¸ ......