Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: open
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
or you could create a script that generates 100 files containing the proper update sql for each db and then another script to feed the correct sql file as input into the correct db.