Site5 Q&A » Accessing mySQL databases through Workbench

Accessing mySQL databases through Workbench

In: MySQL Asked By: msli_barry [2

] Tags: MySQL, ssh, workbench

Hi,

To speed up development I want to access all SQL databases on a domain we have running.

Am I right in assuming its standard TCP/IP over SSH?

I need the SSH Hostname and port..
And I assume SQL Hostname is 127.0.0.1/Localhost?

What port do they run on? 3036? Or 2083?

Looking at phpmyadmin the username is {accountname}@localhost?

1 Answer Answer this Question Now

Mar 26, 2016

Answer #1

Hello,

The SSH hostname would be your domain name, on port 22. SQL runs locally, so 127.0.0.1 or localhost would be perfect there, on port 3306. The PHPMyAdmin login should be the same as your SiteAdmin login credentials.

Answered By: jdavey [359

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »