Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Á¬½ÓMySQLÊý¾Ý¿âʱ³öÏÖ#1251´íÎóµÄ½â¾ö·½·¨

Á¬½ÓMySQLÊý¾Ý¿âʱ³£»á³öÏÖÈçϵĴíÎóÌáʾ£º
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
³öÏÖÕâÖÖÎÊÌâÊÇÔÚMySQL4.1ÒÔÉϰ汾£¬Ô­ÒòMySQL·þÎñÆ÷°æ±¾Ê¹ÓÃÁËеÄÃÜÂëÑéÖ¤»úÖÆ£¬Æä½â¾ö·½·¨ÈçÏ£º
mysql>;set password for 'Óû§Ãû' @ 'Ö÷»úÃû' = old_password('ÃÜÂë');     ×¢ÒâǰºóµÄ·ÖºÅ


Ïà¹ØÎĵµ£º

mysql¼ÓÃܽâÃܺ¯ÊýAES_ENCRYPTÓëAES_DECRYPT

mysqlϵļÓÃܺ¯ÊýÓÐÈçϼ¸¸ö
PASSWORD()£º´´½¨Ò»¸ö¾­¹ý¼ÓÃܵÄÃÜÂë×Ö·û´®£¬ÊʺÏÓÚ²åÈëµ½MySQLµÄ°²È«Ïµ
ͳ¡£¸Ã¼ÓÃܹý³Ì²»¿ÉÄæ£¬ºÍunixÃÜÂë¼ÓÃܹý³ÌʹÓò»Í¬µÄËã·¨¡£Ö÷ÒªÓÃÓÚMySQLµÄÈÏ֤ϵͳ¡£
 
ENCRYPT(£¬)£ºÊ¹ÓÃUNIX crypt()ϵͳ¼ÓÃÜ×Ö·û´®£¬ENCRYPT()º¯Êý½ÓÊÕÒª¼ÓÃܵÄ×Ö·û´®ºÍ£¨¿ÉÑ¡µÄ£©ÓÃÓÚ¼ÓÃܹý³ÌµÄsalt£¨Ò»¸ ......

SQL Injection with MySQL£¨×ª£©


SQL Injection with MySQL
±¾ÎÄ×÷Õߣºangel
ÎÄÕÂÐÔÖÊ£ºÔ­´´
·¢²¼ÈÕÆÚ£º2004-09-16
±¾ÎÄÒѾ­·¢±íÔÚ¡¶ºÚ¿Í·ÀÏß¡·7Ô¿¯£¬×ªÔØÇë×¢Ã÷¡£ÓÉÓÚдÁ˺ܾã¬Ëæ×ż¼ÊõµÄ½ø²½£¬±¾ÈËÒ²·¢ÏÖ¸ÃÎÄÀïÓв»ÉÙ´íÎóºÍÂÞàµĵط½¡£Çë¸÷λ¸ßÊÖ¿´Á˲»ÒªÐ¦¡£±¾ÎÄдÓÚ¡¶Advanced SQL Injection with MySQL¡·Ö®Ç°Ò»¸öÔ¡£
ÉùÃ÷
¡¡¡¡±¾ÎĽöÓÃÓÚ½ ......

mysql ENGINE=InnoDB

InnoDB ¸ø MySQL ÌṩÁ˾ßÓÐÊÂÎñ(commit)¡¢»Ø¹ö(rollback)ºÍ±ÀÀ£ÐÞ¸´ÄÜÁ¦(crash recovery capabilities)¡¢¶à°æ±¾²¢·¢¿ØÖÆ(multi-versioned concurrency control)µÄÊÂÎñ°²È«(transaction-safe (ACID compliant))ÐÍ±í¡£InnoDB ÌṩÁËÐм¶Ëø(locking on row level)£¬ÌṩÓë Oracle ÀàËÆµÄ²»¼ÓËø¶ÁÈ¡(non-locking read in SELEC ......

MySQL´íÎó_ÖÐÎIJÎÕÕÁбí

1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1011£ºÉ¾³ýÊý¾Ý¿âÎļþʧ°Ü
1012£º²»ÄܶÁȡϵͳ±íÖеļǼ
1020£º¼Ç¼Òѱ»ÆäËûÓû§ÐÞ¸Ä
1021£ºÓ²Å ......

MySQL·þÎñÆ÷Æô¶¯¡¢Í£Ö¹¼°Á¬½ÓÃüÁî

MySQL·þÎñÆ÷Æô¶¯ÃüÁîÈçÏ£ºnet start mysql
MySQL·þÎñÆ÷Í£Ö¹ÃüÁîÈçÏ£ºnet stop mysql
MySQL·þÎñÆ÷µÄÁ¬½ÓÃüÁîÈçÏ£º
·½Ê½Ò»£ºmysql -h Ö÷»úÃû -u Óû§Ãû -p Óû§ÃÜÂë
·½Ê½¶þ£ºmysql --host=Ö÷»úÃû --user=Óû§Ãû --password=Óû§ÃÜÂë
ĬÈϵÄÖ÷»úÊÇ£ºlocalhost ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ