some pipe might be blocked or grant tables need to be flushed or somthing;( If the other dsn are failing to connect, try setting up a different dsn with same 'known to connect' database and same username/pswd only dsn being different. If you find it can't be done and can't connect to that dsn, might be as simple as stop mySQL and restart it, it should work then...
-----Original Message----- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 23 July 2004 16:44 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CF and MySQL premissions 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] --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 0430-3, 23/07/2004 Tested on: 23/07/2004 17:54: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]
