Accessing Online (remote) MySQL DB to modify it

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,752 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,534 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 2888 | Replies: 1

•

Join Date: Jun 2005

Location: Cape Town, South Africa

Posts: 1

Reputation: BooGiE_MaN is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

BooGiE_MaN BooGiE_MaN is offline

Offline

Newbie Poster

Accessing Online (remote) MySQL DB to modify it

Jun 24th, 2005

Hi MySQL Boffs,

I have been given resposibility to adminster our my company's website.
We use a Content Management System.

I would like to add abilities to it such as a Meta Tag & Title field for new pages I create

I have started self-teaching myself PHP & MySQL on my local computer using WAMP server and using Dreamweaver to edit pages.

I manage to connect to the published database with DreamWeaver, but I need to modify the tables in the database

>>>>> BOTTOM LINE
How can I manage the database if it is already on the web???
Do I use a program?? Which One??

Help!!

Thanks in advance,
John
Eiledon Solutions
www.eiledon.co.za

•

Join Date: Jun 2005

Location: Planet Earth

Posts: 26

Reputation: darklordsatan is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

darklordsatan darklordsatan is offline

Offline

Light Poster

Re: Accessing Online (remote) MySQL DB to modify it

Jun 28th, 2005

Simple answer my friend, if you have a shell account, you could just log in and change stuff, but since you have a content management system (please, please tell me its not cPanel), then all you need to do is install in your webspace a web-based frontend for mysql.
Try the awesome phpMyAdmin , free and open source. You only need to change some connection parameters in one of the scripts (dont recall which one, just read the installation instructions), and thats it, upload it through ftp or whatever you have at hand, and get ready to administer your DB easily, from the web

cheers