Solved

I would like to connect to my wordpress Mysql database

Posted on 2014-03-24
9
604 Views
Last Modified: 2014-04-17
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
0
Comment
Question by:johnecollins
  • 4
  • 3
  • 2
9 Comments
 
LVL 34

Expert Comment

by:Dan Craciun
Comment Utility
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
0
 
LVL 42

Expert Comment

by:Chris Stanyon
Comment Utility
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?
0
 

Author Comment

by:johnecollins
Comment Utility
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
0
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 250 total points
Comment Utility
It's quite a step up from MySQL 5.0.96 to 5.5.24. Make sure you backup your data before doing anything.

I would not bother with ODBC. You have Heidi which is free, fast and easy to use.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 42

Assisted Solution

by:Chris Stanyon
Chris Stanyon earned 250 total points
Comment Utility
Why do think you need ODBC?

You're using mysql, php and wordpress, so if you're doing this in code then just use the PHP mySQL libraries - PDO or mySQLi

Are you just wanting to copy the data from your laptop to your webserver en-masse.

I use a mySQL client called mySQLYog - I can open up a connection to my local server and a connection to my remote server and then just tell it to copy the tables (with or without data) between the 2 - no commands or SQL statements needed.
0
 
LVL 34

Expert Comment

by:Dan Craciun
Comment Utility
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
0
 

Author Comment

by:johnecollins
Comment Utility
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
0
 

Author Closing Comment

by:johnecollins
Comment Utility
Hi Chris and Dan

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

Expert Comment

by:Dan Craciun
Comment Utility
Glad I could help!
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
In order to have all security and back ups taken care of, WordPress users can sign up for services with WP Engine.
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now