====== Creating a MySQL database and user on Gandi AI via web interface ======
**<- [[en:hosting:using-linux:tutorials:ubuntu#mysql-topics|All database/MySQL tutorials]] **
----
<note> This guide is for Gandi AI users who have MySQL installed. If you haven't installed a MySQL database yet, do so through [[en:hosting:gandi-ai:manage|the Gandi AI interface]] before proceeding.</note>

Websites relying on MySQL databases (for instance: [[en:hosting:tutorials:wordpress :ai|WordPress]], [[en:hosting:tutorials:drupal::ai|Drupal]], [[en:hosting:tutorials:phpbb::ai|phpBB]], Plogger, [[en:hosting:tutorials:gallery2:ai|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 your Gandi AI server**.

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-database-conf.png?nolink |}}

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>
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>

===== See also =====
  * [[en:hosting:using-linux:tutorials:ubuntu:createdatabase]]
  * [[en:hosting:create-server:gandi-ai:database-configuration]]