Z
Z
zudi2018-04-29 06:38:44
MySQL
zudi, 2018-04-29 06:38:44

How to fix error 1044?

The error arises when I import base from a local disk.

SQL запрос:

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Ответ MySQL: Документация
#1044 - Для пользователя 'id5570277_zudi'@'%' доступ к базе данных 'information_schema' закрыт

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2018-04-29
@zudi

It looks like you are trying to create a table in the `information_schema` system read-only database. Before the query, select your database (USE basename).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question