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` ( ..... );




1 comment:

  1. DreamHost is ultimately one of the best hosting company with plans for all of your hosting requirements.

    ReplyDelete