is configured to allow you in. I suspect that's the problem. Connect to
MySQL with the 'mysql' command-line client and issue this command
(substituting your info, of course):
grant select,insert,update,delete on <database>.* to <user>@'<ip_of_cf
server>' identified by '<password>';
If you're connecting from localhost, substitute the word localhost for the
ip address above.
You may want to add more permissions later should the user need to do other
stuff (alter, drop, etc). Just rerun the command above with the new
permissions listed.
Cheers,
barneyb
> -----Original Message-----
> From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 17, 2004 3:35 PM
> To: CF-Talk
> Subject: Question about MySQL datasource.
>
> Hi,
>
> I am trying to connect to a MySQL database using CFMX and I
> cannot get the
> connection to verify. Could someone who has connected to
> MySQL, please let me
> know what fields in the MX admin are absolutly required to set up the
> datasource correctly. This is one of my dev boxes and I have
> been able to
> connect to Oracle, SQLServer 7 and 2000, and Sybase but no
> luck with MySQL.
>
> I have put in server (IP address)
> userid
> password
> port (the default that appears in the
> datasource config
> screen)
> database
> I did not fill in any of the advanced settings yet since I
> just wanted to test
> the connection since this is the first time that I will be
> using MySQL.
>
> Thanks for the help,
> Mario
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
