MySql ÔõôÔÚÊý¾Ý¿â°²×°µÄʱºò¾Í×Ô¶¯Éú³ÉĬÈÏÓû§ÄØ£¿
±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩÓû§µÄ£¬Ö»ÓÐÒ»¸öϵͳĬÈÏÓû§ root@localhost
Èç¹ûÄãÐèÒªÔÚÄã×Ô¼ºµÄ°²×°½Å±¾»ò³ÌÐòÖÐÉèÖá£ÔòÄãÐèÒª create user 'Client'@'%' IDENTIFIED BY '12345'
×¢Òâ£Í£Ù£Ó£Ñ£ÌµÄÓû§Õ˺ÅÓÉ username@hostname ×é³É scott@localhost Óë scott@198.123.21.22 ²»ÊÇͬһ¸öÓû§£¡
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¿ÉÒԲο¼Ò»Ï¹ٷ½ÎĵµÖÐµÄ create user ºÍ
5.7. MySQL·ÃÎÊȨÏÞϵͳ
5.7.1. ȨÏÞϵͳµÄ×÷ÓÃ
5.7.2. ȨÏÞϵͳ¹¤×÷ÔÀí
5.7.3. MySQLÌṩµÄȨÏÞ
5.7.4. ÓëMySQL·þÎñÆ÷Á¬½Ó
5.7.5. ·ÃÎÊ¿ØÖÆ, ½×¶Î1£ºÁ¬½ÓºËʵ
5.7.6. ·ÃÎÊ¿ØÖÆ, ½×¶Î2£ºÇëÇóºËʵ
5.7.7. ȨÏÞ¸ü¸ÄºÎʱÉúЧ
5.7.8. ¾Ü¾ø·ÃÎÊ´íÎóµÄÔÒò
5.7.9. MySQL 4.1ÖеÄÃÜÂë¹þÏ£´¦Àí
5.8. MySQLÓû§ÕË»§¹ÜÀí
5.8.1. MySQLÓû§ÃûºÍÃÜÂë
5.8.2. ÏòMySQLÔö¼ÓÐÂÓû§ÕË»§
5.8.3. ´ÓMySQLɾ³ýÓû§ÕË»§
5.8.4. ÏÞÖÆÕË»§×ÊÔ´
5.8.5. ÉèÖÃÕË»§ÃÜÂë
5.8.6. ʹÄãµÄÃÜÂ밲ȫ
5.8.7. ʹÓð²È«Á¬½Ó
mysqlΪÁ˰²È«£¬ÏÖÔÚÖ»ÓÐÒ»¸öĬÈϰ²×°Õ˺ţ¬ÆäËûµÄÒª×Ô¼º´´½¨
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......