====== Creating a MySQL database and user name ======

<note> This guide is for Gandi AI users who have a MySQL database installed. If you haven't installed a MySQL database yet, you can do so through the Gandi AI interface ([[en:hosting:gandi-ai:manage|help]]) before pursuing.</note>

Websites relying on MySQL databases (for instance: phpBB, Blogger, Gallery2, etc...) need access to a database in order to function.

If you want to set up a blog on your site, for example, you can (and are strongly advised!) to create a specific database for that purpose.


=== How to do it? ===

In the Gandi AI interface, go into the **Servers** section and click on the name of the server concerned.

Under the **System administration** headline, click **manage**.

Then, click **configure** next to the **phpmyadmin** module.

=== Creating your databases ===

Now that you are in the management interface for your **Database server**, ensure you are set in the **Advanced server administrator mode** as opposed to Easy mode (don't panic!). Under the **database** section, click **Create**.

You should see the following fields:

{{ en:hosting:gandi-ai:ai-createdb-en.png }}

Four indications will be needed:

  * The **name** of the database: "blog", "forum", "gallery", for example.
  * The **user name** for the database: choose a name for the user who will have access and will be able to manage the content of the database.
  * The user's **password**: the associated password.
  * The **rights** you wish to grant to the database user: by default, pick **all**.

Done! You can now **Submit**.

<note warning>
The number of simultaneous connections to the apache database is limited to 10
</note>

<note>
Now that you have created your database, you will perhaps need to manage its content later. To do so, you need to go to the following address //%%www.yourwebsite.com/phpmyadmin%%//:

  *If you wish to access it as the general administrator, the user name is **admin**, and the password is the one you had defined during the server's creation.

  *If you wish to login with a specific database's user, the user name and the password are therefore the ones you had defined during the creation of that database.

**For very complete information on the use of phpmyadmin, I recommend you check the [[http://www.phpmyadmin.net/documentation/#faqusing|official phpmyadmin FAQ]]. Happy reading!**
</note>