Adding Users to a Database  Print this Article

There may be times when you want to have more than one login name and password assigned to a database.  To add additional users to a database, follow these steps:

 

1.  From the main database menu, click on the name of the database you want to modify.

2.  Click on the "Create New Database User" link at the top of the screen.

3.  Enter a username and password and then click the "Create" button.

 

 

You can see how many users each database has from the main MySQL databases menu.

 

Removing Users from a Database

 

To remove database users, first click on the database name from the main MySQL databases menu.  In this example we have clicked on the "username_chat" database, which has two users (see above picture).

 

 

The username_chat database has two users: username_chat (the username is the same as the database name) and username_gary2.  To delete the database user, simply check the box next to its name and click the "Delete Selected" button.

Was this answer helpful?

Related Articles

Creating Databases
From the main control panel menu click the "MySQL Databases" icon and then click the "Create new...
Removing Databases
  A list of all databases is present in the main MySQL databases menu.  To delete a...
Changing Database Passwords
To change a database password, first click on the name of the database in the main MySQL...
Accessing phpMyAdmin
phpMyAdmin is a tool written in PHP that allows you to administrate your MySQL databases. ...
Setting Up Your Database with Scripts
Most scripts need to know four things about your database: the database name, database username,...