LAMP架构部署phpMyAdmin

目录

LAMP架构部署phpMyAdmin

功能

部署phpmyadmin

功能

phpMyAdmin 是一个用PHP编写的软件工具，可以通过web方式控制和操作MySQL数据库。通过phpMyAdmin 可以完全对数据库进行操作，例如建立、复制和删除数据等等。如果使用合适的工具，MySQL数据库的管理就会变得相当简单。应用 MySQL 命令行方式需要对 MySQL 知识非常熟悉，对SQL语言也是同样的道理。不仅如此，如果数据库的访问量很大，列表中数据的读取就会相当困难。

部署phpmyadmin

[root@zzh ~]# cd /usr/src/

[root@zzh src]# wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.zip

--2022-08-03 23:01:34-- https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.zip

Resolving files.phpmyadmin.net (files.phpmyadmin.net)... 89.187.187.12, 2a02:6ea0:c800::6

Connecting to files.phpmyadmin.net (files.phpmyadmin.net)|89.187.187.12|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 14112668 (13M) [application/zip]

Saving to: 'phpMyAdmin-5.2.0-all-languages.zip'

phpMyAdmin-5.2.0-all-languages.zip 100%[=======================================================================================================>] 13.46M 30.3KB/s in 4m 52s

2022-08-03 23:06:31 (47.2 KB/s) - 'phpMyAdmin-5.2.0-all-languages.zip' saved [14112668/14112668]

[root@zzh src]# ls

debug kernels phpMyAdmin-5.2.0-all-languages.zip

[root@zzh src]# unzip phpMyAdmin-5.2.0-all-languages.zip

Archive: phpMyAdmin-5.2.0-all-languages.zip

creating: phpMyAdmin-5.2.0-all-languages/

extracting: phpMyAdmin-5.2.0-all-languages/.rtlcssrc.json

inflating: phpMyAdmin-5.2.0-all-languages/CONTRIBUTING.md

inflating: phpMyAdmin-5.2.0-all-languages/ChangeLog

[root@zzh src]# cd /usr/local/apache/htdocs/yyz/ //把php文件放到yyz中去

[root@zzh yyz]# ls

index.php

[root@zzh yyz]# rm -rf index.php

[root@zzh yyz]# mv /usr/src/phpMyAdmin-5.2.0-all-languages/* /usr/local/apache/htdocs/yyz/

[root@zzh yyz]# ls

CONTRIBUTING.md LICENSE RELEASE-DATE-5.2.0 composer.json config.sample.inc.php examples index.php libraries package.json setup sql themes vendor

ChangeLog README babel.config.json composer.lock doc favicon.ico js locale robots.txt show_config_errors.php templates url.php yarn.lock

mysql授权

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> grant all on *.* to "root"@"%" identified by 'zhaozihao';

Query OK, 0 rows affected, 1 warning (0.00 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)

[root@zzh ~]# systemctl restart httpd //重启

[root@zzh ~]# mysql -uroot -pzhaozihao -e 'create database zzh;'

mysql: [Warning] Using a password on the command line interface can be insecure.