Query to CREATE DATABASE fails. 1

[imstillatwork]

I'm trying to create a new MYSQL database using the following query..

<cfquery datasource="#mydshere..#">
	CREATE DATABASE IF NOT EXISTS my_test
</cfquery>

If failes saying I don't have access to that DB. The user name being used has CREATE privelages, I've checked that a million times.

How can I create a new DB from a query, and get access to it? ?

I have full control over the mysql server, cfmx7 and web servers.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[Sarky78]

long shot I know but what about the permissions within cf admin -> data sources -> your datasources -> advanced??

 

[imstillatwork]

yeah, kinda it was the user I was using.
had to change the grant privs.

It's going to be a sort of technical project. I'm going to create databases, create mysql users, give that new user permissions to the new database, and a make a cf dsn all on the go so our outside developers can do some of the setup on their own, without getting into anything they shouldn't.

We provide a set of growing admin tools that we re-use to speed up development time for our sites, so the developers will be able to take advantage of these also, so another part of this is to be copying blank tables to the new databases.

It'll take some time, but I'll get it going.

My other hurdles will be IIS and DNS, but i have not put to much hope in doing any of that on the go.



Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[Wullie]

My other hurdles will be IIS and DNS, but i have not put to much hope in doing any of that on the go.

DNS is simple if you are using MSDNS, just look into DNSCMD.exe (Should be on the Windows CD in the support\tools dir)

Hope this helps

Wullie

YetiHost - Quality Coldfusion 7/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[imstillatwork]

sweet thanks, so it's all command line via cfexecute?

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[Wullie]

It's all command line. See the following for details of both IIS and DNS setup:

http://technet2.microsoft.com/WindowsServer/en/library/b20c5f6b-61ae-49fc-b386-fab58664a9fe1033.mspx

Hope this helps

Wullie

YetiHost - Quality Coldfusion 7/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[imstillatwork]

very nice thanks!

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!