my dog learned polymorphism*
The moose likes JDBC and the fly likes CREATE DATABASE databaseName  doesn't seem to work Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CREATE DATABASE databaseName  doesn Watch "CREATE DATABASE databaseName  doesn New topic

CREATE DATABASE databaseName doesn't seem to work

colin shuker
Ranch Hand

Joined: Apr 11, 2005
Posts: 744

I can't seem to get 'create database' to work when my web app (as war file)
on server tries to connect to MySql on server.

Basically I have..

Then I do...

This works locally on my pc, when I connect to MySql installed on pc,
but not when on the server, connecting to MySql on the server.

Is there anything I can do?

Ryan Beckett
Ranch Hand

Joined: Feb 22, 2009
Posts: 192
Check the user privileges. See MYSQL - User Grants
I agree. Here's the link:
subject: CREATE DATABASE databaseName doesn't seem to work
Similar Threads
Don't know how to connect to MySql
connection with database
MySQL user and password errors
JSPs and Servlets - how to execute?
Web Srevices with Database