Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of how to manage the directory structure of PhpMyAdmin programs under Linux, the content is detailed and easy to understand, the operation is simple and fast, and it has a certain reference value, I believe you will have something to gain after reading this article on how to manage the directory structure of PhpMyAdmin programs under Linux, let's take a look.

1. Modify the name of phpmyadmin directory:

Before changing the directory name, it is easy for others to gain insight into the directory name, causing security risks. For example, if the domain name of a linux host is: www.test.com, then typing: www.test.com/phpmyadmin/ in the address bar will enter the phpmyadmin hypervisor without changing the directory name. So if you rename the phpmyadmin directory to a directory that is not easy for others to know, such as mynameadmin, when you are managing your own database, just type: www.test.com/mynameadmin/ and you can manage the database through your browser. (note: the phpmyadmin directory name will still be used below. If the directory name has been changed, just rename phpmyadmin to the new directory name. )

Add user authentication to the phpmyadmin directory:

This is a common method for many websites that require user authentication, so that when users browse to the directory for the first time, they will be prompted to enter a user name and password for authentication, which is achieved by using apache server's standard mod_auth module. The specific operation methods are as follows:

1. Vi edits the apache server configuration file to make sure that there are no comments in the following two sentences. If there is a "#" sign before these two sentences, remove the "#" sign.

Documentroot / data/web/apache/public/htdocs

Accessfilename. Htaccess

Alloerride all

2. Passwd program creates user files:

Htpasswd-c / data/web/apache/secrects/.htpasswd 88998

Among them,-c indicates the option to tell htpasswd that you want to generate a new user file, / data/web/apache/secrects/ is the directory where you want to store the .htpasswd file, the file name is .htpasswd, and 88998 is the user name used when verifying. After typing the above command, the system prompts you to enter the password, which is the password you need to validate. The password is encrypted in the .htpasswd file. Now look at the / data/web/apache/secrects/.htpasswd file with more, and you can see that there is a line of user name and a string of encrypted passwords.

3. Create a .htaccess file:

Using a text editor, create an .htaccess file under directory phpmyadmin (or new directory name if you have renamed it), and add the following statement to the file:

Authname "user Authentication"

Authtype basic

Authuserfile / data/web/apache/public/htdocs/phpmyadmin/.htpasswd

Require user 88998

After saving the operation, look at the phpmyadmin directory, you will be prompted to verify the window, enter the user name and password you just created with the htpasswd command, you can enter the directory.

Third, add host-based access control:

After modifying the directory name and adding the access authentication mechanism, it should be said that the current phpmyadmin is already very secure, but since the phpmyadmin directory is generally only used by database administrators, in order to prevent others from knowing the directory name and authentication password, you can also add the following host-based access control. Host-based access is achieved by verifying the user's machine ip, that is, only qualified ip can question the directory. Otherwise, access is denied.

Modify the .htaccess file as follows:

Authname "user Authentication"

Authtype basic

Authuserfile / data/web/apache/public/htdocs/phpmyadmin/.htpasswd

Require user 88998

Order deny,allow

Deny from all

Allow from 202.100.222.80

Three host-based access control instructions are added, the value of the first order instruction is a list separated by a comma, which indicates which instruction has higher priority, the second instruction deny defines the host that cannot access the directory, and the third instruction allow defines the host that can access the directory, so that the directory can be accessed by a machine with an ip address of 202.100.222.80 Nothing else can be accessed, and the reader can refer to this address as the user database administrator ip.

This is the end of the article on "how to manage the directory structure of PhpMyAdmin programs under Linux". Thank you for reading! I believe that everyone has a certain understanding of the knowledge of "how to manage the directory structure of PhpMyAdmin programs under Linux". If you want to learn more, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.