Skip to main content

Web Server Installation + Database

Installation

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

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.

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”.

  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).

  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.

  1. 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.


Congratulations! You have just imported your database! '

Changing PhpMyAdmin Password

  1. 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”.

  1. Click the „Change password” option.

  1. 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!