Gandi Wiki


Questions

Accessing your database

You can access your Simple Hosting database by the PHPmyAdmin url that is available down in the 'Access' section of your instances' managemet page:

When you click on the link to login, you will first need to enter your Simple Hosting user number and password (the one that you specified). Then you will see the PHPmyAdmin login page:

Note:

By default the PHPmyAdmin user is root and there is no password. So just type in root as the user, leave the password empty, and click on GO.

After you log in for the first time, be sure to use the "change password" link under the "General Settings" section to add a password.

Create your database

Once you have added a password you can now create databases (if you have *just* done this, you may need to log out and log in again, using the new password).

To create a database, go to the "Databases" tab and then choose a name for your database (choose a coding type if you want), and finish by clicking on "Create".

Now you will want to create your users for the database. To do this, use the "Privileges" option once you are in the administration page of the database (click on the name of the database).

Click the link "Add a new User" and fill out the form as desired.

That's it!

Note:

For assistance using PHPmyAdmin, please refer to their documentation at http://www.phpmyadmin.net/home_page/docs.php Gandi's support cannot assist you in using that client.

Importing your database

To import your database (ex. if you are transferring your website to Gandi), simply use the import feature in PHPmyadmin.

If your database is too big, however, you will need to upload its .sql file by SFTP to your /lamp0/tmp directory.

Then you can find the file and import it from PHPmyadmin without encountering any error message due to it being too large.

Questions

RSS feed for questions matching this filter (Help)

Last modified: 31 Jan 2012 at 09:34 by Ryan A. (Gandi)