千家信息网

Linux7安装和配置phpmyadmin的步骤

发表于:2024-12-12 作者:千家信息网编辑
千家信息网最后更新 2024年12月12日,这篇文章主要讲解了"Linux7安装和配置phpmyadmin的步骤",文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习"Linux7安装和配置phpmyad
千家信息网最后更新 2024年12月12日Linux7安装和配置phpmyadmin的步骤

这篇文章主要讲解了"Linux7安装和配置phpmyadmin的步骤",文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习"Linux7安装和配置phpmyadmin的步骤"吧!

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. AllowOverride AuthConfig Limit

  2. Require local

  3. ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var

修改为


  1. AllowOverride AuthConfig Limit

  2. Require all granted

  3. ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var

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;


感谢各位的阅读,以上就是"Linux7安装和配置phpmyadmin的步骤"的内容了,经过本文的学习后,相信大家对Linux7安装和配置phpmyadmin的步骤这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是,小编将为大家推送更多相关知识点的文章,欢迎关注!

0