I solved the problem of not being able to register the DSN - it was all tied up with the passwords - they had initially been set using the new MySQL 4.1.3 default, which is 41 chars, then, because we had older (16-char) passwords to accomodate, MySQL was restarted with the --old-passwords option.
Although both the new and old passwords would work with MySQL directly, and with SQLyog GUI, they wouldn't work with CFMX, for some obscure reason. (And yes, for all the gurus out there, I'm aware of the wee proggy you're supposed to run to upgrade old passwords to new - I just haven't run it yet, which is just as well!) Killed the users with the 'new' passwords, redid them as 'old' 16-char passwords, and Robert's your mother's brother - three separate DSNs! So it would appear to be a case of MM not yet having caught up with MySQL. Hope this might help some other poor unfortunate soul...... Now I have to figure how to differentiate between the users! Have a good weekend, peeps. Cheers Terry ----- Original Message ----- > 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]
