Change that user to username@'%' for access from anywhere or [EMAIL PROTECTED] for whatever ip/hostname you're granting access to.
Regards, Dennis -----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 11:25 AM To: CF-Linux 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
