user authenticate

I started very little to use xojo.
I would like to use a system to authenticate users through two tables of a db mysql.
One with the list of users and the other with the roles and their permissions
The connection to the db is ok.
I would like to be helped to understand how to set user login and permission control in xojo
I tried but I find nothing about it
thanks

If you use the mySQL Password() Function and if your Server uses the old Password Format, you can compare the Hash of the entered Password with the Hash from the mySQL Server/Database

thePasswordHash As String = EncodeHex(MD5(thePassword))

I use an approach similar to what you want to do.
Step 1 is the same approach as suggested by Sascha. I now have a user.
Step 2 is to query the second table and get permissions for my application. I use a multi-level approach with transaction codes, transaction objects and function codes. Permissions are set on either or all levels.

Depending on the application, you can query all of the user permissions at once, or query specifically when trying to access a transaction. Transaction-based and object-based permissions can be a lot of work both to setup the methods and to maintain the necessary master data.

thanks for reply
i have mySQL 5.5
i make this:
in mySQL DB i store: OLD_PASSWORD(‘admin’) and i see: 43e9a4ab75570f5b
in mySQL DB i store: PASSWORD(‘admin’) and i see: *4ACFE3202A5FF5CF467898FC58AAB1D615029441

but in xojo
EncodeHex (MD5 (TextFieldPasswd.Text))=21232F297A57A5A743894A0E4A801FC3

I do not understand

can you help me?

ok i solved.
the error is that in mysql not specify anyting, i store only: MD5(‘admin’)

thanks at all!!