How do I create a user in MySQL?

Databases: Create MySQL User

Overview

There are two primary steps when creating a MySQL user. The first step is to create a username and password combination for the user. The second step is to add the user to the database you want the user to access.

Steps
  1. In the "New User" section, enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
  2. Next, click on the Create User button.
  3. You should see the following statement:
    • "Added USERNAME with the password PASSWORD."
  4. Click on the Go Back link.
  5. Find the "Add User To Database" section. Select the user you created in Step 6 above from the "User" drop down menu. Then select the database you want to add the user to from the "Database" drop down menu.
  6. Next, click on the Submit button.
  7. When the page loads you will see a two-column table. The top of the table provides a checkbox option "ALL PRIVILEGES" allowing you to create the database with all privileges, otherwise you can check each of the items in the two columns that you want to allow for your new database. The options include:
    • SELECT (Allows USERNAME to select data from a table in the database.)
    • INSERT (Allows USERNAME to insert data into a table in the database.)
    • UPDATE (Allows USERNAME to update data in a table in the database.)
    • DELETE (Allows USERNAME to delete data from a table in the database.)
    • INDEX (Allows USERNAME to create index on table column in the database. This can speed up a database.)
    • CREATE TEMPORARY TABLES (Allows USERNAME to create temporary tables in the database.)
    • CREATE (Allows USERNAME to create tables in the database.)
    • ALTER (Allows USERNAME to alter tables in the database.)
    • DROP (Allows USERNAME to drop tables in the database.)
    • LOCK TABLES (Allows USERNAME to lock tables in the database.)
    • REFERENCES (Allows USERNAME to create references to a table in the database.)

NOTE: Typically you may want to check the "All Privileges" option unless you want specific control over the user you are creating for this database.

  1. Assuming you have either checked the "All Privileges" option or a combination of the options in the two columns, continue the wizard by clicking on the Make Changes button.
  2. You should see the following statement:
    • "User USERNAME was added to the database DATABASE."
  3. Click on the Go Back link.
  4. You should now see the user you created in Step 1 above in the "Users" column.

Was this answer helpful?

 Print this Article

Also Read

How do I delete a user from my MySQL database?

Databases: Delete MySQL UserOverviewThere are two types of deleting users. One way is to delete a...

How do I delete a MySQL database?

Databases: Delete MySQL DatabaseOverviewYou can easily delete a MySQL database from your web...

How do I check my MySQL database?

Databases: Check MySQL DBYou can check to see if your MySQL database is running properly using...

How do I create a MySQL database?

Databases: Create MySQL Database CLICK HERE TO VIEW THE VIDEO TUTORIAL Overview MySQL...

How do I repair my MySQL database?

Databases: Repair DB (MySQL)OverviewYou can repair your MySQL database by using the "Repair DB"...