mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ÜÀíÔ±Éí·ÝµÇ½ϵͳ¡£
¡¡¡¡2.´ò¿ªcmd-----net start ²é¿´mysqlÊÇ·ñÆô¶¯¡£Æô¶¯µÄ»°¾ÍÍ£Ö¹net stop mysql.
¡¡¡¡3.ÎÒµÄmysql°²×°ÔÚd:\usr\local\mysql4\binÏ¡£
¡¡¡¡4.Ìø¹ýȨÏÞ¼ì²éÆô¶¯mysql.
¡¡¡¡d:\usr\local\mysql4\bin\mysqld-nt --skip-grant-tables
¡¡¡¡5.ÖØÐ´ò¿ªcmd¡£½øµ½d:\usr\local\mysql4\binÏ£º
¡¡¡¡d:\usr\local\mysql4\bin\mysqladmin -uroot flush-privileges password "newpassword"
¡¡¡¡d:\usr\local\mysql4\bin\mysqladmin -u root -p shutdown Õâ¾äÌáʾÄãÖØÐÂÊäÃÜÂë¡£
¡¡¡¡6.ÔÚcmdÀïnet start mysql
¡¡¡¡7.¸ã¶¨ÁË¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......