phpMyAdmin creating MySQL database and standalone database account _php Tutorial

phpMyAdmin creating MySQL database and standalone database account

First of all we want to login PHP tutorial (as the current mainstream development language) MyAdmin, do not do a demo.

2, create a database tutorial, for example, in PHP (as the current mainstream development language) MyAdmin the right window, fill in the database name, click Create.

For example, here we create a database named: cncmstest
The following tips are available when you create a success:

3. Click the Home button in the top left corner to return to PHP (as the current mainstream development language) MyAdmin main interface:

4. Click "Permissions" on the right side of the main screen to create a database account.

5. On the Permissions page, we click "Add New User"

6. On this page, we fill in the database user name to be created, the user's access scope, and password.

For example, we filled out the user name is: cncmsuser, the database user only allow local access, host a choice locally; password we use auto-generated, the point below "Generate" will generate a random password, then click "Copy" will be automatically filled in the Password box.
The box below is not selected, just pull to the bottom of the page to execute to create a new user.
When the database user is created successfully, the following page is returned:

7, the most important step, set the user's database access rights
You can set permissions directly on the page where the database user added a successful return. Here we choose to specify permissions by database:

For example, selecting the Cncmstest we just created in the database list automatically goes to the permissions settings page for that database.

In the permission settings, we have the "data", "structure" two columns of the permissions are all selected, administrative rights are not selected. Click Execute.

Here we have all set up, created a database: Cncmstest, and created a database user cncmsuser, specifically specifying the user only access to cncmstest. In this way, we have reached the point we started with: To specify individual user access rights for each database.

http://www.bkjia.com/PHPjc/630885.html www.bkjia.com true http://www.bkjia.com/PHPjc/630885.html techarticle phpMyAdmin Creating a MySQL database and a standalone database account first we will log into the PHP tutorial (as the current mainstream development language) MyAdmin, do not do a demo. 2, create a database tutorial, such as ...

