Re: Import mysql.user from 5.0 to 5.7

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Fri, 19 May 2017 14:12:45 +0100
Message-ID: <ofmqq2$82n$1_at_dont-email.me>


On 19/05/17 10:39, Danilo Giuliani wrote:
> I have to upgrade a server with 380 users of which I do not know
> permissions and passwords.
> I must import all the information contained in the mysql database
> (version 5.0) in mysql database (version 5.7)
>

If you have got the actual databases across already, you need most of what is in the `mysql` database as well as the `information_schema` database.

I am not clear as to whether you don't know *how* to copy these databases, or you don't know *what* to copy from them...

-- 
"Socialist governments traditionally do make a financial mess. They 
always run out of other people's money. It's quite a characteristic of them"

Margaret Thatcher
Received on Fri May 19 2017 - 15:12:45 CEST

Original text of this message