如题所述
ããå¨CentOSä¸å®è£
phpMyAdminï¼ä½ 第ä¸æ¥éè¦æ¶è®¾ä¸å°Webæå¡å¨(å¦Apacheænginx)ï¼å®è£
好MySQL/MariaDBæ°æ®åºåPHPãæ ¹æ®ä½ çå好åéæ±ï¼ä½ å¯ä»¥ä»LAMPåLEMPä¸éæ©ä¸ç§å®è£
ã
ããå¦ä¸ä¸ªè¦æ±æ¯å 许å¨ä½ çCentOSä¸å®è£ EPELåºã
å¨CentOS6æ7ä¸å®è£ phpMyAdmin
ããä¸æ¦ä½ 设置äºEPELåºï¼ä½ å°±è½è½»æ¾å°ç¨ä»¥ä¸å½ä»¤å®è£ phpMyAdminäºã
å¨CentOS 7ä¸:
$ sudo yum install phpmyadmin
å¨CentOS 7ä¸:
$ sudo yum install phpmyadmin php-mcrypt
å¨CentOS 7ä¸é ç½®phpMyAdmin
ããé»è®¤æ åµä¸ï¼CentOS 7ä¸çphpMyAdminåªå 许ä»åç¯å°å(127.0.0.1)访é®ã为äºè½è¿ç¨è¿æ¥ï¼ä½ éè¦æ¹å¨å®çé ç½®ã
ããç¨ææ¬ç¼è¾å¨æå¼phpMyAdminçé ç½®æ件(è·¯å¾ï¼/etc/httpd/conf.d/phpMyAdmin.conf)ï¼æ¾åºå¹¶æ³¨éæ带æ"Require ip XXXX"åæ ·ç代ç è¡ãä¼æåå¤è¿æ ·ç代ç è¡ï¼ç¨"Require all granted"åè代ä¹ãéæ°æ¹å¨è¿çé ç½®æ件å¦ä¸æ示ã
$ sudo vi /etc/httpd/conf.d/phpMyAdmin.conf
. . . . .<Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> #Require ip 127.0.0.1 #Require ip ::1 Require all granted </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from ::1 </IfModule></Directory> <Directory /usr/share/phpMyAdmin/setup/> <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> #Require ip 127.0.0.1 #Require ip ::1 Require all granted </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from ::1 </IfModule></Directory>. . . . .
ããæåï¼éå¯httpd使æ¹å¨çæã
$ sudo systemctl restart httpd
å¨CentOS 6ä¸é ç½®phpMyAdmin
é»è®¤æ åµä¸ï¼CentOS 6ä¸çphpMyAdminæ¯ç¦æ¢ä»æ¯ä¸ªIPå°å访é®çã为äºè½è¿ç¨è¿æ¥ï¼ä½ éè¦æ¹å¨å®çé ç½®ã
ç¨ææ¬ç¼è¾å¨æå¼phpMyAdminçé ç½®æ件(è·¯å¾ï¼/etc/httpd/conf.d/phpMyAdmin.conf)ï¼æ¾åºå¹¶æ³¨éæ"Deny from all"åæ ·ç代ç è¡ãç¶åæ"Allow from 127.0.0.1"åæ ·ç代ç è¡æ¹æ"Allow from 0.0.0.0"ãéæ°æ¹å¨è¿çé ç½®æ件å¦ä¸æ示ã
$ sudo vi /etc/httpd/conf.d/phpmyadmin.conf
<Directory "/usr/share/phpmyadmin"> Order Deny,Allow# Deny from all Allow from 0.0.0.0</Directory>
ä¸ä¸æ¥æ¯å°phpMyAdminçé ç½®æ件ç¨blowfishå å¯å·¥å ·å å¯ãè¿ä¸æ¥éè¦å å¯cookieéçå¯ç æ¥ä½ä¸ºåºäºcookieçé¨å认è¯ã
ç¨ææ¬ç¼è¾å¨æå¼å¦ä¸è·¯å¾æ示çæ件并ä¸ç¨blowfish设置ä¸ä¸ªéæºå¯ç ï¼å¦ä¸æ示ã
$ sudo vi /usr/share/phpmyadmin/config.inc.php
$cfg['blowfish_secret'] = 'kd5G}d33aXDc50!'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
æåï¼éå¯httpd使æ¹å¨çæã
$ sudo service httpd restart
æµè¯phpMyAdmin
æµè¯phpMyAdminæ¯å¦è®¾ç½®æåï¼è®¿é®è¿ä¸ªé¡µé¢ï¼http://<web-server-ip-addresss>/phpmyadmin
ä½ åºè¯¥è½éè¿Webçé¢æ¥è®°å½ä¸ä»»ä½MySQLç¨æ·(æ¯å¦root)å管çMySQL/MariaDBçæ°æ®åº/表ã
çé¾è§£ç
è¿éæä¸äºå¨CentOSä¸å®è£ phpMyAdminçè¿ç¨ä¸éå°çä¸äºé®é¢è§£å³æ¹æ³ã
å½ä½ å¨æµè§å¨éå°è¯è¿æ¥phpMyAdmin页é¢çæ¶åï¼ä½ çå°"403 Forbidding"é误ï¼
You don't have permission to access /phpMyAdmin on this server.
åçè¿ç§é误æ¯å 为phpMyAdminé»è®¤é»æ¢äºIPå°åè¿ç¨è¿æ¥ãè¦ä¿®å¤è¿ç§é误ï¼ä½ éè¦ç¼è¾å®çé ç½®æ件æ¥å 许è¿ç¨è¿æ¥ãå ·ä½æä½è§ä¸ã
å½ä½ è¿æ¥phpMyAdmin页é¢æ¶ï¼ä½ çè§"The configuration file now needs a secret passphrase (blowfish_secret)."ä¿¡æ¯ï¼å¹¶ä¸ä½ æ æ³ç»å½ã
è¦ä¿®å¤è¿ç§é误ï¼ä½ éè¦ç¼è¾ /usr/share/phpmyadmin/config.inc.php è¿ä¸ªæ件æ¥æ·»å ä¸ä¸ªéæºçblowfishå¯ç ï¼ç¶åéå¯httpdï¼å¦ä¸æ示ã
$ sudo service httpd restart (CentOS 6)
$ sudo systemctl restart httpd (CentOS 7)
$cfg['blowfish_secret'] = 'kd5G}d33aXDc50!'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
å½ä½ è¿æ¥phpMyAdmin页é¢æ¶ï¼ä½ çè§"Cannot load mcrypt extension. Please check your PHP configuration"é误信æ¯ã
è¦ä¿®å¤è¿ç§é误ï¼è¦å®è£ ä¸é¢è¿ä¸ªå ï¼
ç¶åéå¯httpdï¼
$ sudo service httpd restart (CentOS 6)
$ sudo systemctl restart httpd (CentOS 7)
$ sudo yum install php-mcrypt
ããå¦ä¸ä¸ªè¦æ±æ¯å 许å¨ä½ çCentOSä¸å®è£ EPELåºã
å¨CentOS6æ7ä¸å®è£ phpMyAdmin
ããä¸æ¦ä½ 设置äºEPELåºï¼ä½ å°±è½è½»æ¾å°ç¨ä»¥ä¸å½ä»¤å®è£ phpMyAdminäºã
å¨CentOS 7ä¸:
$ sudo yum install phpmyadmin
å¨CentOS 7ä¸:
$ sudo yum install phpmyadmin php-mcrypt
å¨CentOS 7ä¸é ç½®phpMyAdmin
ããé»è®¤æ åµä¸ï¼CentOS 7ä¸çphpMyAdminåªå 许ä»åç¯å°å(127.0.0.1)访é®ã为äºè½è¿ç¨è¿æ¥ï¼ä½ éè¦æ¹å¨å®çé ç½®ã
ããç¨ææ¬ç¼è¾å¨æå¼phpMyAdminçé ç½®æ件(è·¯å¾ï¼/etc/httpd/conf.d/phpMyAdmin.conf)ï¼æ¾åºå¹¶æ³¨éæ带æ"Require ip XXXX"åæ ·ç代ç è¡ãä¼æåå¤è¿æ ·ç代ç è¡ï¼ç¨"Require all granted"åè代ä¹ãéæ°æ¹å¨è¿çé ç½®æ件å¦ä¸æ示ã
$ sudo vi /etc/httpd/conf.d/phpMyAdmin.conf
. . . . .<Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> #Require ip 127.0.0.1 #Require ip ::1 Require all granted </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from ::1 </IfModule></Directory> <Directory /usr/share/phpMyAdmin/setup/> <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> #Require ip 127.0.0.1 #Require ip ::1 Require all granted </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from ::1 </IfModule></Directory>. . . . .
ããæåï¼éå¯httpd使æ¹å¨çæã
$ sudo systemctl restart httpd
å¨CentOS 6ä¸é ç½®phpMyAdmin
é»è®¤æ åµä¸ï¼CentOS 6ä¸çphpMyAdminæ¯ç¦æ¢ä»æ¯ä¸ªIPå°å访é®çã为äºè½è¿ç¨è¿æ¥ï¼ä½ éè¦æ¹å¨å®çé ç½®ã
ç¨ææ¬ç¼è¾å¨æå¼phpMyAdminçé ç½®æ件(è·¯å¾ï¼/etc/httpd/conf.d/phpMyAdmin.conf)ï¼æ¾åºå¹¶æ³¨éæ"Deny from all"åæ ·ç代ç è¡ãç¶åæ"Allow from 127.0.0.1"åæ ·ç代ç è¡æ¹æ"Allow from 0.0.0.0"ãéæ°æ¹å¨è¿çé ç½®æ件å¦ä¸æ示ã
$ sudo vi /etc/httpd/conf.d/phpmyadmin.conf
<Directory "/usr/share/phpmyadmin"> Order Deny,Allow# Deny from all Allow from 0.0.0.0</Directory>
ä¸ä¸æ¥æ¯å°phpMyAdminçé ç½®æ件ç¨blowfishå å¯å·¥å ·å å¯ãè¿ä¸æ¥éè¦å å¯cookieéçå¯ç æ¥ä½ä¸ºåºäºcookieçé¨å认è¯ã
ç¨ææ¬ç¼è¾å¨æå¼å¦ä¸è·¯å¾æ示çæ件并ä¸ç¨blowfish设置ä¸ä¸ªéæºå¯ç ï¼å¦ä¸æ示ã
$ sudo vi /usr/share/phpmyadmin/config.inc.php
$cfg['blowfish_secret'] = 'kd5G}d33aXDc50!'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
æåï¼éå¯httpd使æ¹å¨çæã
$ sudo service httpd restart
æµè¯phpMyAdmin
æµè¯phpMyAdminæ¯å¦è®¾ç½®æåï¼è®¿é®è¿ä¸ªé¡µé¢ï¼http://<web-server-ip-addresss>/phpmyadmin
ä½ åºè¯¥è½éè¿Webçé¢æ¥è®°å½ä¸ä»»ä½MySQLç¨æ·(æ¯å¦root)å管çMySQL/MariaDBçæ°æ®åº/表ã
çé¾è§£ç
è¿éæä¸äºå¨CentOSä¸å®è£ phpMyAdminçè¿ç¨ä¸éå°çä¸äºé®é¢è§£å³æ¹æ³ã
å½ä½ å¨æµè§å¨éå°è¯è¿æ¥phpMyAdmin页é¢çæ¶åï¼ä½ çå°"403 Forbidding"é误ï¼
You don't have permission to access /phpMyAdmin on this server.
åçè¿ç§é误æ¯å 为phpMyAdminé»è®¤é»æ¢äºIPå°åè¿ç¨è¿æ¥ãè¦ä¿®å¤è¿ç§é误ï¼ä½ éè¦ç¼è¾å®çé ç½®æ件æ¥å 许è¿ç¨è¿æ¥ãå ·ä½æä½è§ä¸ã
å½ä½ è¿æ¥phpMyAdmin页é¢æ¶ï¼ä½ çè§"The configuration file now needs a secret passphrase (blowfish_secret)."ä¿¡æ¯ï¼å¹¶ä¸ä½ æ æ³ç»å½ã
è¦ä¿®å¤è¿ç§é误ï¼ä½ éè¦ç¼è¾ /usr/share/phpmyadmin/config.inc.php è¿ä¸ªæ件æ¥æ·»å ä¸ä¸ªéæºçblowfishå¯ç ï¼ç¶åéå¯httpdï¼å¦ä¸æ示ã
$ sudo service httpd restart (CentOS 6)
$ sudo systemctl restart httpd (CentOS 7)
$cfg['blowfish_secret'] = 'kd5G}d33aXDc50!'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
å½ä½ è¿æ¥phpMyAdmin页é¢æ¶ï¼ä½ çè§"Cannot load mcrypt extension. Please check your PHP configuration"é误信æ¯ã
è¦ä¿®å¤è¿ç§é误ï¼è¦å®è£ ä¸é¢è¿ä¸ªå ï¼
ç¶åéå¯httpdï¼
$ sudo service httpd restart (CentOS 6)
$ sudo systemctl restart httpd (CentOS 7)
$ sudo yum install php-mcrypt
温馨提示:答案为网友推荐,仅供参考
第1个回答 2018-08-01
phpMyAdmin是一款以PHP为基础,基于Web的MySQL/MariaDB数据库管理工具。虽然已经存在着一些诸如Adminer的轻量级数据库管理工具, 但是phpMyAdmin还是更加广泛应用于网站管理员之中来进行各种MySQL/MariaDB的管理任务。它支持几乎所有MySQL数据库/表的相关操作,比如浏览、创建、复制、删除、重命名、更改,还有MySQL用户/权限管理和数据库导入/导出。
1、在CentOS上安装phpMyAdmin,第一步需要架设一台Web服务器(如Apache或nginx),安装好MySQL/MariaDB数据库和PHP。根据偏好和需求,可以从LAMP和LEMP中选择一种安装。
另一个要求是允许在CentOS上安装EPEL库。
2、用以下命令安装phpMyAdmin。
$ sudo yum install phpmyadmin
$ sudo yum install phpmyadmin php-mcrypt
3、默认情况下,CentOS 7上的phpMyAdmin只允许从回环地址(127.0.0.1)访问。为了能远程连接,需要改动它的配置。
用文本编辑器打开phpMyAdmin的配置文件(/etc/httpd/conf.d/phpMyAdmin.conf),找出并注释掉带有"Require ip XXXX"字样的代码行。会有四处这样的代码行,用"Require all granted"取而代之。
$ sudo vi /etc/httpd/conf.d/phpMyAdmin.conf
4、最后,重启httpd使改动生效。
$ sudo systemctl restart httpd本回答被网友采纳
1、在CentOS上安装phpMyAdmin,第一步需要架设一台Web服务器(如Apache或nginx),安装好MySQL/MariaDB数据库和PHP。根据偏好和需求,可以从LAMP和LEMP中选择一种安装。
另一个要求是允许在CentOS上安装EPEL库。
2、用以下命令安装phpMyAdmin。
$ sudo yum install phpmyadmin
$ sudo yum install phpmyadmin php-mcrypt
3、默认情况下,CentOS 7上的phpMyAdmin只允许从回环地址(127.0.0.1)访问。为了能远程连接,需要改动它的配置。
用文本编辑器打开phpMyAdmin的配置文件(/etc/httpd/conf.d/phpMyAdmin.conf),找出并注释掉带有"Require ip XXXX"字样的代码行。会有四处这样的代码行,用"Require all granted"取而代之。
$ sudo vi /etc/httpd/conf.d/phpMyAdmin.conf
4、最后,重启httpd使改动生效。
$ sudo systemctl restart httpd本回答被网友采纳