#22 Patch to force "flush privileges" on password change

[mbirk]

When a password is changed it updates the MySQL
database accordingly. However, MySQL requires a
special "flush privileges" command to be invoked for the
changes to apply. See the MySQL documentation
section 4.4.3:

http://www.mysql.com/documentation/mysql/bychapter/
manual_MySQL_Database_Administration.html#Privilege_c
hanges

The attached patch forces the "flush privileges"
command after a successful password change.

[mbirk]

Patch to force "flush privileges" on password change

[Nobody/Anonymous]

Logged In: NO

pam_mysql don't use the MySQL privileges but plain tables
instead.

[mbirk]

Logged In: YES
user_id=97575

To correct the previous comment, pam_mysql can use any
MySQL table. However, by default it queries and updates
the "user" table, which controls MySQL authentication. In
that case, the "flush privileges" command, and therefore this
patch, is useful.

[Moriyoshi Koizumi]

Logged In: YES
user_id=995831

I'll look into this.