ÔÚ/homeÏ ȥ·¢ÏÖÖ»ÓÐoracleµÄÎļþ ûÓÐmysqlµÄÎļþ
ÔÚlinuxÀï°²×°ÁË oracle mysql ¶¼³É¹¦¡£
ÔÚ/homeÏ ȥ·¢ÏÖÖ»ÓÐoracleµÄÎļþ ûÓÐmysqlµÄÎļþ
ÁíÍâÎÒadduser li£¬ ÄÜÔÚ/homeÏ ·¢ÏÖÓÐliÎļþ¡£
ʲôÔÒòµ¼ÖÂÎÒÖ»ÄÜ¿´¼ûoracle ²»¼ûmysqlÎļþ£¿£¿
mysqlÓû§Ö÷Ŀ¼ where??
ind / -name "mysql" -print
Ö´ÐÐÍêµÃµ½ÏÂÁнá¹û
/var/lib/mysql
/var/log/mysql
££££££££££££££ Õâ2¸öÊÇÎÒÔÚmy.cnfÀïÅäÖõÄdatadir log-bin
/usr/share ??? Õâ¸ö¿ÉÄÜÐԺܴó ÄѵÀÊÇÕâ¸ö £¿£¿£¯
ȷʵÊÇ /var/lib/mysql
¼ì²é/etc/passwd
²Î¿¼À´×Ô
linuxÐÞ¸ÄÓû§Ö÷Ŀ¼µÄ·½·¨
Submitted by wayswang on 2008, November 27, 2:49 PM. Linux
ÎÒÓÐÁ½ÖÖ°ì·¨£¬½ö¹©²Î¿¼¡£
µÚÒ»£ºÐÞ¸Ä/etc/passwdÎļþ
µÚ¶þ£ºusermodÃüÁî
Ïêϸ˵Ã÷ÈçÏ£º
µÚÒ»ÖÖ·½·¨£ºvi /etc/passwd
ÕÒµ½ÒªÐ޸ĵÄÓû§ÄǼ¸ÐУ¬Ð޸ĵô¼´¿É¡£´Ë·¨ºÜ±©Á¦£¬½¨ÒéÉ÷Óá£
µÚ¶þÖÖ£ºusermod
usermod -d /usr/newfolder -u uid
-uºóÃæÒ»¶¨Òª½Óuid°¡£¬²»ÊÇusername
¸½£ºusermodÏêϸ²ÎÊý
Óï¡¡¡¡·¨£ºusermod [-LU][-c <±¸×¢>][-d <µÇÈëĿ¼>][-e <ÓÐЧÆÚÏÞ>][- f <»º³åÌìÊý>][-g <Ⱥ×é>][-G <Ⱥ×é>][-l <ÕʺÅÃû³Æ>][-s ][-u ] [Óû§ÕʺÅ]
²¹³ä˵Ã÷£ºusermod¿ÉÓÃÀ´ÐÞ¸ÄÓû§Õʺŵĸ÷ÏîÉ趨¡£
²Î¡¡¡¡Êý£º
-c <±¸×¢> ¡¡ÐÞ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......