ÔÚLinuxÏ£¬°²×°Mysql£¨tar£©
# cd /home/tmp (½øÈëѹËõ°üËùÔÚĿ¼)
# groupadd mysql (½¨Á¢mysql×é)
# useradd -g mysql mysql (ÔÚmysql×éÖн¨Á¢mysqlÓû§)
# tar -zxvf mysql-5.0.37.tar.gz (½âѹmysqlÔ´Âë,bz2ѹËõ°üÇëÓÓtar -jvxf ÎļþÃû”Ö¸Áî)
# cd mysql-5.0.37 (½øÈë½âѹĿ¼)
# ./configure --prefix=/usr/local/mysql (prefix²ÎÊýÖ¸Ã÷mysql°²×°Ä¿Â¼)
# make
# make install
# /usr/local/mysql/bin/mysql_install_db --user=mysql
# cp support-files/my-medium.cnf /etc/my.cnf (¸´ÖÆmysqlÅäÖÃÎĵµµ½/etcĿ¼)
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld
# cd /usr/local/mysql (½øÈëmysql°²×°Ä¿Â¼)
# chown -R root . (²»ÒªÂ©Á˺óÃæµÄ“.”)
# chown -R mysql var
# chgrp -R mysql . (²»ÒªÂ©Á˺óÃæµÄ“.”)
# /usr/local/mysql/bin/mysqld_safe --user=mysql & (Æô¶¯mysql£¬³öÏÖmysqld endedʱµã»÷»Ø³µ£¬»Øµ½ÃüÁîÐÐ)
# bin/mysql -u root -p (µÇ½mysql£¬Ä¿Ç°ÃÜÂëΪ¿Õ)
mysql> selcet version(); (²é¿´mysqlµÄ°æ±¾ºÅ)
mysql> quit; (Í˳ömysql)
Ïà¹ØÎĵµ£º
2009 Äê 4 ÔÂ 23 ÈÕ
±¾ÎÄÖÐÎÒÃÇÕë¶Ô Linux É϶àÏ̱߳à³ÌµÄÖ÷ÒªÌØÐÔ×ܽá³ö 5 Ìõ¾Ñ飬ÓÃÒÔ¸ÄÉÆ Linux ¶àÏ̱߳à³ÌµÄÏ°¹ßºÍ±ÜÃâÆäÖеĿª·¢ÏÝÚå¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃÇ´©²åһЩ Windows µÄ±à³ÌÓÃÀýÓÃÒÔ¶Ô±È Linux ÌØÐÔ£¬ÒÔ¼ÓÉî¶ÁÕßÓ¡Ïó¡£
±³¾°
Linux ƽ̨ÉϵĶàÏ̳߳ÌÐò¿ª·¢Ïà¶ÔÓ¦ÆäËûƽ̨£¨±ÈÈç Windows£©µÄ¶àÏß³Ì API ÓÐһЩϸ΢ ......
×÷Õß:Error À´×Ô:http://www.zoesan.com
ÔÚInternetÉÏFTP£¨File Transfer Protocol£¬Îļþ´«ÊäÐÒ飩°çÑÝ×ÅÊ®·ÖÖØÒªµÄ½ÇÉ«¡£ÎÒÃÇ¿ÉÒÔͨ¹ýFTPÓëÔ¶³Ì»úÆ÷´«Êä½»»»ÎļþÊý¾Ý£¬ÏÂÔØ»òÉÏ´«×îеÄÈí¼þ¡£»ù±¾µÄFTP·þÎñÆ÷¸ù¾Ý·þÎñµÄ¶ÔÏó¿ÉÒÔ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊÇUnix£¨µ±È»Ò²°üÀ¨Linux£©ÏµÍ³»ù±¾µÄFTP·þÎñÆ÷£¬Ê¹ÓÃÕßÊÇ·þÎñÆ÷ÉϺϷ¨µÄÓû§ ......
http://www.oklinux.cn/html/sql/other/20080317/49465.html
1.ÓÃoracleÓû§µÇ¼
Èç¹ûÒªÔٴΰ²×°£¬ ×îºÃÏÈ×öһЩ±¸·Ý¹¤×÷¡£°üÀ¨Óû§µÄµÇ¼½Å±¾£¬Êý¾Ý¿â×Ô¶¯Æô¶¯¹Ø±ÕµÄ½Å±¾£¬ºÍListener×Ô¶¯Æô¶¯µÄ½Å±¾¡£ÒªÊÇÓпÉÄÜÁ¬´´½¨Êý¾Ý¿âµÄ½Å±¾Ò²±£´æÏÂÀ´
2.ʹÓÃSQL*PLUSÍ£Ö¹Êý¾Ý¿â
[oracle@ora920 oracle]$ sqlplus /nolog
SQL&g ......
Centos redhat ,oracle10g,oracle11g¾ùÊÊÓÃ
1. ±àд½Å±¾£º
# vi startoracle.sh
#11gµÄ»°Ö»ÊÇÕâ¸öĿ¼ÓÐËùÇø±ð
ORACLE_HOME=/home/oracle/product/10.2.0/db_1;export ORACLE_HOME
ORACLE_SID=orcl;export ORACLE_SID #ÕâÀïÅäÉÏÄãµÄ±¾µØʾÀýÃû
&nbs ......
ps ax ÃüÁîÏÔʾһ¸öµ±Ç°ÏµÍ³½ø³ÌµÄÁÐ±í£¬¸ÃÁбíÖаüÀ¨ÆäËûÓû§ÓµÓеĽø³Ì¡£ÒªÏÔʾ½ø³ÌÒÔ¼°ËüÃǵÄËùÓÐÕߣ¬Ê¹Óà ps aux ÃüÁî¡£¸ÃÁбíÊÇÒ»¸ö¾²Ì¬ÁÐ±í£»»»Ò»¾ä»°Ëµ£¬ËüÊÇÔÚÄãÆôÓÃÕâÏîÃüÁîʱÕýÔÚÔËÐеĽø³ÌµÄ¿ìÕÕ¡£Èç¹ûÄãÐèÒªÒ»¸öʱ¿Ì¸üеÄÔËÐнø³ÌÁÐ±í£¬Ê¹ÓÃÏÂÃæÃèÊöµÄ top ÃüÁî¡£
ps µÄÊä³ö»áºÜ³¤¡£Òª·ÀÖ¹Ëü¿ìËÙ´ÓÆÁÄ»Öл¬¹ ......