lamp搭建phpmyadmin

lamp搭建phpmyadmin

phpmyadmin简介

phpmyadmin是一个以PHP为基础，以Web-Base方式架构在网站主机上的MySQL的数据库管理工具。

简单来说就是让使用者能在网页直接管理操作数据库并及时看到数据库的情况。

部署phpmyadmin

网址：phpMyAdmin

下载php包
[root@localhost src]# ls
debug  kernels  phpMyAdmin-5.2.0-all-languages.zip


解压
[root@localhost src]# unzip phpMyAdmin-5.2.0-all-languages.zip 
[root@localhost src]# ls
debug  kernels  phpMyAdmin-5.2.0-all-languages  phpMyAdmin-5.2.0-all-languages.zip
[root@localhost src]# ls phpMyAdmin-5.2.0-all-languages
CONTRIBUTING.md     composer.json          index.php     setup                   vendor
ChangeLog           composer.lock          js            show_config_errors.php  yarn.lock
LICENSE             config.sample.inc.php  libraries     sql
README              doc                    locale        templates
RELEASE-DATE-5.2.0  examples               package.json  themes
babel.config.json   favicon.ico            robots.txt    url.php



把php文件放到yyz里
[root@localhost ~]# cd /usr/local/apache/htdocs/yyz/
[root@localhost yyz]# ls
index.php
[root@localhost yyz]# rm -rf index.php 
[root@localhost yyz]# mv /usr/src/phpMyAdmin-5.2.0-all-languages/* /usr/local/apache/htdocs/yyz/
[root@localhost yyz]# ls
CONTRIBUTING.md     composer.json          index.php     setup                   vendor
ChangeLog           composer.lock          js            show_config_errors.php  yarn.lock
LICENSE             config.sample.inc.php  libraries     sql
README              doc                    locale        templates
RELEASE-DATE-5.2.0  examples               package.json  themes
babel.config.json   favicon.ico            robots.txt    url.php




二进制安装的MySQL用户是没有远程登录,所以我们授权一下
[root@localhost ~]# mysql -uroot -pyyz123!
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.38 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
查询用户 user host
mysql> select user,host from mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)

mysql> grant all on *.* to "root"@"%" identified by 'yyz123!';
Query OK, 0 rows affected, 1 warning (0.01 sec)

刷新mysql
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host from mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)

mysql> exit
Bye



重启httpd
[root@localhost ~]# systemctl restart httpd

网页测试