CREATE disabled on phpMyAdmin?

Status
Not open for further replies.

zootland

New Member
Messages
5
Reaction score
0
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.
 

Dead-i

x10Hosting Support Ninja
Community Support
Messages
6,084
Reaction score
368
Points
83
Hi,

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

zootland

New Member
Messages
5
Reaction score
0
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';
 

gomarc

Member
Messages
516
Reaction score
18
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

abhwkp.jpg


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