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

linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ

zz linux yum°²×°mysqlºóҪעÒâµÄһЩ³õʼ»¯ÎÊÌâ
ÎҵķþÎñÆ÷×°µÄÊÇcentos 5.3,ÓÉÓÚ×ʼ°²×°×öÁËÏêϸµÄ¼Ç¼,ËùÒÔÕû¸ö¹ý³ÌÒ²ÊÇÇá³µÊì·,һ·yumÏÂÀ´£¬¾Í¸ã¶¨ÁË£¬È»ºó¾ÍÊÇÊý¾Ý¿â¡¢ÍøÕ¾µÄ°á¼Ò£¬ÇáËɸ㶨~
¿ÉÊǽñÌìÔÚ¼Ò¿´ÁËϹ«Ë¾µÄÍøÕ¾£¬ÎÊÌâ³öÀ´ÁË~ ÓÐЩ²úÆ·µã»÷²é¿´ÏêϸÐÅÏ¢µÄʱºò£¬ÕÒ²»µ½ÍøÒ³~¾­¹ýÒ»·¬Ë¼¿¼£¬·¢ÏÖÊÇmysqlĬÈÏ×Ö·û¼¯µÄÎÊÌ⣬°ÑÔ­À´·þÎñÆ÷ÉϵÄmy.cnfÒ»¿´£¬»¹¹ûÕæÊÇ~~ÔÎÁË~~~
ÏÂÃæÐ´³ömysql×°ÍêºóÐèҪעÒâµÄһЩ³õʼ»¯ÉèÖÃ~
 1. ÅäÖÿª»úÆô¶¯·þÎñ
  /sbin/chkconfig httpd on             [ÉèÖÃapache·þÎñÆ÷httpd·þÎñ¿ª»úÆô¶¯]
  /sbin/chkconfig –add mysqld         [ÔÚ·þÎñÇåµ¥ÖÐÌí¼Ómysql·þÎñ]
  /sbin/chkconfig mysqld on             [ÉèÖÃmysql·þÎñ¿ª»úÆô¶¯]
  /sbin/service httpd start            [Æô¶¯httpd·þÎñ,Ó뿪»úÆô¶¯ÎÞ¹Ø]
  /sbin/service mysqld start           [Æô¶¯mysql·þÎñ,Ó뿪»úÎÞ¹Ø]
2. ÉèÖÃmysqlÊý¾Ý¿ârootÕʺÅÃÜÂ롣ĬÈϵijõʼ»¯ÃÜÂëΪ¿Õ~~~
mysqladmin -u root password ‘new-password’           [ÒýºÅÄÚÌîÃÜÂë]
3. ÈÃmysqlÊý¾Ý¿â¸ü°²È«
mysql -u root -p
mysql> DROP DATABASE test;                            [ɾ³ýtestÊý¾Ý¿â]
mysql> DELETE from mysql.user WHERE user = ”;        [ɾ³ýÄäÃûÕÊ»§]
mysql> FLUSH PRIVILEGES;                              [ÖØÔØÈ¨ÏÞ]
4.°²×°ÉÏmysqlÀ©Õ¹
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql
5.ÉèÖÃĬÈϱàÂëµÈһЩ³õʼ²ÎÊý£¨my.cnf£©
vi /etc/my.cnf
[mysqld]
da


Ïà¹ØÎĵµ£º

linuxÎļþ /etc/services Ïà¹Ø

/etc/services
InternetÍøÂç·þÎñÎļþ£¬¼ÇÂ¼ÍøÂç·þÎñÃûºÍËüÃǶÔӦʹÓõĶ˿ںż°Ð­Òé¡£ÎļþÖеÄÿһÐжÔÓ¦Ò»ÖÖ·þÎñ£¬ËüÓÉ4¸ö×Ö¶Î×é³É£¬ÖмäÓÃTAB»ò¿Õ¸ñ·Ö¸ô£¬·Ö±ð±íʾ“·þÎñÃû³Æ”¡¢“ʹÓö˿ڔ¡¢“ЭÒéÃû³Æ”ÒÔ¼°“±ðÃû”¡£ÏÂÃæÊÇÕâ¸öÎļþµÄ½ÚÑ¡ÄÚÈÝ¡£
tcpmux 1/tcp ......

¼¤¶¯ÖÐ~Äõ½ÁËUBUNTU¼ÄÀ´µÄLINUX¹âÅÌ£¡

¼¤¶¯°¡£¬½ñÌìÏÂÎç·ÅѧÀíÍê·¢»ØÀ´ÎÒ°Ö¸æËßÎÒ˵¼ÄÀ´Ñù¶«Î÷£¬»¹ÊÇ´Ó¹úÍâ¼ÄÀ´µÄ£¡ÕâÊÇÎÒµÚÒ»´Î´Ó¹úÍâ±ðÈ˸øÎҼĶ«Î÷¡£·Ï»°²»¶à˵£¬ÉÏͼ²ÅÊÇÍõµÀ¡£ÓÉÓÚÅÄÉãÌõ¼þ¹ýÓÚ¼òª£¨ÁªÏëI398ÊÖ»ú+ÊÖµçͲ£©£¬Óе㱭¾ßÁË¡£
°ü¹üÕýÃæµÄÍâ°ü×°
°ü¹ü±³Ã棨Ϊ·ÀÖ¹¸öÈËÐÅϢй¶ÄÃÅçÆáºÍгÁËһϣ©
°ü¹ü×îÉÏÃæ£¬ÓÉÓÚÓ¢ÓïˮƽÓÐÏÞÿ̫¿´¶®ÊÇÊ²Ã´Ò ......

MySql ´æ´¢¹ý³ÌʹÓÃÓαêÑ­»·²åÈëÊý¾ÝʾÀý

±¾Ê¾Àýͨ¹ý while...end while Ñ­»·¿ØÖÆÓαêÀ´ÊµÏÖ²åÈë±í¼Ç¼¡£
DROP PROCEDURE IF exists pro_initCategoryForTradingEntity;
create procedure pro_initCategoryForTradingEntity(tradingEntityId int)
begin
    declare f_parent,entityId  int;
    declare b int default 0; ......

MyEclipse+Tomcat+MySQLµÄ»·¾³´î½¨£¨2010Äê3ÔÂ5ÈÕ)

Ò». ÉèÖò½Ö裺1¡¢ÓÒ¼üµã»÷ÎҵĵçÄÔ£¬Ñ¡ÔñÊôÐÔ£¨¼ûͼ-1£©      
1¡¢µã»÷¸ß¼¶£¬ÔÚ¶Ô»°¿òµÄϲ¿µã»÷»·¾³±äÁ¿
 3¡¢ÔÚϵͳ±äÁ¿¶Ô»°¿òÖУ¬µã»÷н¨½øÐÐÉèÖÃ.
±äÁ¿Ãû£ºJAVA_HOME
±äÁ¿Öµ£ºC:\Program Files\Java\jdk1.6.0_05£¨ÔÚ´ËʹÓõÄÊÇĬÈϰ²×°Â·¾¶£©
ϵͳ±äÁ¿->±à¼­->±ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ