如何在phpMyAdmin中創(chuàng)建具有特定權(quán)限的新MySQL用戶？首先登錄phpMyAdmin，點擊“User accounts”選項卡，選擇“Add user account”，然後填寫用戶名、主機和密碼，在“Database for user”部分勾選“Grant all privileges on wildcard name databases”，並從下拉菜單中選擇特定數(shù)據(jù)庫和表，接著根據(jù)需要僅勾選如SELECT、INSERT、UPDATE、DELETE等必要權(quán)限，最後點擊Go保存設(shè)置，並通過使用新賬戶登錄驗證權(quán)限是否正確配置。

Creating a new MySQL user with specific permissions in phpMyAdmin is a straightforward process, especially if you're managing a website or application that needs controlled database access. You don't need to use the command line — everything can be done through the phpMyAdmin interface.

Here's how to do it step by step.

Accessing the User Accounts Section

To start creating a new user, log into your phpMyAdmin dashboard. Once logged in:

• Look for the "User accounts" tab, usually located near the top of the screen (the exact location may vary slightly depending on your phpMyAdmin version).
• Click on it, and you'll see a list of existing users.

From here, you can either edit an existing account or create a new one. To add a new user:

• Click the "Add user account" button.

This will take you to the user creation form, where you'll set up login credentials and assign permissions.

Setting Up the New User

In the "Add user" form, there are several fields to fill out:

• Username : Choose a clear, unique username for this user.
• Host : This defines which host the user can connect from. If you're unsure, leave it as localhost unless the user will connect remotely.
• Password : Set a strong password using either the text field or the password generator tool provided.

Once login details are set, you can move on to privileges.

Assigning Specific Permissions

This is where you define what the new user is allowed to do in the database. Under the "Database for user" section, check the box labeled:

Grant all privileges on wildcard name databases (eg, dbname.% )

Then choose the specific database and table from the dropdowns below.

You'll also see a long list of global privileges. Don't just click “All Privileges” unless absolutely necessary. Instead, select only what's needed — like:

• SELECT
• INSERT
• UPDATE
• DELETE

If your user only needs to read data, stick to SELECT. If they're managing content, include INSERT, UPDATE, and DELETE. Avoid giving DROP or CREATE privileges unless it's required.

After making your selections, scroll down and click Go to save the changes.

Testing the New User

Once the user is created, it's a good idea to test the permissions:

1. Log out of phpMyAdmin.
2. Log back in using the new username and password.
3. Check if they can access only the assigned database and perform only the intended actions.

If something doesn't work as expected, go back to the User Accounts page and double-check the privileges you granted.

That's basically it. It might seem a bit detailed at first, but once you've done it a couple times, it becomes second nature. Just remember: always grant the minimum permissions needed for the task at hand.

以上是在PhpMyAdmin中創(chuàng)建具有特定權(quán)限的新的MySQL用戶的過程是什麼？的詳細內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！