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>
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 ThatcherReceived on Fri May 19 2017 - 15:12:45 CEST