Databaser

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

Create MySQL database
Find / Create MySQL Database User
Change password to existing database user
Access to the database via Phpmyadmin
Retrieve database backup via Phpmyadmin / Export database

Create MySQL database

  1. Log in to https://hcp.stwcp.net
  2. Navigate to Databases in the main menu and select MySQL
  3. Click Add New Database
  4. Fill in the fields, see example below.
    • Remember to write down the name of the database, username and password
  5. Click Add to create the database and database user
  6. After creating the database, click Edit to the right of the database
  7. In the next image, note down hostname / server name (database access hostname)

You will now be left with information to connect to the MySQL database with, for example, your webpage:

  • Database Name
  • Database username
  • Database password
  • Database hostname / server name

Find / Create MySQL Database User

  1. Navigate to Databases in the main menu and select MySQL
  2. Click the Edit button on the current database
    • In the next image you will be able to see a list of database users
  3. Select Add a new database user
  4. Fill out the password and record the username
  5. Select permission (here you can select Write / read if you are unsure)
  6. Click Add

Change password to existing database user

  1. Navigate to Databases in the main menu and select MySQL
  2. Click the Edit button on the current database
    • In the next image you will be able to see a list of database users
  3. Then click Edit at the current database user
  4. Fill in fields with new password
  5. Click Save

Access to the database via Phpmyadmin

NB - requires you to know database users and passwords - see the instructions above

  1. Navigate to Databases and select MySQL in the control panel
  2. Click the address of the Webmaster URL

Retrieve database backup via Phpmyadmin / Export database

NB - requires you to know database users and passwords - see the instructions above

  1. Navigate to Databases and select MySQL in the control panel
  2. Select Edit at Current Database
  3. Click the address of the Webmaster field
    • Log in with database username and password
  4. Click the database name in the menu on the left
  5. Click Export
  6. The following settings last for most backup / export:
    • Export Method - Quick
    • Format - SQL
  7. Click Run

A backup of your database (.sql file) will be downloaded to your computer.