MYSQL privileges System
Hello: I was wondering if anyone had any advice to a couple questions. 1) Can I add additional columns to the user and db tables of mysql. These would be for administrative purposes only. 2) I'm trying to figure out how the privileges effect the system. I understand what each one does, but haven't found a clear explanation of what the difference is in the db table and the user table. If any one can explain this I would appreciate it. 3) I'm looking to come up with the most secure set of privileges for the user and db tables. I want the users to be able to select, insert, delete, create tables, just the basic functions on their database only. Multiple databases are hosted on the same mysql server. Thank you for your help in these questions. Mike Walth CinoFusion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL Privileges
Hello all: I have gone through the documentation, and also the archives, and still can't grasp why things happen with privileges. Here is what I am trying to understand and accomplish. For my own benefit I'm trying ot understand the user and db tables of mysql. If I setup a user with no privileges, but in the db table they have privileges, that user can still select, insert, etc even when it is set to no in the user table. A couple questions I have: What are the differences between the user/db table? Also for the best security what shoudl I set the privileges to for everyone. There are multiple db's on the server, and only one user per db, and they only need the basic privilges, i.e. create tables, select, insert, etc. Your help is greatly appreciated. Mike Walth CinoFusion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP / MYSQL Question
Not sure if this can be done with just a MYSQL Query or if it needs to be done in conjunction with a PHP script. What I am trying to do is build a dynamic FAQ section with PHP. Here are the two tables Topics === TopicID TopicTitle TopicDESC FAQS === FAQID Question Answer Topic I'm trying to get it to display like this Topic1 Question1 Question2 Question3 Question4 Topic2 Question1 Question2 So each topic would be listed with its set of questions below it. Any help would be appreciated. Mike Walth CinoFusion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Join or Group By?
Hello: I'm fairly new to MySQL and think there is an easy query to get what I need done, but not sure how to do it. I thank everyone for their help in advance. I have two tables. Table1: Series SeriesID SeriesTitle Table2: Links LinkID Series LinkTitle I need a query that I can group the links by Series to generate a result similar to: SeriesTitle(1) LinkTitle(1) LinkTitle(2) LinkTitle(3) SeriesTitle(2) LinkTitle(1) LinkTitle(2) LinkTitle(3) Links.Series holds the value of SeriesID that it is under. Thanks again for your help. Mike Walth CinoFusion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting Images in and out of a Blob
Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. Preferred web scripting is ColdFusion, but PHP/PERL would be helpful too. Thank you for your help. Mike Walth CinoFusion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php