Wednesday, January 23, 2013

MySql Error : Create command denied to user in MySql or Rackspace / Cloud db

Error :
Create command denied to user in MySql or Rackspace /  Cloud db

Reasons:

  • Not selected the database to use.
  • Invalid database name specified.
Solutions:

1. Give the USE query to select the database before queries statements:

USE db_name;

CREATE, INSERT, UPDATE, DELETE statements.

2. Or Specify the database name with the table name. Like,

CREATE TABLE IF NOT EXISTS  `db_name`.`ci_sessions` ( ..... );




No comments:

Post a Comment