Thats the fellow! Its been a while since I set up a new Mysql db so have got a bit rusty. It normally falls to a dbadmin or some such.
Thanks for all the help guys :) -----Original Message----- From: dennis baldwin [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:26 To: CF-Linux Subject: RE: mysql permissions problem Douglas, Just a quick note. You shouldn't have to restart MySQL to get the privileges working. You should be able to make the changes and type flush privileges; at the command line to update them. Regards, Dennis -----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 9:15 AM To: CF-Linux Subject: RE: mysql permissions problem Got it working - it was a case of restarting the mysql server to recognize the new permissions settings. Im so used to linux not needing to do this most of the time that I forgot! Thanks for all the help though -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 09:26 To: CF-Linux Subject: Re: mysql permissions problem Douglas, Do you have both user@localhost and user@anotherhost set up? You need to have user@localhost, otherwise user@anotherhost won't work, even if % is your other host. Regards Stephen ----- Original Message ----- From: "Douglas McKenzie" <[EMAIL PROTECTED]> To: "CF-Linux" <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 5:24 PM Subject: mysql permissions problem > Hi All, > > Having some trouble connecting top a Mysql db on Redhat7.2 with CFMX. > > Ive used: > > GRANT ALL ON dbname.* TO user IDENTIFIED BY 'password'; > > But I cant logon to the mysql db using that name - any ideas? > > The user table had N in all provs whilst the db table has Y in all > privs (as > it should be). > > Any ideas? > > Cheers, > Douglas McKenzie > > ---------------------------------------- > Internet Developer / Designer > [EMAIL PROTECTED] > 020 7267 6718 > ---------------------------------------- > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
