This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 750

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
subject: CREATE DATABASE databaseName doesn't seem to work
jQuery in Action, 3rd edition