MySQL Forums
Forum List  »  Stored Procedures

ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist
Posted by: no name zzzzz
Date: January 08, 2018 07:05AM

[root@x ~]# mysql -u root -pxxxxxxxx
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 745
Server version: 8.0.3-rc-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant all privileges on information_schema.* to 'root'@'localhost';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'
mysql> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'DBpass#1';
ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist
mysql> quit

what should we do ???

Options: ReplyQuote

Written By
ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist
January 08, 2018 07:05AM

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.