I have one hosting account using cPanel and phpmyadmin.
I have 50 databases under this account, all WordPress.
I need this query modified so that it runs through all databases to update the password.
UPDATE 'wp_users' SET 'user_pass' = MD5('somepassword') WHERE 'user_login' ='admin' LIMIT 1;
Hoping for a solution that can target all databases instead of having to go through them one by one.