lamp安装phpmysqladmin

lamp安装phpmysqladmin

phpmyadmin简介

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

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

部署phpmyadmin

#下载压缩包然后解压
[root@localhost ~]# cd /usr/src/
[root@localhost src]# ls
debug  kernels
[root@localhost src]# ls
debug  kernels  phpMyAdmin-5.2.0-all-languages.zip
[root@localhost src]# unzip phpMyAdmin-5.2.0-all-languages.zip 
#把php包放到指定网页的位置
[root@localhost ~]# cd /usr/local/apache/htdocs/
[root@localhost htdocs]# ls
index.html  nuanchun
[root@localhost htdocs]# cd nuanchun
[root@localhost nuanchun]# ls
index.php
[root@localhost nuanchun]# rm -f index.php 
[root@localhost nuanchun]# ls
[root@localhost nuanchun]# mv /usr/src/phpMyAdmin-5.2.0-all-languages/* . 
[root@localhost nuanchun]# ls
CONTRIBUTING.md        doc           setup
ChangeLog              examples      show_config_errors.php
LICENSE                favicon.ico   sql
README                 index.php     templates
RELEASE-DATE-5.2.0     js            themes
babel.config.json      libraries     url.php
composer.json          locale        vendor
composer.lock          package.json  yarn.lock
config.sample.inc.php  robots.txt
[root@localhost nuanchun]# 

#进入数据库设置远程连接
[root@localhost ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, 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.
查看用户
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 '123';
Query OK, 0 rows affected, 1 warning (0.01 sec)
刷新数据库
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服务

最后测试一下就可以了