Dynamic Creation Of Databases

[giteshss2]

Greetings!

 

I am trying to create a simple application in java FOR EDUCATIONAL PURPOSE.

In that, I want to create databases dynamically.

 

eg.: when i register, i get a database.

ONLY TRIAL BASIS, nothing more than that.

 

I have tried that with remote access from my development machine to tommy.heliohost.org, but i am getting an error while creating database. ALL OTHER TASKS ARE WORKING FINE EXCEPT THIS ONE: create database.

 

Error: Access denied for user '*******'@'59.95.116.27' to database '**************'

*: my user and database names.

 

Is it possible?

Any suggestions?

I again declare that it is ONLY for learning.

 

Thanks.

[Krydos]

Your cpanel mysql account doesn't have permissions to create databases. When you use the cpanel mysql page it creates the database with root privileges and then assigns you access.

[giteshss2]

Ok sure!

I already knew the solution to the problem using Dynamic Table Creation and it is working. I just wanted to check if Database Creation works or not. No problem! thanks for the help.