MySQL Forums
Forum List  »  General

ERROR 1044 (42000) at line 951: Access denied for user 'root'@'%.unix.sys.com' to database 'performance_schema'
Posted by: MrDevH DevH
Date: June 06, 2019 08:06PM

Hey All,

Wondering how can I fix this issue. I'm trying to restore a single database but getting this error when I attempt to do so:

[root@mysql01 tmp]# mysql -u root -h mysql-c01 -p zabbix < mysql-c01.sql.1556440201
Enter password:
ERROR 1044 (42000) at line 951: Access denied for user 'root'@'%.unix.sys.com' to database 'performance_schema'
[root@mysql01 tmp]#

What do I need to do to resolve the above? Not able to restore any of the databases from the full backup at the moment due to the above issue.

Thx,
TK

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1044 (42000) at line 951: Access denied for user 'root'@'%.unix.sys.com' to database 'performance_schema'
June 06, 2019 08:06PM


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.