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£Ö¤ÔÚÈκÎÕæʵµÄÉú²ú¹¤×÷ÖÐʹÓÃÄãµÄ°²×°Ö®Ç°£¬ÉèÖÃËü¡£
Ïà¹ØÎĵµ£º
***function(/*³£Óú¯Êý*/)***
----ͳ¼Æº¯Êý----
AVG --Çóƽ¾ùÖµ
COUNT --ͳ¼ÆÊýÄ¿
MAX --Çó×î´óÖµ
MIN --Çó×îСֵ
SUM --ÇóºÍ
--AVG
use pangu
select avg(e_wage) as dept_avgWage
from employee
group by dept_id
--M ......
MySqlÊý¾Ý¿âµ¼³öcsvÎļþÃüÁ
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csvÎļþЧ¹û£º
sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
S ......
ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡£
......
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......
Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆΪmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......