For Web Hosting and IONOS Managed Server

is a web application for MySQL database administration. You can reach phpMyAdmin via the IONOS.

Prerequisites

Your contract must include a MySQL database.

There is a mismatch between HTTPS indicated on the server and client. This can lead to a non working phpMyAdmin or a security risk. Please fix your server configuration to indicate HTTPS properly.

1. There is a mismatch between HTTPS indicated on the server and client. This can lead to a non working phpMyAdmin or a security risk. Please fix your server configuration to indicate HTTPS properly.
2. Read the Docs v: latest. Versions latest release510 release504 release503 release502 release501.
3. PhpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. PhpMyAdmin supports a wide range of operations with MySQL.

Step 1

Log in to the and select the appropriate contract.

Step 2

Select MySQL Database from the left menu bar under My Products.

Step 3

Under phpMyAdmin, click Open next to the database you want to edit.

Phpmyadmin Incorrect Format Parameter

A new window with the phpMyAdmin start page opens. You can now administer your MySQL database.

Please note: Changes you make in phpMyAdmin become active immediately and cannot be undone. Therefore, be particularly careful with the Delete and Empty functions.

Tip: Create bookmarks for browsers

You can create a bookmark to open your database directly in phpMyAdmin. To do this, click Bookmarks on the MySQL Databases overview page next to the desired MySQL database and then copy the link that appears.
Please note: Create a new bookmark directly in your browser with this URL as the address. Otherwise the bookmark will not work.

For security reasons, phpMyAdmin is accessible only when using 127.0.0.1 as the hostname. To access it from a remote system, you must create an SSH tunnel that routes requests to the Web server from 127.0.0.1. This implies that you must be able to connect to your server over SSH in order to access these applications remotely.

IMPORTANT: Before following the steps below, ensure that your Web and database servers are running.

NOTE: The steps below suggest using port 8888 for the SSH tunnel. If this port is already in use by another application on your local machine, replace it with any other port number greater than 1024 and modify the steps below accordingly. Similarly, if you have enabled Varnish (TM) or HTTPS redirection, your stack’s Web server might be accessible on port 81 (Varnish (TM)) or port 443 (SSL). In this case, modify the steps below to use ports 81 or 443 respectively instead of port 80 for the tunnel endpoint.

Access phpMyAdmin on Windows

Watch the following video to learn how to easily access phpMyAdmin on Windows through an SSH tunnel:

TIP: Refer to these instructions to learn how to obtain your private key.

In order to access phpMyAdmin via SSH tunnel, you need an SSH client. In the instructions below we have selected PuTTY, a free SSH client for Windows and UNIX platforms. The first step is to configure PuTTY. Find out how to configure PuTTY.

Once you have your SSH client correctly configured and you have confirmed that you can successfully access your instance using SSH, you need to create an SSH tunnel in order to access phpMyAdmin. Follow these steps:

• In the “Connection -> SSH -> Tunnels” section, add a new forwarded port by introducing the following values:

  • Source port: 8888
  • Destination: localhost:80

  Remember that if you are redirecting HTTP requests to the HTTPS port, you must use destination port 443 instead of 80.

  This will create a secure tunnel by forwarding a port (the “destination port”) on the remote server to a port (the “source port”) on the local host (127.0.0.1 or localhost).

• Click the “Add” button to add the secure tunnel configuration to the session. You’ll see the added port in the list of “Forwarded ports”.

• In the “Session” section, save your changes by clicking the “Save” button.

• Click the “Open” button to open an SSH session to the server. The SSH session will now include a secure SSH tunnel between the two specified ports.

• Access the phpMyAdmin console through the secure SSH tunnel you created, by browsing to http://127.0.0.1:8888/phpmyadmin.

• Log in to phpMyAdmin by using the following credentials:

  • Username: root
  • Password: application password. (Refer to our FAQ to learn how to find your application credentials).Here is an example of what you should see:

If you are unable to access phpMyAdmin, verify that the SSH tunnel was created by checking the PuTTY event log (accessible via the “Event Log” menu):

Access phpMyAdmin on Linux and macOS

To access the application using your Web browser, create an SSH tunnel, as described below.

Phpmyadmin Localhost Download

• Open a new terminal window on your local system (for example, using “Finder -> Applications -> Utilities -> Terminal” in macOS or the Dash in Ubuntu).

• Make sure that you have your SSH credentials (.pem key file) in hand.

• Run the following command to configure the SSH tunnel using the SSH key file. Remember to replace KEYFILE with the path to your private key and SERVER-IP with the public IP address or hostname of your server:

  Remember that if you are redirecting HTTP requests to the HTTPS port, you must use destination port 443 instead of 80.

  NOTE: If successful, the above command will create an SSH tunnel but will not display any output on the server console.

• Access the phpMyAdmin console through the secure SSH tunnel you created, by browsing to http://127.0.0.1:8888/phpmyadmin.

• Log in to phpMyAdmin by using the following credentials:

  • Username: root
  • Password: application password. (Refer to our FAQ to learn how to find your application credentials).

Phpmyadmin Login

Here is an example of what you should see: