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 3.22ºÍÒÔÉϰ汾ÖУ¬Äã¿ÉÒÔʹÓÃSET PASSWORDÓï¾ä£º
shell> mysql -u root mysql
mysql> SET PASSWORD FOR root=PASSWORD('new_password');
ÉèÖÿÚÁîµÄÁíÒ»ÖÖ·½·¨ÊÇʹÓÃmysqladminÃüÁ
shell> mysqladmin -u root password new_password
×¢Ò⣺Èç¹ûÄãʹÓõÚÒ»ÖÖ·½·¨ÔÚuser±íÀïÖ±½Ó¸üпÚÁÄã±ØÐë¸æËß·þÎñÆ÷ÔٴζÁÈëÊÚȨ±í(ÓÃFLUSH PRIVILEGES)£¬ÒòΪ·ñÔò¸Ä±ä½«²»±»×¢Òâµ½¡£
Ò»µ©root¿ÚÁî±»ÉèÖ㬴˺óµ±Äã×÷ΪrootÓë·þÎñÆ÷Á¬½Óʱ£¬Äã±ØÐ빩ӦÄǸö¿ÚÁî¡£
Äã¿ÉÄÜÏ£ÍûÈÃroot¿ÚÁîΪ¿Õ°×ÒԱ㵱ÄãÊ©Ðи½¼ÓµÄ°²×°Ê±£¬Äã²»ÐèÒªÖ¸¶¨Ëü»ò²âÊÔ£¬µ«ÊDZ£Ö¤ÔÚÈκÎÕæÊµµÄÉú²ú¹¤×÷ÖÐʹÓÃÄãµÄ°²×°Ö®Ç°£¬ÉèÖÃËü¡£
Ïà¹ØÎĵµ£º
ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Maste ......
http://javeye.javaeye.com/blog/558093
ÎÒÃÇÖªµÀ£¬group by¿ÉÒÔ½«sql²éѯ½á¹û°´ÕÕgroup byºóÃæÁнøÐзÖÀàÏÔʾ¡£±ÈÈ磺
Sql´úÂë
select
columnA,columnB
from
table
group
by
columnA,columnB
select columnA,columnB from table group by columnA,colum ......
Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......
×î½üÁ˽âÁËÒ»ÏÂMYSQL×¢È룬Ҳʵ¼Ê²Ù×÷ÁËһϣ¬È·Êµ·¢ÏÖÁËËûµÄÍþÁ¦¡£
Ò»¸ö×¢Èë©¶´¿ÉÒÔÈÃÈËÖ±½ÓÄõ½·þÎñÆ÷ȨÏÞ¡£
×ܽáһϣº
1£¬Ä¿Â¼µÄȨÏÞ²»ÄÜÌ«¸ß£¬²»È»±ðÈËÄÜÍùÀïдÎļþ£¬ÒÔǰÓÃ0777ÕæÊÇÌ«ÓÞ´ÀÁË¡£
2£¬Ñϸñ¹ýÂËÊý¾Ý£¬ÕûÐÎÒ»ÂÉתint»òÓÃmysql_escape_string
3£¬ÉèÖúÏÀíµÄÊý¾Ý¿âȨÏÞ£¬²»ÒªÓÃROOT,²»È»»áËÀµÃºÜ²Ò¡£
4 ......