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> show variables like '%func%';
+-----------------------------------------+-------+
| Variable_name   ......
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 ......
he create user command:
mysql
> CREATE
USER
yy IDENTIFIED
BY
'
123
'
;
yy±íʾÄãÒª½¨Á¢µÄÓû§Ãû£¬ºóÃæµÄ123±íʾÃÜÂë
ÉÏÃæ½¨Á¢µÄÓû§¿ÉÒÔÔÚÈκεط½µÇ½¡£
Èç¹ûÒªÏÞÖÆÔڹ̶¨µØÖ·µÇ½£¬±ÈÈçlocalhost µÇ½£º
mysql
> CREATE
USER
yy@localhost
&n ......
mysqlÃüÁîÐг£ÓÃÃüÁî
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ ......
»·¾³£ºCentOS linux 5.2
ϵͳֻ°²×°VI±à¼Æ÷Ó뿪·¢¹¤¾ß
ÔÚ±à¼MYSQLʱ£º
#./configure --prefix=/usr/local/mysql --with-charset=gb2312 --with-extra-charsets=all
Ö´Ðкó³öÏÖÈçÏ´íÎó£º
checking for tgetent in -ltermcap… no
checking for termcap functions library… config ......