Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬¾Í¿ÉÒÔÁË


Ïà¹ØÎĵµ£º

asp.netÁ¬½ÓmysqlÊý¾Ý¿â

MysqlµÄconnector/net5.0ÏÂÔØµØÖ·:
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.6.zip/from/pick
°²×°ºÃÒÔºó,
µãÊôÐÔ,È»ºóµã²éÕÒÄ¿±ê,µãÏòÉÏÒ»²ãĿ¼,ÕÒµ½Binaries\.NET 2.0,È»ºó½«Õâ¸öÎļþ¸´ÖƵ½ÄãµÄ¹¤³ÌĿ¼ÏÂ,Ò»°ãÕâÑùµÄDLLÎļþ»á±£´æµ½binĿ¼ÏÂ.
ÔÚ´úÂëÒ³ÀïÊäÈëusing Mysql.Da ......

¡¾Õª×ÔCSDNÂÛ̳¡¿mysqlÃüÁîÐг£ÓÃÃüÁî

mysqlÃüÁîÐг£ÓÃÃüÁî
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ ......

hibernate mysql ²åÈëÖÐÎÄ´íÎó

 Ê¹ÓÃhibernate mysql ²åÈëÖÐÎÄ´íÎó£º
 Ô­ÒòÖ®Ò»ÊÇ£º
  mysql µÄ×Ö·û±àÂëºÍhibernate´«µÝµÄ±àÂë²»Ò»Ñù£¬
  ÀýÈ磺
  mysql ½¨¿âµÄʱºò¿ÉÒÔÉèÖñàÂë:
  CREATE DATABASE db DEFAULT CHARACTER SET utf8;
 hibernate Á¬½ÓmysqlµÄ±àÂ룺
 jdbc:mysql://127.0.0.1:3306/db?useU ......

ÕÒ»Ømysql µÄroot ÃÜÂë

£¨1£©ÒÔubuntuµÄrootÓû§µÇ½
£¨2£©Í£Ö¹MYSQL·þÎñÆ÷£º
        /etc/init.d/mysql stop
£¨3£©Ìø¹ýÊÚȨ±íÖ´ÐÐMYSQL·þÎñÆ÷£º
       mysqld_safe --skip-grant-tables --skip-networking &
 (×¢£º²ÎÊý--skip-grant-tablesÎªÌø¹ýÊÚȨ±í£»--sk ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ