Accessing a MySQL Database via SSH

Please Note:

The text on this page was translated by translation software. A revised version from our editors will be available soon.

For managed servers

This article explains how to connect to a MySQL database running on your server.

Step 1

Establish an SSH connection to your server.

You will find the access data in your 1&1 IONOS under the item MySQL.

Step 2

The following command line establishes an example connection to the MySQL database running on the server.

MySQL 5.1
mysql --host=localhost --user=dbo123456789 --password=******** -S /tmp/mysql5.sock db123456789
MySQL 5.5
mysql --host=localhost --user=dbo123456789 --password=******** db123456789

Replace the user, password and database name (dbxxxxxxxx) with the access data of your database.