Set mysql to be accessible only from a specified IP address. how can this problem be solved?
Source: Internet
Author: User
Set mysql to access only the specified IP address. to enhance server security, set only the specified IP address to access phpmyadmin and command line. how can I perform this operation? phpmyadmin should be processed at the front end of the web server, it is apache. for nginx command lines, you only need to grant mysql permissions and do not grant % host permissions. it seems that in mys, mysql can be accessed only by a specified IP address.
To enhance server security, set only the specified IP address to access phpmyadmin and command line. how can I perform this operation?
------ Solution --------------------
Phpmyadmin must be processed at the front-end of the web server, that is, apache and nginx
The command line only requires mysql permissions and does not grant % host permissions.
------ Solution --------------------
It seems to be the user table in the mysql database. you can add the ip addresses you want to access from the table.
------ Solution --------------------
Create a. htaccess restricted file in the phpmyadmin directory.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
