Databases

Here you will find answers to the most common questions related to Databases, MySQL, and phpMyAdmin.

Create database   
Create or change password for database user   
Access to the MySQL database via phpMyAdmin   
Database export   
Database import   

Create MySQL database

To connect to the database, use localhost as the database server and port 3306
  1. Log in to https://my.servetheworld.net
  2. Click on Products
  3. Click on My Products
  4. Click on Manage next to the relevant web hosting
  5. Click on Databases and then Create database
  6. Fill out the fields and click on Create to complete the setup

You should now have the following information to connect to the MySQL database:

  • Database name
  • Database username
  • Database password
  • Database server name: localhost
       
   

Create or change password for database user

  1. Log in to https://my.servetheworld.net
  2. Click on Products
  3. Click on My Products
  4. Click on Manage next to the relevant web hosting
  5. Click on Databases 
  6. Select the Users tab
    • Click on Create database user to create a user
    • Click on the Edit icon to change the password

Access to MySQL database via phpMyAdmin

  1. Log in to https://my.servetheworld.net
  2. Click on Products
  3. Click on My Products
  4. Click on Manage next to the relevant web hosting
  5. Click on Advanced Settings
  6. Click on Databases
  7. Click on phpMyAdmin

Database export

  1. Log in to https://my.servetheworld.net
  2. Click on Products
  3. Click on My Products
  4. Click on Manage next to the relevant web hosting
  5. Click on Advanced Settings
  6. Click on Databases
  7. Find the relevant database
  8. Click on Export Dump
  9. Make sure to check the box for Automatically download dump after creation
  10. Click on OK
  11. A download of your database backup to your computer will now be initiated.
       
  mysql_plesk_dump_01   mysql_plesk_dump_02

Database import

  1. Log in to https://my.servetheworld.net
  2. Click on Products
  3. Click on My Products
  4. Click on Manage next to the relevant web hosting
  5. Click on Advanced Settings
  6. Click on Databases
  7. Find the relevant database
  8. Click on Import dump
  9. Check the box for Upload a dump from your local computer 
  10. Click on Choose file.. and select your database file
  11. Click on Import Dump to start the import
       
  plesk_db_import_01   plesk_db_import_02