phpMyAdminÄܹ»Ô¶³Ì¹ÜÀímysqlÂð£¿
ÎÒÔÚ¾ÖÓòÍøÄڵķþÎñÆ÷192.168.1.20ÉϽ¨ÁËapache+php+mysql+phpMyAdmin£¬ÏÖÔÚÎÒÏëÔÚ¾ÖÓòÍøÄÚÆäËüÈκλú×ÓÉϹÜÀí·þÎñÆ÷ÉϵÄmysqlÊý¾Ý¿â£¬µ«ÊÇÊäÈë[url]http://192.168.1.20/phpMyAdmin/[/url]ºó×Ü»áÓгö´íÐÅÏ¢£¬¾ÍÊÇ˵phpMyAdminÀïµÄÖ÷»úÃûlocalhostÒª¸Ä³ÉÏàÓ¦µÄipµØÖ·£¬µ«ÊÇÎÒÏëÈκÎһ̨»ú×Ó¶¼ÄܹÜÀí£¬ÇëÎÊÓÐʲôºÃµÄ°ì·¨Âð£¿
»òÕßÎÒ²»ÓÃphpMyAdminÒ²ÐС£ °´ÕÕ´íÎóÌáʾÐ޸İÉ, ËüÊÇÖ§³ÖÔ¶³Ì¹ÜÀíµÄ ÎÒÔÚ·þÎñÆ÷Éϰ²×°ÁËmysql£¬Í¨¹ýÃüÁîÉèÖÃÁ˾ÖÓòÍøÀàËùÓÐÓû§¶¼Äܹ»ÔÚ¿Í»§¶ËµÇ¼£º
mysql>grant select,insert,update,delete on *.* to hello@"%" Identified by "abc";
ÎÒÏëÔÚ¿Í»§¶ËÓÃphpmyadmin½øÐйÜÀí£¬ÄÇphpmyadminÊÇÒª°²×°ÔÚ·þÎñÆ÷ÉÏ»¹Êǿͻ§¶ËÄØ£¿
ÎÒÔÚ·þÎñÆ÷192.168.1.20Éϰ²×°ÁËphpmyadmin£¬ÈçºÎÉèÖÃconfig.inc.phpÖеÄ
$cfg['Servers'][$i]['user'] =
$cfg['Servers'][$i]['password'] =
$cfg['PmaAbsoluteUri'] =
$cfg['Servers'][$i]['host'] =
²ÅÄÜÔÚ¿Í»§¶Ë·ÃÎÊ [url]http://192.168.1.20/phpMyAdmin/[/url] ½øÐÐmysqlµÄ¹ÜÀíѽ ÉèÖÃΪÊý¾Ý¿â¹ÜÀíÔ±µÄID ºÍpasswd,
Ó¦¸Ã²»ÐèÒªhelloÓû§; ²éѯ,ɾ³ýµÄ²Ù×÷ÊÇÔÚ·þÎñÆ÷¶ËÍê³É,È»ºó·µ»Ø¸ø¿Í»§¶ËµÄ.
Ò³:
[1]