CREATE disabled on phpMyAdmin?

Discussion in 'Free Hosting' started by zootland, Dec 3, 2016.

Thread Status:
Not open for further replies.
  1. zootland

    zootland New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I'm trying to execute a "CREATE" SQL command in phpMyAdmin, but am getting a "#1142 - CREATE command denied to user 'zootland'@'localhost' for table 'users'"

    I noticed that I seem to be logged in as zootland@localhost and have no way to log into other MySQL accounts. Very confused.
     
  2. Dead-i

    Dead-i x10Hosting Support Ninja Community Support

    Messages:
    6,084
    Likes Received:
    367
    Trophy Points:
    83
    Hi,

    What's the full query you're trying to run? :)
     
  3. zootland

    zootland New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for the quick reply. Also, nice avatar. ;)

    Code:
    CREATE TABLE IF NOT EXISTS `zootland_login`.`users` (
      `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto incrementing user_id of each user, unique index',
      `user_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s name, unique',
      `user_password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s password in salted and hashed format',
      `user_email` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s email, unique',
      PRIMARY KEY (`user_id`),
      UNIQUE KEY `user_name` (`user_name`),
      UNIQUE KEY `user_email` (`user_email`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user data';
    
     
  4. zootland

    zootland New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Can anyone give me a hand?
     
  5. zootland

    zootland New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
  6. zootland

    zootland New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
  7. gomarc

    gomarc Member

    Messages:
    516
    Likes Received:
    18
    Trophy Points:
    18
    Hello zootland,

    You may want to make sure you are running this query on the right database to avoid this error.

    1 - Open the PhpMyAdmin
    2 - Click on/select zootland_login database
    3 - Click the SQL tab

    [​IMG]

    If you have previously created the database zootland_login, the query as shown above should run successfully.
     
Thread Status:
Not open for further replies.

Share This Page