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
Ïà¹ØÎĵµ£º
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 ......
²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½ÓÉ¿Í»§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......
1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔÒò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í¡£
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐкÃ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» £¯£¯´ò¿ª¿â£¬Ñ§¹ýFOXBASEµÄÒ»¶¨²»»áÄ°Éú°É
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£º
describe ±í ......
MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql ......