Creating a MySQL database and user on Gandi AI via web interface
← All database/MySQL tutorials
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.
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!