ITPub博客

Linux 7安装和配置phpmyadmin

原创 Linux操作系统 作者:甲骨文技术支持 时间:2018-03-05 15:39:11 0 删除 编辑
1.在https://www.apachefriends.org/zh_cn/index.html这个网站下载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.修改文件的权限


  1. 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.

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

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

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

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

  10. ----------------------------------------------------------------------------
  11. Installation Directory

  12. XAMPP will be installed to /opt/lampp
  13. Press [Enter] to continue:

  14. ----------------------------------------------------------------------------
  15. Setup is now ready to begin installing XAMPP on your computer.

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

  17. ----------------------------------------------------------------------------
  18. Please wait while Setup installs XAMPP on your computer.

  19.  Installing
  20.  0% ______________ 50% ______________ 100%
  21.  #########################################

  22. ----------------------------------------------------------------------------
  23. 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.在浏览器里输入http://13.115.1xx.xx,换成自己的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

  2. auth_type默认是http,修改为cookie即可

  3. $i++;
  4. /* Authentication type */
  5. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  6. $cfg['Servers'][$i]['user'] = 'root';
  7. $cfg['Servers'][$i]['password'] = '';
  8. /* Server parameters */
  9. //$cfg['Servers'][$i]['host'] = 'localhost';
  10. $cfg['Servers'][$i]['compress'] = false;
  11. $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;

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

另:

在安装过程中可能会遇到错误,请参考我的另一篇博文
http://blog.itpub.net/20893244/viewspace-2151435/

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20893244/viewspace-2151517/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
2009年获得Oracle OCM认证,ITPUB社区OCM联盟成员,熟悉Oracle,mysql,Python,Zabbix等。

注册时间:2016-12-31

  • 博文量
    113
  • 访问量
    150757