mysql> grant all on *.* to username@yourIP identified by "yourpassword" with grant option;
above gives access to all tables, also username@'%' for access from anywhere and asyuknow ipconfig in command prompt to give yourip, http://mysqlfront.sstienemann.de/. rgds Colm -----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 17:25 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
