Creating a MySQL database and user on Gandi AI via web interface

All database/MySQL tutorials

This guide is for Gandi AI users who have MySQL installed. If you haven't installed a MySQL database yet, do so through the Gandi AI interface before proceeding.

Websites relying on MySQL databases (for instance: WordPress, Drupal, phpBB, Plogger, 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:

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.

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

  • 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 official phpMyAdmin FAQ. Happy reading!

See also

Last modified: 06/04/2013 at 10:54 by Ryan A. (Gandi)