CREATE命令被拒绝给用户-你能回答更改任何权限以允许我的PHP my Admin传递以下SQL命令代码吗


CREATE command denied to user - Can you please answer to change any permission to allow my PHP-My-Admin to pass the below SQL command codes?

我不是一个优秀的程序员,但碰巧通过PHP My Admin的SQL命令创建了一个MySql表。MySQL命令如下:

SQL查询:

CREATE TABLE IF NOT EXISTS  `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',
 `user_active` TINYINT( 1 ) NOT NULL DEFAULT  '0' COMMENT  'user''s activation status',
 `user_activation_hash` VARCHAR( 40 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT  'user''s email verification hash string',
 `user_password_reset_hash` CHAR( 40 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT  'user''s password reset code',
 `user_password_reset_timestamp` BIGINT( 20 ) DEFAULT NULL COMMENT  'timestamp of the password reset request',
 `user_rememberme_token` VARCHAR( 64 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT  'user''s remember-me cookie token',
 `user_failed_logins` TINYINT( 1 ) NOT NULL DEFAULT  '0' COMMENT  'user''s failed login attemps',
 `user_last_failed_login` INT( 10 ) DEFAULT NULL COMMENT  'unix timestamp of last failed login attempt',
 `user_registration_datetime` DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00',
 `user_registration_ip` VARCHAR( 39 ) COLLATE utf8_unicode_ci NOT NULL DEFAULT  '0.0.0.0',
PRIMARY KEY (  `user_id` ) ,
UNIQUE KEY  `user_name` (  `user_name` ) ,
UNIQUE KEY  `user_email` (  `user_email` )
) ENGINE = MYISAM AUTO_INCREMENT =1 DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci COMMENT =  'user data'

但是MySQL回复我如下:

MySQL表示:文档#1142-CREATE命令被拒绝给表"users"的用户"a5175979_admin"@"localhost"

你能告诉我,如何更改任何权限,让我的PHP my Admin通过上面的SQL命令来创建一个名为"users"的表吗?。

在PhpMyAdmin 中

  1. 单击特权链接
  2. 选择您的用户名
  3. 单击"检查所有"权限链接
  4. 单击Go按钮

阅读wikihttps://wiki.phpmyadmin.net/pma/user_management