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£¬¾Í¿ÉÒÔÁË
Ïà¹ØÎĵµ£º
1.²é¿´MySQL·ÖÇø±íµÄÖ´Ðмƻ®:
×¢Òâ:¶ÔMySQL·ÖÇø±í°´·ÖÇø²éѯ,²»ÓÃÏñOracleÄÇÑù,ÔÚSQLÖÐÌí¼Ó“PARTITION”×Ö·û´®¡£
Ìáʾ£ºÊ¹Ó÷ÖÇø¹¦ÄÜÖ®ºó£¬Ïà¹Ø²éѯ×îºÃ¶¼ÓÃEXPLAIN PARTITIONS¹ýÒ»±é£¬È·ÈÏ·ÖÇøÊÇ·ñÉúЧ¡£ÀýÈç:
EXPLAIN PARTITIONS SELECT * from tab_test WHERE created = '2008-01-02';
2.²é¿´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ÏÂÀ´£ ......
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 ......
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µÄÎÄÕ£¬¾õµÃºÜÓÐÓ㬼ÓÒÔ×Ô¼ºµÄÀí½âºÍ±àд£¬¼Ç¼ÏÂÀ´¡£
Ò»¡¢ApacheµÄ°²×°
Apache×÷Ϊһ¸ö¹¦ÄÜÇ¿´óµÄWeb³ÌÐò£¬×ÔÈ»ÊǼܽ¨Web·þÎñÆ÷µÄÊ×Ñ¡£¬ºÃÁË£¬ÏÂÃæÎÒÃǾÍÀ´°²×°Apache¡£ÔÚÖÕ¶ËÏÂÊäÈëÏÂÔÚÃæÃüÁ
sudo apt-get i ......