I have a mysql database on the server where I have root access also to phpmyadmin.
I have such a database 1, which is a table users where a user named admin.
How shall be observed as the password for this user?
Good practice is to never observe a password, just set it, and if the user is not setting his own, the admin should set a pre-expired passord, so the user must change it before using the authenticated facility. Are you working with the mysql password, the unix user password or an application password?