Terry, a couple of ideas here, I`m assuming you are not working locally but remotely
Du Bois 'MySQL' book is handy also a copy of mysql Front as a gui. Assuming you want to connect from a remote address, check mysql is running, use /etc/rc.d/init.d/mysql start if running mysql> grant all on *.* to [EMAIL PROTECTED] identified by "newpaswd" with grant option; if using windows, use ipconfig at dos prompt to give your serverIP If the above sticks, enter the remote ip address of mySQL in mySQL Front, username and paswd above , remote port 3306, you can then set permissions on tables etc from within mySQL, or if you have set up webmin you can do this from webmin as well. You can refine/filter user permissions and create new users using syntax: Grant privileges (columns) On what To user IDENTIFIED BY 'passwd' WITH GRANT OPTION check Du Bois on managing user accounts as well and test these by setting up different accounts in mySQL Front Assuming these are working I`d set up a unique connection to a new mysql datasource for each user with their own passwd/username in CF MX rather than try passing this info on cfquery. Colm -----Original Message----- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 23 July 2004 15:26 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CF and MySQL premissions I'm having problems with figuring out how this would work on CFMX6.1 (with MySQL 4.1.3 beta). Perhaps some kind person with experience of MySQL/MX, could advise on this lovely Friday afternoon. In CFAdmin, when the database is registered, you give a username and password, and the only one which seems to work here is the root user and password (ie superuser) set in MySQL, which is fair enough if you want to grant all users on your site access to all db functions. But naturally, one doesn't want to do that. So I tried creating another entity (webuser) with an appropriate password, that has only 'select' privileges, within MySQL. But if I use this username/password in a cfquery, it is naturally rejected (are you sure you've got MySQL server running on 3306?'), no doubt because it is expecting the initial registered username/password combination (which works, of course). What I'd like to set up is a set of 'accounts' in which superuser has all privs, 'webuser' has select only, and 'webadmin' has select, update, insert, delete privileges. The application concerned is not one in which logging in just to view data is an option. Logging in to do admin work, however, is required. Anyone know how this is done with MySQL? Am I on a hiding to nothing with this? Is my brain fried? Cheers Terry -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 0430-2, 21/07/2004 Tested on: 23/07/2004 15:58:59 avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
