phpstudy·¿ª²»ÁËphpmyadminÔõô°ì
Òª½â¾ö phpmyadmin ÎÞ·¨·¿ªµÄÎÊÌ⣬Çë¼ì²éÒÔÏ°취£ºÈ·±£ web ЧÀÍÆ÷£¨Èç apache »ò nginx£©ÕýÔÚÔËÐС£ÊµÑéÔÚä¯ÀÀÆ÷ÖÐÊäÈë url£ºhttp://localhost:8080/phpmyadmin ÒÔ¼ì²é¶Ë¿Ú¡£¼ì²é phpmyadmin ÉèÖÃÎļþÊÇ·ñ±£´æ¹ýʧ»òȱʧÉèÖá£ÊÚÓè mysql Óû§¶Ô phpmyadmin Êý¾Ý¿âµÄÊʵ±È¨ÏÞ¡£ÖØÐÂÆô¶¯ web ЧÀÍÆ÷ÒÔÓ¦Óøü¸Ä¡£
½â¾ö phpMyAdmin ÎÞ·¨·¿ªµÄÎÊÌâ
phpMyAdmin ÊÇÒ»¸öÓÃÓÚÖÎÀí MySQL Êý¾Ý¿âµÄÊ¢Ðй¤¾ß¡£ÎÞ·¨·¿ª phpMyAdmin ¿ÉÄÜÊÇÒ»¸öÁîÈ˾ÚÉ¥µÄÎÊÌ⣬µ«Í¨³£¿ÉÒÔÇáËɽâ¾ö¡£
¼ì²éÄúµÄ web ЧÀÍÆ÷
Ê×ÏÈ£¬È·±£ Apache »ò Nginx µÈ web ЧÀÍÆ÷ÕýÔÚÔËÐС£
Á¬Ã¦Ñ§Ï°¡°PHPÃâ·ÑѧϰÌõ¼Ç£¨ÉîÈ룩¡±£»
¼ì²é¶Ë¿Ú
phpMyAdmin ͨ³£ÔÚ¶Ë¿Ú 8080 ÉÏÔËÐС£ÊµÑéÔÚä¯ÀÀÆ÷ÖÐÊäÈëÒÔÏ URL£º
http://localhost:8080/phpmyadmin
¼ì²éÉèÖÃ
¼ì²éÄúµÄ phpMyAdmin ÉèÖÃÎļþ£¨Í¨³£Î»ÓÚ /etc/phpmyadmin/config.inc.php »ò /usr/share/phpmyadmin/config.inc.php£©ÊÇ·ñ±£´æ¹ýʧ»òȱʧÉèÖá£
¼ì²éȨÏÞ
È·±£ MySQL Óû§ÓµÓÐ¶Ô phpMyAdmin Êý¾Ý¿âµÄÊʵ±È¨ÏÞ¡£ÔËÐÐÒÔÏÂÅÌÎÊ£º
GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'phpmyadmin_user'@'localhost' IDENTIFIED BY 'phpmyadmin_password';
µÇ¼ºó¸´ÖÆ
ÖØÆô web ЧÀÍÆ÷
ÖØÐÂÆô¶¯ web ЧÀÍÆ÷£¬ÒÔÓ¦ÓÃÈκθü¸Ä£º
sudo systemctl restart apache2
µÇ¼ºó¸´ÖÆ
¹ØÓÚ Nginx£º
sudo systemctl restart nginx
µÇ¼ºó¸´ÖÆ
ÆäËûÌáÐÑ
ɨ³ýä¯ÀÀÆ÷»º´æ¡£
ʵÑéʹÓòî±ðµÄä¯ÀÀÆ÷¡£
½ûÓÃÈκοÉÄÜ×ÌÈÅ phpMyAdmin µÄä¯ÀÀÆ÷À©Õ¹»ò²å¼þ¡£
¼ì²éÄúµÄ·À²¡¶¾Èí¼þ»ò·À»ðǽÊÇ·ñ±£´æ×èÖ¹¶ÔÆä»á¼ûµÄ¹æÔò¡£
È·±£ÄúµÄ PHP °æ±¾Óë phpMyAdmin ¼æÈÝ¡£
ÒÔÉϾÍÊÇphpstudy·¿ª²»ÁËphpmyadminÔõô°ìµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡