Skip to main content

Web Server Installation + Database

Installation​

  1. Log in to SSH.
  2. After logging in, run the command:
skillhost

Screenshot: After logging in, run the command:

WARNING:

If you encounter the error curl: command not found, install curl by running:

apt install -y curl

Then repeat step 2.

  1. Enter number 2 and confirm by pressing Enter.
  2. After successful installation, you will receive credentials for the MySQL user and a link to PhpMyAdmin.

Screenshot: After successful installation, you will receive credentials for the MySQL user and a link to PhpMyAdmin.

Congratulations! You have installed your web server and database!

Creating Databases​

  1. Log in to PhpMyAdmin using the link and credentials obtained during installation.
  2. In the left panel, click „New”.

Screenshot: In the left panel, click „New”.

  1. Enter the database name and confirm by clicking „Create”. (You can skip this step if you only need one database — the auto-installer creates the SkillHost database automatically).

Screenshot: Enter the database name and confirm by clicking „Create”. (You can skip this step if you only need one database — the…

  1. External connections are disabled by default!

Congratulations! You have just created your database!

Importing a Database​

  1. Log in to PhpMyAdmin, select the database where you want to import a backup, then go to the „Import” tab.

Screenshot: Log in to PhpMyAdmin, select the database where you want to import a backup, then go to the „Import” tab.

  1. Click „Choose file”, select your database file, then confirm the import by clicking „Go”.

Screenshot: Click „Choose file”, select your database file, then confirm the import by clicking „Go”.

  1. After a successful import, you will see a confirmation message.

Screenshot: After a successful import, you will see a confirmation message.


Congratulations! You have just imported your database! '

Changing PhpMyAdmin Password​

  1. Log in to PhpMyAdmin and go to the „User accounts” tab.

Screenshot: Log in to PhpMyAdmin and go to the „User accounts” tab.

  1. Select the account whose password you want to change and click „Edit privileges”.

Screenshot: Select the account whose password you want to change and click „Edit privileges”.

  1. Click the „Change password” option.

Screenshot: Click the „Change password” option.

  1. Enter the new password twice and confirm by clicking „Go”.

Screenshot: Enter the new password twice and confirm by clicking „Go”.

WARNING:

Make sure that Password Hashing is always set to Native MySQL authentication.

Congratulations! Your password has been changed!