MySQL Forums
Forum List  »  MySQL Workbench

Mysql Workbench priveleges, data import
Posted by: Tung mtp
Date: June 20, 2017 11:29AM

When I try to change the priveleges on a mysql db I get the following error:

Please make sure the used account has rights to the MySQL grant tables. Error executing 'DESCRIBE mysql.db'

Is this also why it will not let me import tables in from another DB? When i try I get the error:

Operation failed with exitcode 1

09:20:16 Restoring D:\design and photos\boo.com\db dump\070113.sql

Running: mysql.exe --defaults-extra-file="c:\users\darren\appdata\local\temp\tmpslubjs.cnf" --host=87.117.239.19 --user=boo8_yu52 --port=3306 --default-character-set=utf8 --comments < "D:\design and photos\boo.com\db dump\070113.sql"

ERROR 1044 (42000) at line 1: Access denied for user 'boo8_yu52'@'%' to database ' boo8_6652'

It does however let me create tables manually. Can't work it out at all.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Workbench priveleges, data import
110
June 20, 2017 11:29AM


Sorry, only registered users may post in this forum.

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.