Install PHPMyAdmin for a database service

Moritz Walter
Moritz Walter 24.12.2021 10:54

Requires:

  • 1 database server
  • 1 webspace

**Step 1

Create a domain/subdomain at the webspace e.g. phpmyadmin.example.com

Step 2

Delete the default files from the created domain/subdomain

Step 3

Download PHPMyAdmin from https://www.phpmyadmin.net/downloads/.

Step 4

Unzip the files in the folder of the domain/subdomain

Step 5

Rename the config.sample.inc.php to config.inc.php

Step 6

Open the config.inc.php set ``$cfg['Servers'][$i]['host'] to the IP address of the database e.g.$cfg['Servers'][$i]['host'] = '37.114.32.0'; ```

Add $cfg['Servers'][$i]['port'] ``` with the port of the database. e.g.$cfg['Servers'][$i]['port'] = '3307'; ```

Step 7

Go to the console of your database

Log in with mysql -u root there

Execute the following commands First replace 'newuser' with your desired username and PASSWORD with your desired password.

  • CREATE USER 'newuser'@'%' IDENTIFIED BY 'PASSWORD';
  • GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%';
  • FLUSH PRIVILEGES;

Step 8

Log in under your domain/subdomain.



It did not work? Contact support, we will help you.