Re: Importo mysql.user from 5.0 to 5.7

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

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