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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
