database's native interface, not via CF. With MySQL, that's the `mysql`
command line tool. Call it like this:
Mysql -u <username> -p [ -h <hostname> ]
The -p will make it prompt for your password, and the -h will allow you to
connect to a remote host, if needed. The default host is localhost.
I suppose you could probably connect from CF via a JDBC connect string, but
I've never done that.
Cheers,
barneyb
> -----Original Message-----
> From: Nick Baker [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 01, 2004 2:02 AM
> To: CF-Talk
> Subject: CFQUERY - MySQL Chicken and Egg
>
> I am just now taking a stab at using MySQL, and hit a
> fundamental snag,
> i.e., creating the database. MySQL indicates the following
> statement will
> do the job
>
> <cfquery name="CreateaDB">
> CREATE DATABASE [IF NOT EXISTS] Test_DB
> </cfquery>
>
> However, as best I can tell CFQUERY wants, among other
> things, a datasource
> and I can't create a datasource without a DB.
>
> Any help would be appreciated.
>
> Thanks,
>
> Nick
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
