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 ȨÏÞÓ¦¸Ã×ã¹»ÁË ¿ÉÄÜÊÇÃÜÂëÎÊÌâ
ͬÒâ Ó¦¸ÃÊÇÃÜÂëÎÊÌâ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ°²×°µÄÊÇappserv-win32-2.4.4a.exe×éºÏ°ü£¬ÎÒÔÚmysqlÖд´½¨ÁËÒ»¸ödb_bookÊý¾Ý¿â,²¢ÔÚdb_bookÊý¾Ý¿âÖд´½¨ÁËÒ»¸ötb_book±í£¬ÎÒÏëдһ¸öphp³ÌÐòÏòtb_book±íÖвåÈëÊý¾Ý£¬¿ÉÊdzöÏÖ¡°Ñ¡ÔñÊý¾Ý¿âʧ°Ü£¡¡±µÄÌáʾ£¬²»ÖªÊÇÊ ......
mysql±È½Ï²Ë£¬
×Ö¶ÎÀïÃæÓиö MB ,²»ÊÇÊýÖµÐÍ£¬ÆäËüÓÐЩ¡°Î´Öª¡±£¬Ôõô²ÅÄܵóö×îÖÕÏà¼ÓµÄ½á¹û£¿
SQL code:
mysql> select * from t;
+----------+
| size |
+----------+
| 0.47 MB |
| NU ......
mysql Ôõô±£´æÂ·¾¶ £¿ÀýÈçÏë±£´æC:\Dreamweaver 8\Help µ«ÊDZ£´æÈëÊý¾Ý¿âºó\»á²»¼ûÁË£¬ÇëÎÊÔõô½â¾öÕâ¸öÎÊÌ⣡~~~лл
·¾¶¾¡Á¿²»ÓÃÖÐÎÄÐÅÏ¢
лл~~ûÓÐÖÐÎÄÐÅÏ¢°¡£¬C:\Dreamweaver 8\Help£¬µ«ÊDZ£´æºó\»á²»¼û ......
×î½üÔÚÑо¿Êý¾Ý¿âµÄ°²È«ÎÊÌ⣬·¢ÏÖMYSQLÓкܶలȫ©¶´£¬ÏëÇë½Ì´ó¼Ò£¬ÔÚ¹ÜÀí·½ÃæÈçºÎÀ´·ÀÖ¹°²È«Òþ»¼¡£
ÎÒÁ˽⵽ÓÐ×¢Èë¹¥»÷£¬¸ÃÈçºÎ·ÀÖ¹£¿
»¹ÓйØÓÚÕ˺š¢ÃÜÂëµÄ¹ÜÀí¡¢ÎļþÊôÐÔµÈ
1. ²Ù×÷ϵͳµÄ°²È«£¬ ......