I just noticed something about MySql which I haven't noticed before.
If you use any of the MySql hashing functions MD5, SHAx, Password, etc they all seem to return the same hash. This happens across all schemas and databases regardless of their installed instance
I have a local MySql server database, and two others hosted with different internet providers
If I do the following
select MD5('Password');
select Sha1('Password');
select Sha2('Password', 224);
select Password('Password');
each function will yield the same result across all for that function across all instances of MySql
For example if I do select MD5('Password')
it gives this same dc647eb............12b3964
hash for MD5 regardless of on all of my servers. This looks a little bit suspect to me and sounds like a security hole.
Has anyone noticed this and is there anything that can be done about it?