MySqlÊý¾Ý¿âÓû§ÃÜÂëµÄÐÞ¸Ä
»·¾³£º
²Ù×÷ϵͳ£ºWIN2003
MySql£ºmysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)
˼Ï룺
ΪÁË°²È«¼ÓÃÜÐèÒªÉèÖÃmysqlÊý¾Ý¿âÏà¹ØÓû§µÄÃÜÂ룻
MySqlÊý¾Ý¿âµÄÃÜÂ붼ÊDZ£´æÔÚmysqlÊý¾Ý¿âʵÀýµÄuser±íÖеÄpassword×Ö¶ÎÀͨ¹ýPASSWORD("")µÄº¯Êý¶ÔÃÜÂë¼ÓÃܺ󱣴æÔÚ±íÖУ»
ËùÒÔÒªÐÞ¸ÄÓû§µÄÃÜÂëÖ»ÐèÒª¸Ä±äÏàÓ¦µÄ×Ö¶ÎÄÚÈݾͿÉÒÔÁË¡£
×¢Ò⣺
ÎÒÕâÀï·¢ÏÖadminÓû§ÔÚuser±íÖеÄUser×Ö¶ÎΪ¿Õ£¬¶ø²»ÊÇÏòÆäËûÓû§ÄÇÑùÖ±½ÓÏÔʾ³öÀ´µÄ¡£
²½Ö裺
mysql µÄroot¿ÚÁîÒѸüÐÂΪ root£¬adminÃÜÂë¸ü¸ÄΪadmin
1¡¢±à¼ c:\window\my.ini
ÔÚmy.iniÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
3¡¢ÉèÖÃеÄrootÃÜÂë
cd c:\mysql\bin
mysql -u root -p
use mysql
update user set password=PASSWORD("mysql") where user='root';
update user set password=PASSWORD("root") where user='';
(×¢£ºmysqlµÄuser±íÖÐuser=''¼´Îªadmin Óû§)
flush privileges ;
quit Í˳öMySQL
4¡¢»¹ÔÅäÖÃÎļþ²¢ÖØÆô·þÎñ
ɾ³ýmy.iniÖиղÅÌí¼ÓµÄÄÇÐÐ
net stop MySQL
net start MySQL
ÐÞ¸ÄÍê±Ï¡£
Ïà¹ØÎĵµ£º
×÷Õß Ð¡ºÉ||¡¾×ªÔØʱÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¡¿
· ÓÀ¾ÃÁ´½Ó: http://www.oracleblog.cn/useful-script/prompt-of-sqlplus/
misc@ORALOCAL(192.168.0.49)>
Èç¹ûÄãÒ²ÏëºÍÎÒÒ»Ñù£¬ÔÚsqlplusµÇ¼Êý¾Ý¿âµÄʱºò£¬ÄÜÌáʾ²»ÉÙÏñÉÏÃæÕâÑùÏêϸµÇ¼µÄÐÅÏ¢£º
1.µÇ¼µÄÓû§Ãû¡£µ±ÄãµÄÊý¾Ý¿âÖÐÓжà¸ö ......
1¡¢±à¼MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
......
1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
¡¡¡¡MySQL¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÉõÖÁÊ ......
Unixʱ¼ä´Á×îСµ¥Î»ÊÇÃ룬¿ªÊ¼Ê±¼äΪ¸ñÁÖÍþÖαê׼ʱ¼ä1970-01-01 00:00:00
ConvertIntDateTime·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý»ñÈ¡±¾µØʱÇø±íʾUnixk¿ªÊ¼Ê±¼ä£¬¼ÓÉÏUnixʱ¼äÖµ£¨¼´¹ýÈ¥µÄÃëÊý£©.
ConvertDateTimeInt·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý¿Ì¶ÈÊý²î£¬Ôٰѿ̶ÈÊýת»»ÎªÃëÊý£¬µ±È»ÒªËµÃ÷µÄÊÇ£¬ÎÒÕâÀï·µ»ØµÄÊÇdoubleÀàÐÍ£¬ÒâÒåÉϲ¢·ÇÊÇÕæ ......