Creating a MySQL database with phpMyAdmin

From Tech-Help

Creating a MySQL database with phpMyAdmin is easy, but there are a few tricks to know in the sequence of creation that will make your life easier.

Contents 1 1. Select Privileges 2 2. Create a new user 3 3. Create database 4 4. Set Privileges 5 5. Create Everything

1. Select Privileges

2. Create a new user

On the User Overview page, scroll down and click on the "Add a new user" link.

• Use the same name as the database you want to create, at the host localhost
• When entering the password, do NOT click "Generate Password".

3. Create database

• Check "Create database by the same name"

4. Set Privileges

• For global privileges, check all the Data and Structure privileges.
• Leave the Administration privileges unchecked -- these should be reserved for only users who administrate databases across the entire MySQL installation.

5. Create Everything

• Click the "Go" button on the lower right of the page.

• Return to the User overview page and click on the "Reload privileges" link on the main page.