mysql password defined during setup does not work

[homer15]

 i just did a quick test with all the mysql appliances i have.

turnkey-lamp-2009.02-hardy-x86.iso
turnkey-mediawiki-2009.03-hardy-x86.iso
turnkey-phpbb-2009.03-hardy-x86.iso
turnkey-wordpress-2009.03-hardy-x86.iso

i installed all of these from the boot menu. with a simple password of "turnkey" it works fine. with a complex password like "p@$Sw0rD", it allows me to login to webmin but it says "Login failed : Incorrect administration username or password" for accessing the mysql server module.

to fix this, i have to alter the password via the command line and flush the permissions.

[Alon Swartz (alonswartz)]

As Liraz mentioned on the forums [1]: "the SQL update command is being passed through to the mysql cli command through the shell, which interpolates certain characters in the password as a variable name"

[Alon Swartz (alonswartz)]

Forums link: [1] http://www.turnkeylinux.org/forum/support/20090818/mysql-root-password

[Alon Swartz (alonswartz)]

This issue has been fixed, not only for mysql passwords but all passwords specified during installation.
It will be included in all appliances released from now on.

With regards to the fix recommended in the forum post, commands.mkarg() is already being used in all system commands, but was not taking effect on the passwords in certain queries (ie. mysql) due to the nested ' and " required to build the query.

The fix is to escape special characters in the password provided.