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>
>
> 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
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