Thanks for the hints, Colm. I'm working locally (ie the CF and the MySQL are on the same box - and will be on the live application). Not too big a deal - it gets a lot of hits (which is why we're moving from 150 separate Access mdbs to MySQL!), but there isn't a huge amount of data.
Granting the right permissions isn't the problem (I actually understood all that from the manual and various tomes I have handy), it's just that I seem unable to set up the separate DSNs with CF Admin. Cheers Terry ----- Original Message ----- > 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]
