Re: Importo mysql.user from 5.0 to 5.7

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Fri, 19 May 2017 09:36:33 +0100
Message-ID: <ofmak6$h60$2_at_dont-email.me>


On 19/05/17 09:29, The Natural Philosopher wrote:
> On 19/05/17 08:51, Danilo Giuliani wrote:

[Quoted] [Quoted] >> 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 :-)
>
>
>
I just looked ta the title

You got that far already. What's stopping you?

Export as CSV and edit out root, then do a 'LOAD .'

http://stackoverflow.com/questions/14127529/mysql-import-data-from-csv-using-load-data-infile

has some handy cribs

-- 
Karl Marx said religion is the opium of the people.
But Marxism is the crack cocaine.
Received on Fri May 19 2017 - 10:36:33 CEST

Original text of this message