giteshss2 Posted February 17, 2017 Posted February 17, 2017 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 Posted February 17, 2017 Posted February 17, 2017 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 Posted February 18, 2017 Author Posted February 18, 2017 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now