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 (help) before pursuing.

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.

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.

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

Gandi Docs

Creating a MySQL database and user name

How to do it?

Creating your databases

Questions