asked on

How do I connect to a remote host with PHPMyAdmin?

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?

Dave Baldwin

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.

anAppBuilder

ASKER

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?

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anAppBuilder

ASKER

Thank you again, Dave. That works.

Dave Baldwin

You're welcome!