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

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂë¶¼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ºÌṩӲ¼þ+Èí¼þÈ«Ì׵įóÒµ¼¶½â¾ö·½°¸µÄÉÙÊý¹«Ë¾Ö®Ò»ÁË£¬µ±ÄêÊÕ¹ºMySQLµÄʱºò»¹ÊÇ·ç·ç»ð»ð°¡£¬ÍêÉÆÁË×Ô¼º²úÆ·Á´ÖÐ×îºóµÄÈõ»·£¬³É¾ÍÁË¿ªÔ´ÊÀ½ç×î´óµÄÒ»±ÊÊÕ¹º°¸£¬SunÒ²´Ó´ËÓÐÁË´ÓSPARC´¦ÀíÆ÷ £¬´æ´¢É豸µÈÓ²¼þ£¬µ½JAVAÓïÑÔ£¬Solaris²Ù×÷ϵͳ£¬MySQLÊý¾Ý¿âµÈÈí¼þµÄÍ걸²úÆ·Á´£¬Ò»Ê±¼äËÆºõ³ÉΪÁ˳ýIBMÒÔÍ⣬·þÎñÆ÷£¬¹¤×÷Õ¾£¬ÆóÒµ¼¶½â¾ö·½°¸ÖÐ×îÅ£µÄ¹«Ë¾£¬¿Éϧ°¡¿Éϧ¡£¡£¡£¡£¡£ µ±Äê¾­¼ÃÇé¿öºÃµÄʱºò£¬´óÆóÒµºÜHappyµÄÉÕÇ®£¬×ÌÈóÁËSunÕâÑùµÄ¹«Ë¾£¬µ«ÊÇ£¬¾­¼ÃΣ»úÒ»µ½£¬´ó¼ÒÊÕËõÁËÒø¸ù£¬Sun¾Í²»ºÃ¹ýÁË£¬¿ªÔ´µÄJAVAºÍMySQL¶¼²»¿ÉÄÜÕü¾ÈSun¡£ ×î×î¿ÉÁ¯µÄÊÇ£¬½ñÌìSunÏë°Ñ×Ô¼ºÂô¸øOracle£¬µ«ÊÇÈ´ÒòΪMySQLµÄÔ­Òò£¬µ¼ÖÂÔÚÅ·ÃËÕâÀïͨ²»¹ý£¬ÕæÊÇÈÃÈ˸Ð̾°¡¡£¡£¡£¡£¡£¡£ »ù±¾ÉÏ£¬ÕâÒ²¿ÉÒÔ¿´×öÊÇITÀúÊ·ÉÏÁíÒ»ÆðÒòΪӯÀûģʽ̫µ¥Ò»µ¼ÖµĴàÈõ°É£¬ÄÄÅÂÊÇSunÕâÑùµÄ¹«Ë¾£¬·¸ÁË´Ë´í£¬Ò²ÌÓ²»Á˿ɱ¯µÄÃüÔË¡£ µ±Ä꣬˭ÓÖÄÜÏëµ½£¬ÄÇÊÇSun¶ÔMySQLµÄÊÕ¹º°¸»áµ¼ÖÂÏÖÔÚÕâÑùµÄºó¹ûÄØ£¿Ö»Ì¸ÀúÊ·µÄÏ·¾çÐÔ°¡¡£     Ô­´´ÎÄÕÂ×÷Õß±£Áô°æÈ¨ ×ªÔØÇë×¢Ã÷Ô­×÷Õß ²¢¸ø³öÁ´½Ó write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie var sitebro_tracker_atc_kw = {u:'http://www.sitebot.com.cn/754892/',w:'NzU0ODky',bt:'#804000',bg:'#EEEEDD',fs:1,ca:'#770000',bh:'#f4f4c6',cp:'',l:10,s:1,lang:'zh_CN'};


Ïà¹ØÎĵµ£º

Mysql³£ÓÃÃüÁîÐÐ

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

tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃ

ÔÚTOMCAϵÄCatalina\localhostĿ¼µÄ¹¤³Ìxml£¬±àдÈçÏ´úÂ룺
<Context path="/testProject" docBase="E:\project\TestProject\WebContent" reloadable="true"  debug="0" privileged="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name=" ......

ÖÕÓÚÕÒµ½Ò»¸ö¿ÉÒÔ½â¾öMySQLÆô¶¯Ê±1067´íÎóµÄ·½·¨ÁË£¡

°²×°ºóMYSQL5ºó£¬·¢ÏÖÆô¶¯³ö´í.
³ö´í´úÂ룺1067
½â¾ö°ì·¨ÈçÏ£º
ɾ³ý%windows%/my.ini
ɾ³ýÆäËüµØ·½µÄmy.ini
ÔÚmysql°²×°Ä¿Â¼Ï°Ñmy-small.ini¸´ÖÆÎªmy.ini
ÔÚmy.ini×îºóÒ»ÐвåÈ룺
CODE:
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=C:\mysql-5.1.11-beta-win32
datadir=C:\mysql-5.1.11-beta-win32\dat ......

ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö

http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö
MysqlÊÇͨ¹ýyacc½øÐÐSQLÓï¾ä½âÎöµÄ£¬ÕâÀï½éÉÜÒ»ÏÂÈçºÎʹÓÃmysqlµÄÔ´Âë½øÐÐSQLÓï¾ä½âÎö¡£ÓÉÓÚMysqlµÄÔ´´úÂë×¢ÊͱȽÏÉÙ£¬¶øÇÒȱÉÙ×ÊÁÏ£¬ËùÓÐЩµØ·½Ñо¿²»¹»ÉîÈë¡£
1        Filed½éÉÜ
MY ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ