• Help & contact

    For Linux Web Hosting and all servers with Linux operating systems

    You may find it useful to test statements that will later be executed by a script in the command line environment beforehand. To access your database from the command line, follow these steps:

    • Log in to your hosting package or server through SHH.
    • Depending on the type of package you are using, enter the respective command from the table below. Make sure you replace the sample data with your database's connection data:
    Product Command
    Managed Server on which MySQL 5.7 / 8.0 or MariaDB is installed and Web Hosting (Shared Hosting) mysql -u dbo123456789 -h db123456789.hosting-data.io -p db123456789
    Managed Server on which MySQL 5.5 is installed mysql -u dbo123456789 -h localhost -S /tmp/mysql5.sock -p db123456789
    Servers (without Plesk) mysql -u root -p
    Servers (with Plesk) mysql -u admin -p
    Please Note
    • The commands are to be entered without a line break and not as shown in the table. The representation with line breaks is only due to the table format.
    • On servers with Plesk, the administrative database user has been renamed from root to admin. However, the password corresponds to the initial password of the server (root password).

    • Log in to your database.

    Here is an example of a server with Plesk:

    login as: root
    root@74.208.111.111's password:
    [root@u15376217 ~]# mysql -u admin -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 9342
    Server version: 5.5.14 MySQL Community Server 5.5 (GPL)
    
    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> 
    bash

    You can now perform database operations through the command line interface.