Im probably being really stupid here but..... What do I need to enter into CFAdmin (MX) to get it to connect to a MySql database? Or it might be in the mysql admin.
Ive currently tried: CF DATASOURCE NAME: cyberdog Database: cyberdog (what Ive called the db in Mysql) Server: localhost Username and password are the same as the the user in the User table in mysql - Ive given the user all permissions except grant and checked and doublechecked them, logged into mysql as that user to test the user account. All works ok but if I add that user as the one to connect to the db it errors. However it works with the root mysql account. Code Im using as the Grant is: GRANT ALL PRIVILEGES ON cyberdog.* TO cfmx@localhost IDENTIFIED BY 'password'; This should allow that user to insert/update/delete etc an all tables of that db afaik but apparently it doesnt. Anyone have any ideas? Cheers, Douglas McKenzie ---------------------------------------- Internet Developer / Designer [EMAIL PROTECTED] 020 7267 6718 ---------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
