Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

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
0
johnecollins
Asked:
johnecollins
  • 4
  • 3
  • 2
2 Solutions
 
Dan CraciunIT ConsultantCommented:
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
 
Chris StanyonCommented:
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
 
johnecollinsAuthor Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Dan CraciunIT ConsultantCommented:
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
 
Chris StanyonCommented:
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
 
Dan CraciunIT ConsultantCommented:
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
 
johnecollinsAuthor Commented:
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
 
johnecollinsAuthor Commented:
Hi Chris and Dan

I have now sorted this out using Heidi and would like to thank you both for your help,
0
 
Dan CraciunIT ConsultantCommented:
Glad I could help!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now