Get free months of hosting with every new annual plan! Click here and learn more.

Call us +1-231-421-7160

Accessing a MySQL Database Remotely

At times you may want to access the database for your Joomla or WordPress site. Any kind of MySQL 5.X client can be used to connect to MySQL on our platform remotely. This article explains how to access the MySQL database for your Joomla site using various operating systems. 

Remote MySQL Access Using Linux

Remote MySQL Access Using Windows

MySQL Login Credentials

Remote MySQL Access Using Linux

Using the Linux OS this is traditionally done using a MySQL command line tool. There are two resources below that can help you learn how to access the database using Linux.

How to connect to MySQL using command line and PHP

MySQL on Linux Tutorial

It is also possible to use the MySQL Workbench client that is described in the next section.

Remote MySQL access using Windows

The MySQL Project recommends that Windows users use the MySQL Workbench client to access their database remotely. There is a forum through the MySQL Developer Zone that can assist with any questions you may have, and there are many reference manuals through the MySQL Documentation that are helpful as well. 

There are some other commercial graphical clients that can be used to access a database remotely for Linux and Windows operating systems.

HeidiSQL

Toad for MySQL

SQLyog

DbVisualizer

Back to Top

MySQL Login Credentials

You can access this information by logging into your CloudAccess.net Cloud Control Panel™(CCP). Once in the CCP, select the Jsite that you'd like to work with at the top of the page and then click on the "Database" icon below.

mysqlremote1

In the MySQL area, you can clik on the "Login to PHPMyAdmin" button to access your database. You'll also be able to access your host name, database name, port, username and password in this area.

mysqlremote2

You will need following information to connect to your database.

  • the host name – same as domain name
  • the user name and password (Joomla/WordPress back end log in credentials)
  • the database name – same as user name.

Back to top

Do you have suggestions for improving this article?  

We take a great deal of pride in our knowledgebase and making sure that our content is complete, accurate and useable. If you have a suggestion for improving anything in this content, please let us know by filling out this form. Be sure to include the link to the article that you'd like to see improved. Thank you!