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
- Log in to https://hcp.stwcp.net
- Navigate to Databases in the main menu and select MySQL
- Click Add New Database
- Fill in the fields, see example below.
- Remember to write down the name of the database, username and password
- Click Add to create the database and database user
- After creating the database, click Edit to the right of the database
- 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
- Navigate to Databases in the main menu and select MySQL
- Click the Edit button on the current database
- In the next image you will be able to see a list of database users
- Select Add a new database user
- Fill out the password and record the username
- Select permission (here you can select Write / read if you are unsure)
- Click Add
Change password to existing database user
- Navigate to Databases in the main menu and select MySQL
- Click the Edit button on the current database
- In the next image you will be able to see a list of database users
- Then click Edit at the current database user
- Fill in fields with new password
- Click Save
Access to the database via Phpmyadmin
NB - requires you to know database users and passwords - see the instructions above
- Navigate to Databases and select MySQL in the control panel
- 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
- Navigate to Databases and select MySQL in the control panel
- Select Edit at Current Database
- Click the address of the Webmaster field
- Log in with database username and password
- Click the database name in the menu on the left
- Click Export
- The following settings last for most backup / export:
- Export Method - Quick
- Format - SQL
- Click Run
A backup of your database (.sql file) will be downloaded to your computer.