| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Gold Sponsor 2015! |
|Updating Multiple Databases|
I need to update 100 databases, we have a default username and password in each database in the table staff.
We need to change this username and password for each occurance in each database.
Its the admin pass and user for each website, the ID of the Admin account is different in each database so will have to update by firstname and surname.
set username "AdminNew"
set password "passNew"
where fname = "Administrator"
but across 100 databases
Any help apreciated
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved