distal-attribute
distal-attribute
distal-attribute
distal-attribute

Getting Started

User, date Message
Written by snowrat
3 years ago
Category: Creating a connection
3 posts since Mon, 13 Jun 11
Hi All
Is there a getting started guide anywhere?
I am trying to connect to a back up of a Wordpress database I have stored locally.
I am also trying to connect to an online Wordpress database but not managing to get the settings working.
Any help/pointers appreciated.
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
No tutorial here I'm afraid. Most stuff should be intuitive. Perhaps you can ask more specific and I'll answer?
Written by snowrat
3 years ago
3 posts since Mon, 13 Jun 11
Thanks..
What are the steps for making a new connection to a locally stored mysql database back up?
For connecting to an online functioning Wordpress database..
is the ip address the ip of the website where the WP blog is located?
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
The IP is often the same as the one used on the webserver, at least on mass hosting systems this is mostly the case when the server runs on the same machine.

I guess with a "local back up" you mean you have installed MySQL on your desktop pc, which then requires you to connect to localhost. Default user is often root with an empty password, but that can have changed by yourself within the installation process.
Written by kalvaro
3 years ago
595 posts since Thu, 29 Nov 07
Please forgive me if I'm saying something you already know, but HeidiSQL is not a standalone program: it's only a graphical tool to connect to a third-party application called MySQL Server. As such, it's pretty intuitive for anyone who's familiar with MySQL since it basically reuses all its concepts: server, user, password, database, table... For further reference, you can have a look at the official manual or Google for a MySQL tutorial.

As about your online database, my experience with hosting providers tells me that they don't normally allow remote access by default. If you are given such feature, you need to create a remote user in whatever control panel they use. Their help/support service is probably your best chance.
Written by snowrat
3 years ago
3 posts since Mon, 13 Jun 11
Thanks for the info. Will try again to connect to both versions
 

Please login to leave a reply, or register at first.