Re: Import mysql.user from 5.0 to 5.7
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