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]
