ºìÁªLinuxÃÅ»§
Linux°ïÖú

linuxϰ²×°phpmyadmin

·¢²¼Ê±¼ä:2008-06-11 21:26:07À´Ô´:ºìÁª×÷Õß:Archive
ÔÚ°²×°fedoraµÄʱºò£¬°Ñ»ù±¾¸ÃÑ¡ÔñµÄ×é¼þ¶¼Ñ¡ÉÏ£¬ÆäÖоÍÓÐAppache£¬mysql£¬ºÍphp£¬µ«ÊÇÔÚÎÒÃǹÜÁËÊý¾Ý¿âµÄʱºò£¬»¹ÊÇÓиöͼÐνçÃæ±È½Ï·½±ã£¬ËùÒÔÎÒÃÇ×Ô¼º°²×°phpmyadminºÃÁË£¬°²×°ºÜ¼òµ¥µÄ¡£

phpMyAdminÊÇÒ»ÖÖMySQLµÄ¹ÜÀí¹¤¾ß,ËüÖ±½Ó´ÓwebÉÏÈ¥¹ÜÀíMySQL¡£

¼ÙÉèÄãµÄweb(ÍøÒ³´æ·Å)¸ùĿ¼ÊÇ /var/www/ ¼ÙÉèÄãµÄÖ÷»úweb·ÃÎÊÊÇÕâÑùµÄ http://192.168.1.11/

Äã¿ÉÒÔ°ÑËû°²×°µ½ /var/www/phpmyadmin µ±È»Ò²¿ÉÊÇ/var/www/µÄÈÎÒâϼ¶Ä¿Â¼

×¢ÒâÕâ¸öĿ¼Ãû×Ö×îºÃÖ»ÓйÜÀíÔ±ÖªµÀ.Òò´ËÎÒÃǼÙÉèΪ /var/www/onlyyouknow

A.Ïȵ½ phpMyAdminµÄ¹Ù·½Õ¾ÉÏÏÂÔØ×î½üµÄ phpMyAdmin³Ìʽ
http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

°Ñ phpMyAdmin-2.11.3-all-languages.tar.bz2 ÏÂÔØµ½ /var/www/
#cd /var/www/
#wget http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

µ±È»Ò²¿Éµ½Äã×Ô¼ºµÄwindows»úÆ÷,µÈÒÔºó±à¼­ºÃÁËÔÙÉÏ´«µ½web·þÎñÆ÷ÉÏ

B.½«´Ëµµ½âѹËõ
# tar zxvf phpMyAdmin-2.11.3-all-languages.tar.gz
´Ëʱ·¾¶ /var/www/phpMyAdmin-2.11.3-all-languages

C. ÐÞ¸ÄĿ¼ÃûΪ /var/www/onlyyoukown
# mv /var/www/phpMyAdmin-2.11.3-all-languages /var/www/onlyyoukown

D.ÐÞ¸ÄÉ趨µµ

1.ÕÒµ½ /libraries/config.default.phpÎļþ(config.default.php¸´ÖƵ½phpmyadminĿ¼Ï£¬È»ºó¸üÃûΪconfig.inc.php)£¬¸ÃÎļþÓÐÈçÏÂÏîÄ¿(2-8)Ðë×ÔÐÐÅäÖÃ,windowsÓÃд×ְ壨²»ÒªÓüÇʱ¾£¬ÕâÊÇUTF8±àÂ룩½øÐб༭,ÔÚlinuxÏÂÖ±½ÓÓÃvim±à¼­.

2.²éÕÒ $cfg['PmaAbsoluteUri'] ÐÞ¸ÄΪÄ㽫ÉÏ´«µ½¿Õ¼äµÄphpMyAdminµÄÍøÖ·

È磺$cfg['PmaAbsoluteUri'] = 'http://192.168.1.11/onlyyouknow/';

3.²éÕÒ $cfg['Servers'][$i]['host'] = 'localhost';£¨Í¨³£ÓÃĬÈÏ£¬Ò²ÓÐÀýÍ⣬¿ÉÒÔ²»ÓÃÐ޸ģ©

4.²éÕÒ $cfg['Servers'][$i]['auth_type'] = 'config';

ÔÚ×Ô¼ºµÄ»ú×ÓÀïµ÷ÊÔÓÃconfig£»Èç¹ûÔÚÍøÂçÉϵĿռäÓÃcookie£¬ÕâÀïÎÒÃǼÈÈ»ÔÚÇ°ÃæÒѾ­Ìí¼ÓÁËÍøÖ·£¬¾ÍÐ޸ijÉcookie £¬ÕâÀィÒéʹÓÃcookie.

5.²éÕÒ $cfg['Servers'][$i]['user'] = 'root'; // MySQL user£¨mysqlÓû§Ãû£¬×Ô¼º»úÀïÓÃroot£»£©

6.²éÕÒ $cfg['Servers'][$i]['password'] = ''; // MySQL password (mysqlÓû§µÄÃÜÂë,×Ô¼ºµÄ·þÎñÆ÷Ò»°ã¶¼ÊÇmysqlÓû§rootµÄÃÜÂë)

7.²éÕÒ $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only£¨ÄãÖ»ÓÐÒ»¸öÊý¾Ý¾ÍÉèÖÃһϣ»Èç¹ûÄãÔÚ±¾»ú»òÏë¼ÜÉè·þÎñÆ÷£¬ÄÇô½¨ÒéÁô¿Õ£©

8.²éÕÒ $cfg['DefaultLang'] = 'zh'; £¨ÕâÀïÊÇÑ¡ÔñÓïÑÔ£¬zh´ú±í¼òÌåÖÐÎĵÄÒâ˼,ÕâÀï²»ÖªµÀÌîgbk¶Ô·ñ£©

9.ÉèÖÃÍê±Ïºó±£´æ

Èç¹û³öÏÖ¡°ÅäÖÃÎļþÏÖÔÚÐèÒª¾øÃܵĶÌÓïÃÜÂë(blowfish_secret)¡±ÄÇôÇëÔÚ$cfg['blowfish_secret'] = ' ';µÄµÈºÅÀïÃæÉèÖÃÄãÍøÕ¾µÄcookie£¬ÀýÈ磺$cfg['blowfish_secret'] = 'ÈÎÒâ×Ö·û';ÕâÊÇÒòΪÄãµÄ¡°$cfg['Servers'][$i]['auth_type'] = 'cookie'µÄÔ­Òò¡£

E.²âÊÔ
¿ªÆôä¯ÀÀÆ÷£¬http://192.168.1.11/onlyyoukown/

Ò»µã¸öÈË¿´·¨
ÎÒÃÇÈÏΪ´ÓwebÉÏ¿ÉÒÔͨ¹ýmysqlµÄrootÓû§¿ØÖÆmysql²¢·ÇÒ»Öַdz£°²È«µÄ·½Ê½.Òò´ËÎҵĽ¨ÒéÊÇÈç¹ûÊÇ×Ô¼ºµÄ·þÎñÆ÷,µ±ÄãÓÃÍêÁË¿ÉÒÔ°ÑphpadminĿ¼·Åµ½web²»ÄÜ·ÃÎʵÄĿ¼,µ±ÒªÓÃʱ°ÑÕû¸öĿ¼ÓÃmvÃüÁîÒÆ»ØÔ­À´Î»ÖÃ
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ