Re: Import mysql.user from 5.0 to 5.7

From: Danilo Giuliani <softdevo_at_tiscali.it>
Date: Fri, 19 May 2017 11:39:01 +0200
Message-ID: <ofmefl$3dp$1_at_gioia.aioe.org>


[Quoted] 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)

Thank you

Danilo

"The Natural Philosopher" ha scritto nel messaggio news:ofma66$gff$1_at_dont-email.me...

On 19/05/17 08:51, Danilo Giuliani wrote:
> Hi, I have to import users from a mysql database 5.0 to 5.7. Some idea?
> Thank you
>
> Danilo

Just the users?

What about their passwords?

And all the databases and permissions associated with those users?

Most of what you want I suspect in in the mysql.user table, so dumping that and importing it into the new database would probably net you what you want.

be careful not to overwrite the new root user with the old one if you don't know the root password on the old system :-)

-- 
There’s a mighty big difference between good, sound reasons and reasons
that sound good.

Burton Hillis (William Vaughn, American columnist) 
Received on Fri May 19 2017 - 11:39:01 CEST

Original text of this message