Using codeigniter database dbforge class I have created a database and loaded that database as the current database and created tables in localhost WAMP server. But when I uploaded it to the server I am not able to create the database using dbforge class.
This command line gave me the following error:
Error No 1044: Access denied for user 'username'@'localhost' to database 'database_name'
I am using the 'cpanel' hosting provider .
EDIT1: How we can give permission for a mysql user to create database in cPanel hosting provider...?
EDIT2: The Privileges list of user does not show 'CREATE DATABASE' Privilege in Cpanel. The user is created through cPanel and it have been given all the available privileges, but the CREATE DATABASE privilege is not available in that list in cpanel.