Managing Database Users

Database User Administration

Database users control access to your MySQL databases. Each user can be assigned specific privileges that determine what operations they can perform. Proper user management is important for both security and functionality.

Creating a Database User

A database user is typically created along with a new database. However, you can also create additional users:

1. Log in to DirectAdmin and go to MySQL Databases.
2. Click on the database you want to add a user to.
3. Look for an option to Add User or Create User.
4. Enter the username and password for the new user.
5. Select the privileges to grant (see below).
6. Click Create or Save.

Understanding Database Privileges

Common MySQL privileges include:

• SELECT - Read data from tables.
• INSERT - Add new rows to tables.
• UPDATE - Modify existing data in tables.
• DELETE - Remove rows from tables.
• CREATE - Create new tables and databases.
• DROP - Delete tables and databases.
• ALTER - Modify table structures (add/remove columns).
• INDEX - Create and remove indexes on tables.
• ALL PRIVILEGES - Grants all available privileges.

Assigning a User to a Database

If you have created a user separately from a database, you need to link them:

1. Go to MySQL Databases in DirectAdmin.
2. Select the database.
3. Choose the user from the available users list.
4. Select the privileges to grant.
5. Click Add User to Database or Save.

Changing a Database User Password

1. Navigate to MySQL Databases.
2. Find the user in the list and click Change Password (or click the user name).
3. Enter and confirm the new password.
4. Click Save.