Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Èí¼þ°²×°¼°Ð¶ÔØ

²éѯÈí¼þÍêÕûÃû³Æ
¸ñʽ£ºrpm -qa ²¿·ÖÎļþÃû
ÀýÈ磺shell>rpm -qa firefox
firefox-3.0.5-l.e15.centos
»áÁгö»ðºüä¯ÀÀÆ÷µÄÈ«³Æ¡£Ò»°ã°²×°°ü¶¼»á°üº¬°æ±¾ºÅ¡£
²éѯÈí¼þ°²×°Ä¿Â¼
¸ñʽ£ºrpm -ql ÍêÕûÈí¼þÃû
ÀýÈ磺rpm -ql firefox-3.0.5-l.e15.centos
°²×°rpm°ü
¸ñʽ£ºrpm -ivh Èí¼þ°ü
ÀýÈ磺rpm -ivh firefox-3 ......

Linuxϳ£¼ûÎļþ¸ñʽµÄѹËõ¡¢½âѹС½á

  
´óÖÂ×ܽáÁËÒ»ÏÂlinuxϸ÷ÖÖ¸ñʽµÄѹËõ°üµÄѹËõ¡¢½âѹ·½·¨¡£µ«ÊDz¿·Ö·½·¨ÎÒûÓÐÓõ½£¬Ò²¾Í²»È«£¬Ï£Íû´ó¼Ò°ïÎÒ²¹³ä£¬ÎÒÃǽ«ËæÊ±ÐÞ¸ÄÍêÉÆ£¬Ð»Ð»£¡
¡¡¡¡.tar
¡¡¡¡½â°ü£º tar xvf FileName.tar
¡¡¡¡´ò°ü£ºtar cvf FileName.tar DirName
¡¡¡¡£¨×¢£ºtarÊÇ´ò°ü£¬²»ÊÇѹËõ£¡£©
¡¡¡¡---------------------------- ......

֨װwindowsºó»Ö¸´linuxÒýµ¼

ǰ¼¸Ìì֨װÁËwindowsϵͳ£¬µ¼ÖÂÒÔǰ°²×°µÄLinux½ø²»È¥ÁË£¬ÎÞ·¨½øÈëLinux£¬Óò»ÏëÖØÐ°²×°Linux£¬ÄÇÑùÌ«·ÑÊÂÁË£¬ÔÚÍøÉÏËÑË÷ÁËһϣ¬ÕÒµ½»Ö¸´LinuxÒýµ¼µÄ·½·¨£¬¾­ÊµÑ飬֨ÐÂÒýµ¼½øÈëÔ­À´µÄLinuxϵͳ£¬Ôڴ˼òµ¥¼Ç¼һÏ£º
  Ê×ÏÈ£¬ÏÂÔØÒ»¸öGrub4dos£¬½âѹµ½CÅ̸ùĿ¼Ï£¬°ÑÀïÃæµÄgrldr¸´ÖƵ½¸ùĿ¼Ï£¬ÐÞ¸Äboot.iniÎļþ£ ......

¾­µäMYSQLÓï¾ä

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡ ......

ÔÚWebLogic 9ÖÐÅäÖÃMySqlµÄÊý¾ÝÔ´

µÚÒ»²½£¬ÏÂÔØMysqlµÄJDBCÇý¶¯³ÌÐò£¬ÃûΪconnectorJ¡£ÏÂÔØÍøÖ·£ºhttp://dev.mysql.com/downloads/connector/j/
½âѹËõzipÎļþºó£¬½«Îļþmysql-connector-java-5.1.12-bin.jarµ½Ä¿Â¼d:\Software\MySQL\MySQL Server 5.1\jdbcdriver\ÖÐ
µÚ¶þ²½£¬ÐÞ¸ÄÎļþd:\Software\bea\WebLogic 9.23\user_projects\domains\MyDomain\bin\s ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ