CODEWITHSUNDEEP
mysql
user4549972
user4549972

Reputation:

#1044 - Access denied for user 'faiskap'@'localhost' to database 'information_schema'

I am getting the following error on my database.

#1044 - Access denied for user 'faiskap'@'localhost' to database 'information_schema'

On 1044, I have the following code,

CREATE TEMPORARY TABLE `GLOBAL_STATUS` (
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
  `VARIABLE_VALUE` varchar(1024) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

Please guide me how can I remove this error?

Upvotes: 0

Views: 5976

Answers (2)

Rick James
Rick James

Reputation: 142306

Do not CREATE anything in the databases information_schema or mysql or performance_schema.

USE your_database_name before executing that CREATE TEMPORARY TABLE.

Upvotes: 3

mysqlrockstar
mysqlrockstar

Reputation: 2612

Check whether you have global privileges

SHOW GRANTS FOR 'faiskap'@'localhost';

If not grant privileges

GRANT ALL ON *.* TO 'faiskap'@'localhost';
GRANT SELECT, INSERT ON *.* TO 'faiskap'@'localhost';

The information_schema is a logical database, and you should not import or export information_schema. You must skip importing information_schema by giving --force option to mysql client if you are using old version of mysqldump

Upvotes: 1

Related Questions