Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 设立mysql只有指定的ip地址可以访问

设立mysql只有指定的ip地址可以访问

WBOY
Release： 2016-06-13 13:05:05
Original
1023 people have browsed it

设置mysql只有指定的ip地址可以访问
为了加强服务器的安全，设置只有指定的ip地址才可以访问phpmyadmin和命令行，请问如何操作
------最佳解决方案--------------------
phpmyadmin要在web服务器前端处理，就是apache，nginx级别
命令行只要做好mysql的权限，不给%主机权限即可
------其他解决方案--------------------
在phpmyadmin的目录下做一个.htaccess的限制文件即可。
------其他解决方案--------------------
好像是在mysql数据库里面的user表，可以从里面添加要可以访问ip
------其他解决方案--------------------
没怎么看懂呢？

Related labels：
apache htaccess mysql nginx phpmyadmin
source：php.cn
Previous article： 小弟我要在网页中显示php文件代码,如何做到安全 Next article： 301 Moved Permanently解决思路
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Unable to establish external connection to MySQL/MariaDB database I'm trying to connect a MariaDB client (DBeaver) to my database from my home computer. The...
From 2024-03-31 23:39:43
0
1
302
Docker Image: Integration of PHP 8.0, Apache and phpMyAdmin I'm creating an image for a php8 project running on apache and using phpMyAdmin, my Docker...
From 2024-03-31 18:19:17
0
1
306
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template