Using phpMyAdmin For Administration

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
User avatar
seodevhead
Forum Regular
Posts: 705
Joined: Sat Oct 08, 2005 8:18 pm
Location: Windermere, FL

Using phpMyAdmin For Administration

Post by seodevhead »

Just wanted to ask you guys if there is anything wrong (and by wrong I really mean... is it acceptable for a professional) to just use phpMyAdmin to administer your web applications... such as deleting records, editing records, inserting records, etc.... as opposed to making your own front-end php app to do those administrative tasks?

Also, one question I am a bit unsure of... if you use the INSERT or editing capabilities of phpMyAdmin and type in your data into the input fields... does phpMyAdmin automatically escape any data that is sent to MySQL, or do I need to type it with the backslashes with anything that will cause a SQL hiccup? Thanks for your help.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

The only thing wrong is making sure to place it in a place that will not be easily guessed and that it doesn't log in with root privileges. I'll even go as far to say as you should configure it to require the login credentials of the user you wish to use.. not even storing the log in information in its configuration.
Post Reply