MySQL Forums
Forum List  »  Newbie

Re: Transfer a database
Posted by: Peter Brawley
Date: January 17, 2020 01:05AM

Quote

After that you see :

mysql> select host, user, password from mysql.user;

It would've said that a few years ago. Where are you reading this? Since 5.7 it's said ...

select user,host,authentication_string from mysql.user;

But in any event, your result indicates you have no users defined in mysql.user. Apparently you're using only the Workbench vault, see https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-vault.html for how to use it, and ask in that forum if you get stuck.

Options: ReplyQuote


Subject
Written By
Posted
January 16, 2020 06:50PM
January 16, 2020 06:56PM
January 16, 2020 08:43PM
January 16, 2020 11:39PM
January 16, 2020 11:55PM
January 17, 2020 12:36AM
January 17, 2020 12:47AM
January 17, 2020 12:54AM
January 17, 2020 01:00AM
January 17, 2020 01:25AM
January 17, 2020 01:27AM
January 17, 2020 08:35AM
January 17, 2020 10:26AM
January 17, 2020 03:02PM
January 17, 2020 04:00PM
January 17, 2020 10:41AM
Re: Transfer a database
January 17, 2020 01:05AM
January 17, 2020 01:37AM
January 21, 2020 09:14AM
January 21, 2020 09:15AM
January 21, 2020 11:09AM


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.