Tried that, Justin, but MySQL didn't like it - can't use '[EMAIL PROTECTED]'@'dbserver'. So it wasn't that!
I think I'll go away and think about all this over the weekend. Perhaps I don't really need all this hassle, provided that the password for access to the MySQL data is obscure enough.... Cheers Terry ----- Original Message ----- > mysql is a little weird when it comes to permissions > > You may need to use [EMAIL PROTECTED] rather than just username > > Justin > > On Jul 23, 2004, at 3:26 PM, Terry Riley wrote: > > > > > 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]
