MySQL: Bring over user from other database
Posted on 2013-10-17
I have a production database server with a database "widgetdb" that I restored onto another database server. I was easily able to do the restoration onto the new server, but now I want to bring over a specific user that was associated with that database.
Now the main problem is that the database (both the other server and the new server), is accessed through a web application and the user needs to be the same in both systems. The user on the previous system is identified using a hash to figure out their password. This keeps me from just recreating the user on the second system.
Is there a script or procedure or something for bringing over a user, whole password and all ?