Home » Categories » Multiple Categories

How do I connect to MySQL databases through SSH?

You can log into the server through SSH, and once you are in the system, you can access your MySQL databases directly with the following command:

mysql -h [serverip] -u [username] -p [databasename]

[serverip] – The server’s IP address, which you can find in the ‘MySQL Databases’ section in your eXtend Control Panel

[username] – Your username

[databasename] – The database’s name

You will then be prompted to enter in the database’s password. Once you have logged into the database, you will be at the MySQL prompt.

For more information on the commands you can use in the MySQL prompt, please refer to the MySQL Documentation: http://dev.mysql.com/doc/

1 (3)
Article Rating (3 Votes)
Rate this article
  • Icon PDFExport to PDF
Related Articles
Create a new WordPress admin user in the database
Added on Wed, Jun 3, 2020
How to change your MySQL database password
Added on Wed, Sep 28, 2022
How do I update the database password within my configuration file?
Added on Thu, Sep 29, 2022
How can I manage my MySQL database?
Added on Thu, Feb 26, 2015
How can I upload my MySQL database?
Added on Thu, Feb 26, 2015