Install PHPMyAdmin for a database service
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.
Moritz Walter
24.12.2021 09:54