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]
--
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]
