Managing Database Users

You can access any database on your server with the default database name and password. However, if you want to control a user’s access to the database, then you’ll want to create a unique user account for them to use.

This article explains how to do this in your DirectAdmin control panel.

Once they have an account, they can log in at ‘https://yourserver.vacares.com/phpmyadmin/’.

Adding a User to a Database

1. Log in to DirectAdmin control panel.
2. Under the MySQL Management menu select Manage Databases.
3. Click on the name of the database you want to add a user to.
4. Click “Create New User”.
5. Enter a username and a password.
6. Click “Create”.

Note: By default new users have access to all database privileges except “Grant”.

Modifying User Privileges

1. Log in to DirectAdmin control panel.
2. Under the MySQL Management menu select Manage Databases.
3. Click on the name of the database.
4. Click “Modify Privileges” for the user you wish to modify.
5. Select which privileges to give to the user.
6. Click “Change”.