Linux Ï mysql µÄÏà¹ØÃüÁî
1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
ÒѾÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
ÎÊÌ⣺
cat /etc/mysql/my.conf
ÕÒµ½ÏÂÃæÒ»ÐÐ
bind-address = 127.0.0.1
ΪÁËÊý¾ÝµÄ°²È«£¬Ä¬ÈÏMySQLÖ»ÊغòÔÚ127.0.0.1ÉÏ£¬Ç°ÃæÊÇûÓÐ×¢Ê͵ģ¬ËùÒÔ¾ÍÖ»Äܱ¾»ú·ÃÎÊ¡£
½â¾ö°ì·¨£º
ÔÚbind-address Ç°Ãæ¼ÓÉÏ×¢ÊÍ£¬ÖØÆðMYSQL¾ÍOKÁË
µÚ¶þ²½£º
mysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
ÓÃÉÏÃæµÄÃüÁîÐ޸ģ¡ ÖØÆômysql
3. Êý¾Ý¿âµ¼³öºÍµ¼Èë
ÏÂÃæµÄÀý×ÓÏÔʾÔõÑùµ¼³öÒ»¸öMySQLÊý¾Ý¿â£¬¾³£½«Êý¾Ýµ¼³ö×ö¸ö±¸·Ý»¹ÊDZØÒªµÄ£¬puttyµÇ½·þÎñÆ÷£¬½øÈëÄãÒª±¸·ÝÊý¾Ý¿âµÄĿ¼£¬±¸·ÝÍê±Ïºó£¬Êý¾Ý¿âÎļþ½«±£´æÔÚ¸ÃĿ¼£¬ÔÚÃüÁîÐеIJÙ×÷²½ÖèÈçÏ£º
(1). mysqldump -u username -p database_name > 20090708.sql
(2). »Ø³µ
(3). ÌáʾÊäÈëÃÜÂë
(4). ÊäÈëÃÜÂ룬»Ø³µ.
ÉÏ´«MySQLÊý¾Ý¿â±¸·ÝÎļþ(±ÈÈçÉÏÃæµ¼³öµÄÎļþ20090708.sql)µ½ÄãµÄ·þÎñÆ÷ÉÏ£¬»òÕß´ÓÄãµÄзþÎñÆ÷ͨ¹ýwgetÃüÁî(ÉÏÃæÓÐÌáµ½)Ö±½ÓÏÂÔØÊý¾Ý¿âÎļþµ½Ð·þÎñÆ÷£¬È»ºóÖ´ÐÐÈçÏÂÃüÁ
(1). mysql -u username -p database_name < 20090708.sql
(2). »Ø³µ
(3). ÌáʾÊäÈëÃÜÂë
(4). ÊäÈëÓû§Ãû¶ÔÓ¦µÄÃÜÂ룬»Ø³µ.
ÆäÖÐusername, password ºÍ database_name ¾ÍÊÇMySQLÊý¾Ý¿âµÄÓû§Ãû¡¢ÃÜÂë ºÍ Êý¾Ý¿âÃû¡£Îļþbak.sql¾ÍÊÇMySQLÊý¾Ý¿âµÄ±¸·ÝÎļþÃû³Æ¡£µ¼È뵽зþÎñÆ÷µÄʱºò£¬Êý¾Ý¿âÃû³ÆºÍÓû§Ãû³Æ×¢ÒâÒª¸úеÄÆ¥Åä¡£
Ïà¹ØÎĵµ£º
½ñÌìÖØÐÂ×°ÁËÒ»ÏÂmysqlÊý¾Ý¿â£¬½ØÖ¹µ½ÏÖÔÚÒѺÄʱ2£º30£¬ÓôÃÆ£¡£¡£¡£¡£¨ÎÒÔÀ´²»ÖªµÀ×°¹ý¶àÉÙ´Îmysql£©
ËùÒÔÎÒ¾ö¶¨£¬°Ñ¹ØÓÚmysqlÊý¾Ý¿âµÄ³õʼ»¯²Ù×÷½éÉÜÒ»ÏÂ
£º
1.°²×°mysqlÊý¾Ý¿â
http://www.duote.com/tech/1/2430_1.html
......
±¾ÊµÑéÍê³ÉÈçϽá¹û£º
0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
3. ¸ù¾ ......
Allocaº¯Êý£¬ÓÃÓÚÔÚÕ»ÉÏ·ÖÅäÄڴ棬
gcc
µÄ¶¯Ì¬Êý×é¾ÍÊÇͨ¹ýËüÀ´Ö§³ÖµÄ¡£
ÖжϺÍÐźŵĸÅÄîÊDz»Í¬µÄ£¬ÐźÅÊÇ·¢¸ø½ø³ÌµÄ£¬Ó²ÖжÏÊÇÄں˺ÍÓ²¼þÖ®¼ä£¬¶¼ÊÇÒì²½µÄ£¬²»¿ÉÔ¤ÖªµÄ¡£
ϵͳµ÷ÓýøÈëÄÚºËÊDz»·¢Éú½ø³ÌÇл»µÄ¡£DIRECT_IO
²»Ê¹ÓÃϵͳ
IO
»º´æ£¬»¹Òª±£Ö¤»º³åÇøÄÚ´æ²»±»
swap
£¬Õâ¸öÓÃÓÚÄÇЩÓû§²ã½øÐлº´æµÄÓ¦ÓÃ³Ì ......
phpMyAdminÌáʾû×Ö·û´®±àÂëºÍ×Ö·û´®´¦Àí¿âphp_mbstring
SSHÁ¬½ÓÉϺó£ºyum install php-mbstring°²×°À©Õ¹
vi usr/local/lxlabs/ext/php/etc/php.ini±à¼PHP.iniÎļþ
È¥µôÒ»ÐеÄ×¢ÊÍ£ºextension=mbstring.so
(ÓÐЩ¿ÉÒÔ²»ÓÃÉèÖÃÕâÁ½ÐУ¬php.iniÖв»´æÔÚ£»extension=mbstring.so
£¬
Ö»ÒªmbStringÀ©Õ¹°²×°µ½ÁËextension ......
ÔÚ/etc/rc.localÖÐÌí¼Ó
su - oracle "-c dbstart"
ÔÚ´Ë֮ǰÄãҪȷ±£¸ÃÃüÁî¿ÉÒÔÆô¶¯ÄãÐèÒªµÄÊý¾Ý¿â, ÐèÒª²âÊÔÒ»ÏÂ
su - oracle "-c dbstart"
dbstartÃüÁîÕý³£ÔËÐÐÐèÒªÅäÖÃ/etc/oratab,ÀïÃæ¿ÉÒÔÅäÖöà¸öÊý¾Ý¿âʵÀý,ÿ¸öµÄ¸ñʽ:
$ORACLE_SID:$ORACLE_HOME:<N|Y>
Õý³£Çé¿öÏÂÅäÖúÃ/etc/oratab, dbstartÃüÁî¾Í¿ÉÒÔÕý ......