Create a database using phpMyAdmin

PhpMyAdmin is a popular tool for managing MySQL databases. You can often find a link to phpMyAdmin in your hosting service interface (or in some cases, to alternative database management tools) or your AMP stack interface. These instructions show how to set up your database using phpMyAdmin.

Overview

Drupal requires access to a database for installation and operation:

1. Start a database checklist with the information your Drupal site will need to access its database.
2. Create a new, empty database.
3. Create a database user account for Drupal.
4. Configure the database user's access privileges.

1. Database Checklist

Write these details down as you go along; you'll need them when installing your website.

1. Database name
2. Database username - The database username, not to be confused with the Drupal username, is the identity that your Acquia Drupal site uses to access its MySQL database.
3. Database password
4. Database host - Advanced setting only - usually "localhost".
5. Database port - Advanced setting only - if your server configuration calls for it.

2. Create a new database

1. Navigate to phpMyAdmin in your browser - in your local AMP stack or hosting interface.

2. Create a new database

   1. Name - Enter a name of your choice in the Create new database field.
   2. Collation: Unicode - In the Collation dropdown, select "utf8_unicode_ci".
   3. Click "Create" - Click Create and you have completed the first step.

   

3. Success - If your database has been created successfully, phpMyAdmin will present you with the following message:

   

3. Create a database user

Now create a user account that is allowed to access your new database. This user exists to give you (and your Drupal site) a secure way to interact with the new database you've created. It is independent from all other logins or accounts that you use to access your computer, your web hosting account, your Drupal site, or anything else.

1. Go to the Privileges page - Navigate back to the phpMyAdmin homepage; make sure that your new database is selected in the left column of the phpMyAdmin interface; click the Privileges link.

   

2. Add a new database user - Click the Add a new User link

   

3. Configure new database user

   1. Enter User name, Host and Password fields (host should read Local in the dropdown and localhost in the textfield). Add all this to your database checklist.

      

   2. Click Go at the bottom of the page:

   3. Success - If your database user has been created successfully, phpMyAdmin will present you with the following message:

      

   4. Stay on this page for the next step in these instructions.

4. Configure database user privileges

Grant user privileges - for the new database only.

1. Select new database - after creating your new database user, select the database that you just created in the Database-specific privileges section of the page. This will take you to the access privileges form for your new user.

   

2. Grant privileges - Click the check boxes for the following privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES, and LOCK TABLES.

3. Click Go to submit the changes.

   

4. Congratulations! You've finished setting up a database for Acquia Drupal to use. You can now move on to the instructions for installing and configuring Acquia Drupal. Make sure to keep your database checklist handy.