What is the best way to access SQL database for maintenance

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Paradox187x
Forum Newbie
Posts: 7
Joined: Mon Jul 20, 2009 6:24 am

What is the best way to access SQL database for maintenance

Post by Paradox187x »

Hi All

I've FINALLY finished my first PHP & MySQL database website, with NO prior programming experience :bow:

BUT.............. It's not hosted yet. I need to write one last program/page to enable editing/maintenance of the data.

The site is designed to allow users to post new records into a database which is later searched upon. They cannot post in all the fields, only some. I need some sort of secure method allowing me to remove/edit/update individual records as required (like you can do in phpMyadmin) when it's stored locally.

While you'd limit the privileges for normal site operation to SELECT & INSERT, I'm guessing you'd create another with ALL if not most privileges.

QUESTION
Is the best method of editing a database by the admin maintenance guy through a Username logon link on the site itself?
OR
Do you use a program specifically for database maintenance to limit the risk of the logon method being hacked?
OR
Are there other database maintenance methods?
Eric!
DevNet Resident
Posts: 1146
Joined: Sun Jun 14, 2009 3:13 pm

Re: What is the best way to access SQL database for maintenance

Post by Eric! »

Paradox187x wrote:BUT.............. It's not hosted yet. I need to write one last program/page to enable editing/maintenance of the data.

...I need some sort of secure method allowing me to remove/edit/update individual records as required (like you can do in phpMyadmin) when it's stored locally.
Depending on your chosen host, you can use phpmyadmin remotely as well. Otherwise you will need to create a secure area with code that allows you update/drop data with an authorized user. There are a couple of ways to make the area secure depending on your host and the methods you want to use. However if you're happy with phpmyadmin it will save you some time.
Post Reply