You may want to assign more than one login name and password to a database. To add users to your database, follow these two steps: 1. From the database menu, click on the name of the database you want to change. 2. Click on the “Create New Database User” link at the top of your screen. 3. Enter a username and a password and click on the “Create” button.
You can see how many users each database has from the MySQL databases menu.
Deleting Users from a Database
To delete database users, you must first click on the database name from the MySQL databases menu. In this example, we clicked on the “username_chat” database, which has two users (see image above).
The username_chat database has two users: username_chat (the username is the same as the database name) and username_gary2. To delete a database user, check the box next to the name and click the “Delete Selected” key.
