Errors with Information_Schema in Create Target Results
Posted by: Vaughan Wickham
Date: October 23, 2021 05:45AM

Hello,

Am using WorkBench 6.3 and MySQL 5.7.18

Have reached the Create Target Results step and all the steps relating to the Information_Schema have errors

e.g.
ERROR: Error executing 'DROP SCHEMA IF EXISTS `information_schema` '
Access denied for user 'root'@'localhost' to database 'information_schema'.
SQL Error: 1044

ERROR: Error executing 'CREATE TABLE IF NOT EXISTS `information_schema`.`CHARACTER_SETS` (
`CHARACTER_SET_NAME` VARCHAR(32) NOT NULL DEFAULT '',
`DEFAULT_COLLATE_NAME` VARCHAR(32) NOT NULL DEFAULT '',
`DESCRIPTION` VARCHAR(60) NOT NULL DEFAULT '',
`MAXLEN` BIGINT(3) NOT NULL DEFAULT '0')
ENGINE = MEMORY
DEFAULT CHARACTER SET = utf8'
Access denied for user 'root'@'localhost' to database 'information_schema'.
SQL Error: 1044

Would appreciate advice on how to proceed

Thanks

VW

Options: ReplyQuote


Subject
Written By
Posted
Errors with Information_Schema in Create Target Results
October 23, 2021 05:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.