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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
