目录
功能
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.