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

MySQL 6 ÂÌÉ«¾«¼òBAT°æ

 
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
        MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾«¼ò°æ²âÊÔͨ¹ý,Ö§³ÖÕâЩ¹¦ÄÜ),·Ç³£·½±ã½øÐпª·¢(ÓÈÆäÊÇMyEclipseÉú³ÉÒ»¶Ô¶à,¶à¶Ô¶àµÄ Hibernate/JPAÓ³Éä´úÂë,¾Í¸ü·½±ã¿ì½ÝÁË,ÊÂÎñ¹¦ÄÜÔò¿ÉÒÔ¼ìÑéHibernate»òÕßSpringÕûºÏHibernateʱÊÇ·ñÕýÈ·´¦ÀíÁËÊÂÎñ,Èç¹ûʧ°ÜµÄ»°»áÎÞ·¨ÕæÕý²åÈëÊý¾Ý). °æ±¾ÊÇ: 6.0.5alpha. ΪÁË·½±ã¿ª·¢,°ÑÆô¶¯ºóµÄĬÈϱàÂ뷽ʽÉèÖóÉΪÁËGBK.¿ÉÒÔÅäºÏMySQL-Front»òÕß¿ªÔ´Èí¼þHeidiSQLÀ´¹ÜÀíÊý¾Ý¿â. ¶øÅäºÏÃâ·ÑµÄMySQL¹ÜÀí¹¤¾ß µ¼º½Ã¨Ãâ·Ñ°æ(Navicat Lite),¿É»ñµÃ²»µÍÓÚSQL ServerµÄÒ×ÓöÈ, ÀýÈç¿ÉÊÓ»¯½¨±í, Ð޸ıí½á¹¹, ´´½¨Íâ¼ü, ÐÞ¸ÄÊý¾Ý, Ö´ÐвéѯµÈ¹¦ÄÜ,´ËÈí¼þµÄÖÐÎÄ°æ¿ÉÒÔÔÚhttp://www.navicat.com.cn/download.html ÏÂÔØ:*
Navicat for MySQL ¼òÌåÖÐÎÄ
(Windows°æ)
*·ÇÉÌҵʹÓà8.0.27 7.7 MB  
µØÖ·1 http://www.navicat.com/download/navicat8lite_mysql_cs.exe 
MySQL 6 ÂÌÉ«°æʹÓÃÅú´¦Àí(BAT)ÏÂÔصØÖ·
http://dl3.csdn.net/fd.php?i=55495248124426&s=20bda884a80d085e0dc9eb9ba37d2820
MySQL 6 ÂÌÉ«°æʹÓÃÅú´¦Àí(BAT)ÏÂÔصØÖ·ÎļþÖ´ÐÐ,¿ÉÒÔËæÒâÆô¶¯Í£Ö¹,ʹÓ÷dz£·½±ã,Ò²ºÜÈÝÒ××÷Ϊ¿ª·¢ÑÝʾ»òÕß×÷Ϊ×îÖÕ²úÆ·µÄÒ»²¿·Ö·¢²¼.
    ʹÓÃ: ÏÂÔغó½âѹËõµ½´ÅÅÌÉϵÄÈÎÒâĿ¼, ¿ÉÒÔ¿´µ½¶à³öÁËÒ»¸ö mysql6green µÄĿ¼. ´ò¿ªÕâ¸öĿ¼, ÓÐÒÔϵļ¸¸öÎļþ:Îļþ ËµÃ÷
[bin]  MySQL µÄ¶þ½øÖÆÎļþ
[data] MySQL Êý¾Ý¿âÎļþ
[share] MySQL Ó¢ÎÄ×ÊÔ´Îļþ
mysql_start.bat Æô¶¯ MySQL, Ë«»÷ºóÈç¹ûûÓдíÎóµÄ»°¿ÉÒÔÔÚϵͳ½ø³ÌÖп´µ½ mysqld-nt.exe, ²¢ÇÒ¿ÉÒÔͨ¹ý mysql ¹ÜÀí¹¤¾ßÁ¬½ÓÉÏ, ¶Ë¿Ú 3306, Óû§Ãû root, ÃÜÂëΪ¿Õ
mysql_stop.bat Í£Ö¹ MySQL
mysqlÂÌÉ«°æ.htm ½éÉÜÎļþ
     Ô­Àí: Ê×ÏÈÖ»±£ÁôÁË MySQL µÄ×îÉÙÔËÐÐÎļþÀ´¼õÉÙËùÕ¼ÓõĿռä. µ±È»Èç¹ûÄãÔ¸ÒâµÄ»°ÁôÏÂËùÓÐµÄ Mysql 6 ³ÌÐòÎļþҲûÓÐÎÊÌâ. È»ºó¸ù¾Ý mysqladmin.exe ºÍ mysqld-nt.exe µÄÃüÁîÐвÎÊý½øÐй¤×÷. mysqld-nt.exe --verbose --help ¿ÉÒÔ¿´µ½ËùÓÐÄܹ»Ê¹ÓõIJÎÊý.
mysq


Ïà¹ØÎĵµ£º

mysqlÔ¶³ÌȨÏÞÉèÖÃ

 1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
   ²é¿´½á¹û£¬Ö´ÐУº
   use mysql;
   select host,user,p ......

MySQL²éѯµÄÐÔÄÜÓÅ»¯

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½ÓÉ¿Í»§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

MYSQLÏÔʾÃüÁî

 1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐкÃ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áÄ°Éú°É
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±í ......

Mysql½ø»¯ÂÛ2


MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ