I have this idea of making my database's Admin account secured by creating the following:
- Trigger is activated every hour in mysql this trigger activates a stored procedure
- Stored procedure generates a new password using md5(date()+pre shared key+rand())
- I have a application in vb that generates the same password every hour that I can then log into with.
However this is still just an idea and I don't know if this is possible, do you know if anyone has tried this?
Any links or reference material.
I was inspired by my friend who has a key that is generated in a little device thing that he hangs around his neck when he logs into a workstation, does anyone know what the this security procedure is called?
What are the limitations or problems that could occur? (server crash/restart)