mysqlÁ¬½ÓÎÊÌâ
Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ
ÃÜÂë´íÁ˰ɡ£
¸Õѧmysql,ÕÕ×ÅÊéÉÏѧµÄ£¬ÊéÉÏÓõÄMySQL Control Center,¸Õ°²×°µÄʱºò£¬»¹¿ÉÒÔÁ¬½Ó£¬½ñÌìµã»÷localhostϵÄconnect¾Í³öÏÖÁËÉÏÃæµÄ´íÎó¡£ÃÜÂëÉèÖõÄ1234567890¡£¶øÇÒÔÚcmdÖÐÊäÈëÃÜÂëºó£¬ÃüÁî´°¿Ú×Ô¶¯Ïûʧ
³õѧµÄ»°£¬½¨ÒéÏÈ´ÓÃüÁîÐпªÊ¼¡£Ö±½ÓÓÃMYSQL.exe À´½øÐвÙ×÷¡£
½¨Ò黨15·ÖÖÓ¿´Ò»ÏÂÏÂÃæµÄÕâ¸öMYSQL¹Ù·½½Ì³Ì¡£
http://dev.mysql.com/doc/refman/5.1/zh/tutorial.html
SQL code:
C:\Documents and Settings\zxh>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.34-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
¼ÈÈ»ÊÇroot ȨÏÞÓ¦¸Ã×ã¹»ÁË ¿ÉÄÜÊÇÃÜÂëÎÊÌâ
ͬÒâ Ó¦¸ÃÊÇÃÜÂëÎÊÌâ
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°µÄÊÇappserv-win32-2.4.4a.exe×éºÏ°ü£¬ÎÒÔÚmysqlÖд´½¨ÁËÒ»¸ödb_bookÊý¾Ý¿â,²¢ÔÚdb_bookÊý¾Ý¿âÖд´½¨ÁËÒ»¸ötb_book±í£¬ÎÒÏëдһ¸öphp³ÌÐòÏòtb_book±íÖвåÈëÊý¾Ý£¬¿ÉÊdzöÏÖ¡°Ñ¡ÔñÊý¾Ý¿âʧ°Ü£¡¡±µÄÌáʾ£¬²»ÖªÊÇÊ ......
ÎҼǵÃÔÚmysqlÖÐÓиöload data infile Óï¾ä¿ÉÒÔ°ÑwordÎĵµµÄÄÚÈݰ´Ò»¶¨¸ñʽµ¼ÈëÊý¾Ý¿â£¬ÕâÑùµ¼ÈëµÄÊý¾ÝÀàÐͺÃÏñÖ»ÄÜÊÇÎı¾¸ñʽµÄÊý¾Ý£¬ÇëÎÊÓÐû¸üºÃµÄ·½·¨¿ÉÒÔµ¼ÈëÊý¾Ý¿â¡£
1¡£Èç¹ûÎÒÃÇÒª°ÑÊÔÌâµ¼ÈëÌâ¿â£¬ÄÇà ......
jspÌá½»Ò³±àÂëÊÇUTF-8£¬MYSQL¿âÒ²ÊÇUTF-8,ΪʲôÌá½»ÁËÖÐÎÄ×Ö·ûÔÚÊý¾Ý¿âÀï±ä³ÉÂÒÂëÁËÄØ£¿
ÕâÖÖÎÊÌâÔõô½â¾ö£¿Ð»Ð»
ÁíÍ⣬JSPµ¯³ö¶Ô»°¿ò£¨±ÈÈ絯³ö¡°XXXÉóºËͨ¹ý¡±ÏÂÃæ¸úÈ·¶¨°´Å¥£©ºÍ·µ»ØÉÏÒ»Ò³ÒÔ¼°×ªµ ......
linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔÒò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔÒò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔÒò£¬²» ......
mySql5.1µÄ mysql command line clientÃüÁî´°¿Úÿ´ÎÒ»µãËü,Ëü¾ÍÒ»ÉÁ¶ø¹ý,²»»áÏÔʾÁË.ÕâÊÇʲôÎÊÌâ?
ÔÚÄãµÄWINDOWSÉÏ£¬ÏȰ´ [¿ªÊ¼], È»ºó [ÔËÐÐ] ,ÊäÈë cmd È»ºó»Ø³µ
È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program ......