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!)