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

windowsÏÂÖØÉèmysqlµÄrootÃÜÂë

  ×î½üÒòΪÍüÁËmysqlµÄrootÃÜÂ룬ÉÏÍøGoogleһϣ¬ÏÖÔڰѲ½Öè¼Çһϣ¬·ÀÖ¹ÒÔºóÍüÁË¡£
ÎÒÓõÄÊÇxamppÈí¼þ°ü¡£
1.  Í£Ö¹mysql
2.  ´ò¿ªcmd£¬Çл»Ä¿Â¼µ½ \xampp\mysql\bin, ÔËÐÐ
   mysqld -skip-grant-tables
   ÕâÌõÃüÁîÊÇÌø¹ýȨÏÞ¼ì²éÆô¶¯mysql·þÎñ
3. ´ò¿ªÁíÒ»¸öcmd£¬Í¬ÑùÇл»Ä¿Â¼µ½ \xampp\mysql\bin£¬ÔËÐÐ
    mysql –u root
    ÓÃrootµÇ¼µ½Êý¾Ý¿â
4. ÐÞ¸ÄrootµÄÃÜÂë
    >use mysql
    >update user set password=password(’ÐÂÃÜÂë’) where user=’root’
    >flush privileges
5. ¹Ø±ÕËùÓеÄcmd£¬È»ºóÕý³£Æô¶¯mysql£¬¾Í¿ÉÒÔÁË


Ïà¹ØÎĵµ£º

²é¿´MySQLµÄÖ´Ðмƻ®

1.²é¿´MySQL·ÖÇø±íµÄÖ´Ðмƻ®:
×¢Òâ:¶ÔMySQL·ÖÇø±í°´·ÖÇø²éѯ,²»ÓÃÏñOracleÄÇÑù,ÔÚSQLÖÐÌí¼Ó“PARTITION”×Ö·û´®¡£
Ìáʾ£ºÊ¹Ó÷ÖÇø¹¦ÄÜÖ®ºó£¬Ïà¹Ø²éѯ×îºÃ¶¼ÓÃEXPLAIN PARTITIONS¹ýÒ»±é£¬È·ÈÏ·ÖÇøÊÇ·ñÉúЧ¡£ÀýÈç:
EXPLAIN PARTITIONS SELECT * from tab_test WHERE created = '2008-01-02';
2.²é¿´MySQLÆÕͨ± ......

mysql Âý²éѯ²éѯºÍÒýÆðÔ­Òò·ÖÎö

MySQLÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬ÒªÐÞ¸Ämy.cnf»òÕßÔÚMySQLÆô¶¯µÄʱºò¼ÓÈëһЩ²ÎÊý¡£
Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 1
log-slow-queries =
log-queries-not-using-indexes
long_query_time ÊÇÖ¸Ö´Ðг¬¹ý¶à¾ÃµÄsql»á±»logÏÂÀ´£ ......

ASP.NET ²Ù×÷MySQLÊý¾Ý¿âµÄ·½·¨ËµÃ÷

using System;
using System.Data;
using System.Diagnostics;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
namespace System
{
 /// <summary>
 /// Description of MySqlDBUtil.
 /// </summary>
 public class MySqlDBUtil
 {
  &nbs ......

linuxϽâ¾ömysqlµÄ×Ö·û±àÂëÎÊÌâ

http://hi.baidu.com/emersonm/blog/item/ee230a36ca566fd7a2cc2b4a.html
linuxϽâ¾ömysqlµÄ×Ö·û±àÂëÎÊÌâ
2009-10-06 21:03
mysqlµÄ×Ö·û±àÂëÊDZȷ±ËöµÄÊÂÇ飬ÎÒÓõÄfedora11ĬÈϰ²×°mysql5.1
$mysql --user=root --password=²¼À­²¼À­²¼À­
½øÈëºó
mysql>show variables like 'character%';     ......

ubuntuÏÂÅäÖÃApache+Mysql+PHP

½ñÌì¿´µ½Ò»Æª¹ØÓÚubuntuÏÂÅäÖÃApache+Mysql+PHPµÄÎÄÕ£¬¾õµÃºÜÓÐÓ㬼ÓÒÔ×Ô¼ºµÄÀí½âºÍ±àд£¬¼Ç¼ÏÂÀ´¡£
Ò»¡¢ApacheµÄ°²×° 
 
Apache×÷Ϊһ¸ö¹¦ÄÜÇ¿´óµÄWeb³ÌÐò£¬×ÔÈ»ÊǼܽ¨Web·þÎñÆ÷µÄÊ×Ñ¡£¬ºÃÁË£¬ÏÂÃæÎÒÃǾÍÀ´°²×°Apache¡£ÔÚÖÕ¶ËÏÂÊäÈëÏÂÔÚÃæÃüÁ 
    sudo apt-get i ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ