Jump to content


Photo

Dynamic Creation Of Databases

heliohost giteshss mysql dynamic database creation educational

  • Please log in to reply
2 replies to this topic

#1 giteshss2

giteshss2

    Rank II Member

  • Members
  • PipPip
  • 97 posts
  • Gender:Male

Posted 17 February 2017 - 02:08 AM

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.



#2 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 12,346 posts
  • Gender:Not Telling

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

giteshss2

    Rank II Member

  • Members
  • PipPip
  • 97 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