Create Profile (for password admin or resource limits)

[bravura]

For my class we were instructed to set password limits on the users we created. Of course the book only lists the limits (ie PASSWORD_LIFE_TIME) but does not tell us how to do it. I found online the following syntax:

CREATE PROFILE app_user2 LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 60
PASSWORD_REUSE_TIME 60
PASSWORD_REUSE_MAX 5
PASSWORD_VERIFY_FUNCTION verify_function
PASSWORD_LOCK_TIME 1/24
PASSWORD_GRACE_TIME 10;

So I assume one needs to create the profile first, then assign it to my user. I've tried to set up the profile, but I receive ERROR 1064 (error in SQL syntax.) Is there a flaw in the syntax, am I trying this in the wrong place (xampp/mysql/bin/mysql -u root and/or 'use mysql'), or is there something I need to do in the config files?

Thanks so much for your help, I've been at this for hours (in addition to trying to figure out "exec sp_password" and creating local and domain groups but I'm sure I can figure out those once I see how my question above is resolved (i'm not trying to get out of doing my own homework - I don't get straight A's slacking off!)

[Altrea]

I found online the following syntax:

CREATE PROFILE app_user2 LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 60
PASSWORD_REUSE_TIME 60
PASSWORD_REUSE_MAX 5
PASSWORD_VERIFY_FUNCTION verify_function
PASSWORD_LOCK_TIME 1/24
PASSWORD_GRACE_TIME 10;

I think thats for ORACLE not for MySQL, so it will not run with MySQL.

[bravura]

It is, i thought i could run it on MySQL...

[bravura]

ps. Teacher has us using MySQL and most of the books examples are for Oracle - get a load of that!

you can end thread. thanks.