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