Adding Users to a Database

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: mysql add user

  1. From the main database menu, click on the name of the database you want to modify.
  2. Click on the "Create New User" or "Add Existing User" button at the right of the screen.
  • If creating a new user, enter a username and password and then click the "Create" button.
  • If adding an existing user, select wanted user and click the "Assign" button.

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

mysql add new user
mysql add existing user

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Creating Databases

To create a database, sign into the control panel and then click on the "Account Manager" icon,...

Removing Databases

To find a list of all databases in MySQL, go to the main databases menu. If you want to delete...

Removing Users from a Database

To remove database users, first click on the database name from the main MySQL databases menu. In...

Changing Database Passwords

To change your database password, follow these steps:1. Go to the main MySQL databases menu and...