A5 security Group on Phpmysql account security

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Phpmysql's account security.

Hello everyone. I'm Admin5 's bright son. Remember the last few installments about a MySQL security. So here's to talk about creating account security, so they combine. Secure server protection.

On a server generally more than one site, more than a MySQL (and PHP collocation of the best combination) database. In order to prevent security risks, we generally set up a separate database access account for each database, the account only has access to the database permissions. Here's a concrete demonstration:

1: Login phpMyAdmin. Here I do not explain how to set phpMyAdmin.

2: Create a database, the following figure, fill out the database can be created, point to create.

For example, we want to create a Tooldiy library, the creation of success will have the following tips:

Then click on the home directory to go back to phpMyAdmin Main page.

Then we will create the account, click on the permissions of the interface to set.

Here I wrote an account for Tooldiy. Only local connection password is tool. The following generate password randomly generates a password. It is not recommended that you set up. None of the following are set. Direct click to generate.

This completes a creation. Next we set the permissions.

Here, we have all set up, created a database: Tooldiy, and created the database user Tooldi, specifically specify the user only Tooldiy access rights. In this way, we have come to the point where we started by specifying separate user access rights for each database.

If you have any questions, you are welcome to communicate with us.

qq:70065671 A5 Server Generation official address: http://safe.admin5.com

QQ Group: 84815663 84815626 84814264 27805343 75927060 17696688