How do I connect to a remote host with PHPMyAdmin?

anAppBuilder
anAppBuilder used Ask the Experts™
on
I have a website using MySQL.  I need to be able to login to it remotely using PHPMyAdmin.  My hosting company says this is possible using remote access and I have enabled remote access from the website.  I have installed PHPMyAdmin on my PC.  How to I point it to MySQL on my website?

Assume that my
mySQL host is www.mywebsite.com:1234
database name is myweb_mynameDB
user is myweb_myname
password is mypwd

What file do I edit or what do I type in to PHPMyAdmin to see my database?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
Edit the 'config.inc.php' file and add another server section with the info for your remote server.  Copy the entire ['Servers'] array including the i++; and make a second section below the first.

Author

Commented:
Thank you, Dave.

I'm now getting this error, "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) "

My file looks like this:
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'http://www.mysite.com:2083';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'myweb_myname';
$cfg['Servers'][$i]['password'] = '<the password>;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Any further suggestions?  Where do I specify the database?
Fixer of Problems
Most Valuable Expert 2014
Commented:
You can't use 'http' to get to the MySQL server and the port on the end of the URL won't get you there either.  '2083' is usually a control panel.  'host' should be the same name that you use in your PHP scripts to access your database.  It is not necessarily your domain address.
My file looks like this:
$i++;
$cfg['Servers'][$i]['verbose'] = 'mysite';
$cfg['Servers'][$i]['host'] = 'www.mysite.com';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'myweb_myname';
$cfg['Servers'][$i]['password'] = '<the password>;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Open in new window

Author

Commented:
Thank you again, Dave.  That works.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
You're welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial