¼±`MYSQLÃÜÂëÈçºÎ¸Ä³É¿Õѽ`
¾ÍÊDz»ÉèÖÃÃÜÂë``
ÒÔÏÂÊÇÎҸղŸÄÃÜÂëµÄÃüÁî``Ô±¾ÃÜÂëÊÇrootµÄ``ºóÀ´Ïë¸ÄΪ¿Õ``
ÓÃmysqladmin¸Ä`µÚÒ»ÌõÊDz»Ð´ÃÜÂë`µ«ÊǺÃÏóûÓиijɹ¦
µÚ¶þÌøÊÇдÁ˸ö¡®¡¯ ´òÔÚÉÏÃæÓÖ±ä³É ''
SQL code:
C:\Documents and Settings\Administrator>mysqladmin -u root -p password
Enter password: ****
mysqladmin: Too few arguments to change password
C:\Documents and Settings\Administrator>mysqladmin -u root -p password ''
Enter password: ****
Warning: single quotes were not trimmed from the password by your command
line client, as you might have expected.
²»»á£¬°ï¶¥
Â¥Éϵķ½·¨ÊÔÊÔ£¬Ã»Óмû¹ýÕâÖÖ²Ù×÷
²»»á,°ï¶¥,Ò²²»Ã÷°×LZΪɶҪÉèΪ¿Õ,´¿´âÑо¿Ò»ÏÂ?
ÔÚmysql°²×°Ä¿Â¼Óиömy.iniÎļþ£¬ÀïÃæ¿ÉÒÔÐ޸쬻¹ÓоÍÊÇÓÃSQLÓï¾ä£¬È»ºómysql config¿ÉÒÔÐÞ¸Ä
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY '' WITH GRANT OPTION;
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......