asked on

I would like to connect to my wordpress Mysql database

Hello,

I have a Wordpress website and I would like to connect to the MySQL database from my MySQL client on my laptop.

Is this possible and how do I do it?

Thanks

John Collins

Dan Craciun

You need to contact your web host to see if they allow outside connections (most only allow connections from localhost) or if you can establish an ssh tunnel (not likely if you use shared hosting).

HTH,
Dan

Chris Stanyon

As Dan pointed out, you need the database to allow remote connection. In my experience, most DO allow it, although that's specific to the host - you may have to request it.

If they do allow it, simply set up a new connection in your MySQL client. Set the host name to your domain name (not with the www), pop in your username, password (and possibly the database name) and click Connect.

Which client are you using?

johnecollins

ASKER

Hi Dan,

Thank you for the comments it did help thank you.

Hi Chris,

Thanks for your response your contribution always helps.

I have a GoDaddy website and I would like to upload data from my MySQL on my laptop to the MySQL on my website.

I am running MySQL 5.5.24 on my laptop and 5.0.96 on the server.

I phoned GoDaddy and the told me to check phpmyadmin to see if I can remote connect. They have also sent some information for me about remote connecting so that is most helpful and hopefully I won't be asking any more questions maybe ;-)

I Googled ODBC and found there is a MyODBC , I have some experience using ODBC in the dim and distant past. If I can remote connect do I just use ODBC and it will look like a database on my laptop?

Thanks for your responses

John

ASKER CERTIFIED SOLUTION

Dan Craciun

membership

This solution is only available to members.

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

Start Free Trial

SOLUTION

Chris Stanyon

membership

This solution is only available to members.

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

Start Free Trial

Dan Craciun

You'll need the community edition if you want to use SQLYog but don't want to buy the full version. The files are here: https://code.google.com/p/sqlyog/downloads/list

johnecollins

ASKER

Hi Chris and Dan,

Sorry dragged off to another project and back again ;-)

Why ODBC? I was , ooking forward to a technology that I could feel comfortable with because of relevant experience.

I am exporting the current data to the web MYSQL and it won't be a regular thing but a working technology would be extremely valuable.

Heidi, MYSQLYog more new technology, oh well onwards and upwards.

Thanks for your help and advices I will investigate.

John

johnecollins

ASKER

Hi Chris and Dan

I have now sorted this out using Heidi and would like to thank you both for your help,

Dan Craciun

Glad I could help!