Linux 7安裝和配置phpmyadmin

甲骨文技術支援發表於2018-03-05
LinuxPHP
1.在這個網站下載xampp

2.本文下載的是xampp-linux-x64-7.2.2-0-installer.run

  1. wget https://www.apachefriends.org/xampp-files/7.2.2/xampp-linux-x64-7.2.2-0-installer.run
3.修改檔案的許可權


  2. chmod 755 xampp-linux-x64-7.2.2-0-installer.run
4.安裝

  1. [root@aws ~]# ./xampp-linux-x64-7.2.2-0-installer.run
  2. ----------------------------------------------------------------------------
  3. Welcome to the XAMPP Setup Wizard.

  5. ----------------------------------------------------------------------------
  6. Select the components you want to install; clear the components you do not want
  7. to install. Click Next when you are ready to continue.

  9. XAMPP Core Files : Y (Cannot be edited)

  11. XAMPP Developer Files [Y/n] :n

  13. Is the selection above correct? [Y/n]:

  15. ----------------------------------------------------------------------------
  16. Installation Directory

  18. XAMPP will be installed to /opt/lampp
  19. Press [Enter] to continue:

  21. ----------------------------------------------------------------------------
  22. Setup is now ready to begin installing XAMPP on your computer.

  24. Do you want to continue? [Y/n]:

  26. ----------------------------------------------------------------------------
  27. Please wait while Setup installs XAMPP on your computer.

  29.  Installing
  30.  0% ______________ 50% ______________ 100%
  31.  #########################################

  33. ----------------------------------------------------------------------------
  34. Setup has finished installing XAMPP on your computer.
5.啟動

  1. [root@aws lampp]# ./lampp start
  2. Starting XAMPP for Linux 7.2.2-0...
  3. XAMPP: Starting Apache...ok.
  4. XAMPP: Starting MySQL...ok.
  5. XAMPP: Starting ProFTPD...ok.
6.在瀏覽器裡輸入，換成自己的ip和最好用google瀏覽器，其他瀏覽器有可能顯示不了

 

7.點選上圖右邊的”phpmyadmin”，會遇到403錯誤，解決辦法是修改配置檔案，讓它允許local之外訪問

  1. vi /opt/lampp/etc/extra/httpd-xampp.conf
把下面這段程式碼中黑體字

  1. <Directory "/opt/lampp/phpmyadmin">
  2.     AllowOverride AuthConfig Limit
  3.     Require local
  4.     ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
  5. </Directory>
修改為

  1. <Directory "/opt/lampp/phpmyadmin">
  2.     AllowOverride AuthConfig Limit
  3.     Require all granted
  4.     ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
  5. </Directory>
8.再次點選”phpmyadmin”，出現如下的介面就表示安裝成功了。



9.這個頁面有3種模式，預設是httpd，我一般喜歡用config模式，如下圖:


修改方法是：

  1. vi /opt/lampp/phpmyadmin/config.inc.php

  3. auth_type預設是http,修改為cookie即可

  5. $i++;
  6. /* Authentication type */
  7. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  8. $cfg['Servers'][$i]['user'] = 'root';
  9. $cfg['Servers'][$i]['password'] = '';
  10. /* Server parameters */
  11. //$cfg['Servers'][$i]['host'] = 'localhost';
  12. $cfg['Servers'][$i]['compress'] = false;
  13. $cfg['Servers'][$i]['AllowNoPassword'] = true;

如果想管理其他的mysql資料庫，按照如下設置，把$i++;下面的複製一份，放到下面，修改host等

  1. $i++;
  2. /* Authentication type */
  3. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  4. $cfg['Servers'][$i]['user'] = 'root';
  5. $cfg['Servers'][$i]['password'] = '';
  6. /* Server parameters */
  7. //$cfg['Servers'][$i]['host'] = 'localhost';
  8. $cfg['Servers'][$i]['compress'] = false;
  9. $cfg['Servers'][$i]['AllowNoPassword'] = true;

  11. $i++;
  12. /* Authentication type */
  13. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  14. /* Server parameters */
  15. $cfg['Servers'][$i]['host'] = 'oms';
  16. $cfg['Servers'][$i]['compress'] = false;
  17. $cfg['Servers'][$i]['AllowNoPassword'] = false;

另：

在安裝過程中可能會遇到錯誤，請參考我的另一篇博文http://blog.itpub.net/20893244/viewspace-2151435/

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20893244/viewspace-2151517/，如需轉載，請註明出處，否則將追究法律責任。

相關文章