On 7/16/07, Stuart Murray-Smith
Greetings list
openSuSe 10.2 MySQL 5.0.26
How can I establish what the standard encryption agent(s) is (are) for MySQL?
SELECT ENCRYPT('password'), PASSWORD('password'), MD5('password');
generates a different encrypted password to what:
select * from user;
does, and I think this is why my database lookups aren't auth'ing.
How would I go about changing the standard encryption agent if I could?
Regards,
Stuart
Stuart,
If Suse does anything unusual or overrides a default they document it
a couple of ways.
One, they often have a README.SuSE or similar in /usr/share/doc/packages.
i.e Checkout /usr/share/doc/packages/mysql/README.SuSE
Unfortunately I don't see an answer to your question there.
The second thing is to install the mysql source rpm and extract the specfile.
You can get the source rpm off the DVD/CD you installed from and use
rpmbuild to compile it.
rpmbuild --rebuild mysql.src.rpm
I think that will create a rpm file you can install. By looking at
the specfile it extracts you can see what patches SuSE applied beyond
the standard code. You can also see any args they pass into make etc.
Further, if there is something in the specfile you want to change, you
can do that manually then recompile with:
rpmbuild -bb