The real problem is understanding the way mysql deals w/ permissions precedence, if you installed mysql and initialized it with the mysql_install_db script you still have the anon users in the user table, these users take precedence over your user, first thing to do is delete these users and try again, 9 times out of 10 this is the problem.
A second cause is how mysql deals with host permissions in combination w/ users. mysql sorts by host first (going from more specific to less i.e. mydomian.com would come before entries for %.mydomain.com and so on) then by user, in some ways this behaves counter to how you would expect, to make a long story short use the mysqlaccess program to test your permissions, it returns good diagnostics which will help isolate the problem. What is the exact error message you are receiving? Regards, Jim OK, you've all said the same thing but looking in the db and user table, the host is set to % - which is any address. Isnt it? Will try it though -----Original Message----- From: Todd [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 17:36 To: CF-Linux Subject: Re: mysql permissions problem GRANT ALL on dbname.* to user@% IDENTIFIED BY 'password' or GRANT ALL on dbname.* to user@'ipaddress' IDENTIFIED BY 'password' because this: GRANT ALL ON dbname.* TO user IDENTIFIED BY 'password'; Means you've given him a user@localhost account. ~Todd At 05:24 PM 1/20/2003 +0000, you wrote: >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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
