Changing Admin password using PhpMySql

Thanks for the reply. Sorry I posted this in the wrong section. I couldn’t work out where to post. It is on shared hosting so I can’t run a command at that level. Is it possible if I run something like this:
update oc_users set password=“test123” where uid=“admin”;
Does that password need to be encrypted for it to work please?
Or is it possible to add an email address to the admin and try to recover the password that way please?