CREATE disabled on phpMyAdmin?

[zootland]

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.

 

[Dead-i]

Hi,

What's the full query you're trying to run?

 

[zootland]

Thanks for the quick reply. Also, nice avatar.

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';

 

[zootland]

Can anyone give me a hand?

 

[zootland]

hm

 

[zootland]

a-anyone?

 

[gomarc]

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

If you have previously created the database zootland_login, the query as shown above should run successfully.