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

mysql֨װÎÊÌâ½â¾ö·½°¸

mysqlfrontÁ¬½Óʱ³öÏÖ“³ÌÐò×¢²áʱ¼äµ½ÆÚÁË£¬³ÌÐò½«±»ÏÞÖÆÔÚµ­Ä£Ê½ÏÂÔËÐДÕâ¸öÎÊÌâʱ£¬²»ÓÃ֨װ£¬Ö»ÐèÔÚMysql Front µÄ°ïÖú²Ëµ¥ÏîµÄµÇ¼ÇÀïÊäÈëÒÔÏÂMysql FrontµÄ×¢²áÂë¼´¿É¡£
MysqlFront×¢²áÂëÈçÏ£º
0hjwKUddagvS41S9TIb8EwuiXwo4+dlr
t8z9sq/YRlP9e0zTx7jVlriD8bWlwoJM
TRlllybJ0+wce5rRZGaMBnWJH5H0/Pwv
mUPx27SCgyNM1zkDOo5Mj8qnpR9195QN
yv4Fsr4lVYLx5qWHxqpILfqw7PgE3piH
fXEnZ5GprnXuKAanAsmx6omli+kXkHBq
/fT5B62tSXIZQ3euMYCzclaYW47MpKhR
3BUTBoHFzhiGXM5R0ApItyPkgDKnaOlV
ocvgFY3JOeHAP1KF6/mufA==
ÎÒ°Ñ£º
D:\Program Files\MySQL
ɾ³ýÁË¡£×¢²á±íÀïËùÓеÄMySQLÏî¶¼Çå³ýÁË¡£ÖØÆôºó£¬»¹ÊÇûÓа취½â¾ö¡£MySQLÊǸöÁ÷Ã¥Èí¼þ£¬ËüÔÚϵͳµÄÆäËüµØ·½Ð´Á˺ܶàÊý¾Ý¡£¹âÔÚProgram FilesºÍ×¢²á±íÀïÊÇûÓа취³¹µ×ɾ³ýÁË¡£
ºóÀ´£¬ÎÒ×Ô¼º½â¾öÁË¡£ÉèÖÃÏòµ¼Ç°£¬ÏÈÔÚÏòµ¼Àïɾ³ýʵÀý¡£ÈçÏÂͼ¡£
 
£¨ÏÈÔÚ¿ØÖÆÃæ°åÀïɾ³ýMySQL³ÌÐò£¬ÔÙɾ³ýProgram FilesµÄMySQLÎļþ¼Ð¡££©


Ïà¹ØÎĵµ£º

ÓÉMYSQL×¢Èë×ܽá³öÀ´µÄ¡£

×î½üÁ˽âÁËÒ»ÏÂMYSQL×¢È룬Ҳʵ¼Ê²Ù×÷ÁËһϣ¬È·Êµ·¢ÏÖÁËËûµÄÍþÁ¦¡£
Ò»¸ö×¢Èë©¶´¿ÉÒÔÈÃÈËÖ±½ÓÄõ½·þÎñÆ÷ȨÏÞ¡£
×ܽáһϣº
1£¬Ä¿Â¼µÄȨÏÞ²»ÄÜÌ«¸ß£¬²»È»±ðÈËÄÜÍùÀïдÎļþ£¬ÒÔǰÓÃ0777ÕæÊÇÌ«ÓÞ´ÀÁË¡£
2£¬Ñϸñ¹ýÂËÊý¾Ý£¬ÕûÐÎÒ»ÂÉתint»òÓÃmysql_escape_string
3£¬ÉèÖúÏÀíµÄÊý¾Ý¿âȨÏÞ£¬²»ÒªÓÃROOT,²»È»»áËÀµÃºÜ²Ò¡£
4 ......

MSSQL ʵÏÖ MySQL µÄ limit ²éѯ·½Ê½

MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖÆ½á¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
    ......

MySQLµÄÃÜÂëÉèÖÃ

http://www.3d308.cn/article.asp?id=37
shell> mysql -u root mysql
mysql> Update user SET Password=PASSWORD('new_password')
           Where user='root';
mysql> FLUSH PRIVILEGES; ......

ÐÞ¸ÄMySQLÊý¾Ý¿âµÇ½ÃÜÂëµÄ·½·¨

   MySQLĬÈÏûÓÐÃÜÂ룬°²×°Íê±ÏÔö¼ÓÃÜÂëµÄÖØÒªÐÔÊDz»ÑÔ¶øÓ÷µÄ¡£
£¨1£©ÃüÁî
       /usr/bin/mysqladmin -u root –p ‘old-password’ password 'new-password'
       ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ