I have full access to a 'MYSQL 5.0.27-community-nt-log' database one of our new updates for a core app requires PHP 5.4, after installing and configuring I'm stuck at the error regarding old vs. new passwords.
I've followed every thread I can find and I'm pretty sure I understand the process:
- Disable 'old_passwords'
- Reset the password to the new 41 encryption
But I cannot seem to get 'old_passwords' to be set to 'OFF'. Logging in as root I've tried the following:
- I've removed it from the my.cnf file (I've also tried setting it to '0', 'False' etc)
- Manually setting it in the query browser both globally and session
- Turning the option on/off in MYSQL administrator
and restarted the service but 'show variables like 'old_passwords' always reports as 'ON'.
Changing the password still remains at a 16 length.
I'm sure once I'm able to turn this variable off I should be fine, Any advice?