Jump to content


Dynamic Creation Of Databases

heliohost giteshss mysql dynamic database creation educational

  • Please log in to reply
2 replies to this topic

#1 giteshss2


    Rank II Member

  • Members
  • PipPip
  • 98 posts
  • Gender:Male

Posted 17 February 2017 - 02:08 AM



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 '*******'@'' to database '**************'

*: my user and database names.


Is it possible?

Any suggestions?

I again declare that it is ONLY for learning.



#2 Krydos


    Rank X Member

  • Root Admin
  • 19,690 posts
  • Gender:Male

Posted 17 February 2017 - 05:34 AM

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.

#3 giteshss2


    Rank II Member

  • Members
  • PipPip
  • 98 posts
  • Gender:Male

Posted 18 February 2017 - 11:32 AM

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.

Also tagged with one or more of these keywords: heliohost, giteshss, mysql, dynamic database creation, educational

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users