[MKDoc-dev] MySQL 4.1 and plain text passwords
Chris Croome
chris at webarchitects.co.uk
Wed Nov 17 11:00:01 GMT 2004
Hi
At some point the legal issues preventing some distros shipping MySQL
4.1 will probably be sorted [1] so I guess at some point it would make
sense to make MKDoc work with it, the only issue I'm aware of is the way
that 4.1.x does passwords -- they are no longer in plain text:
- 5.5.9 Password Hashing in MySQL 4.1
MySQL user accounts are listed in the user table of the mysql
database. Each MySQL account is assigned a password, although what is
stored in the Password column of the user table is not the plaintext
version of the password, but a hash value computed from it. Password
hash values are computed by the PASSWORD() function.
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
There is a way around this, you can start the MySQL server with the
--old-passwords command line option, and this _should_ work in my.cnf
(but I'm not sure if it does from browsing the MySQL list):
[mysqld]
old-passwords
I have no idea what would have to be changed in MKDoc for hashed passwds
to work, also backwards compatability with 3.x should be retained.
Chris
[1] http://thread.gmane.org/gmane.linux.redhat.fedora.devel/16521
--
Chris Croome <chris at webarchitects.co.uk>
web design http://www.webarchitects.co.uk/
web content management http://mkdoc.com/
More information about the MKDoc-dev
mailing list