If I'm running the art PHP 4 rpms, should I have "Set-variable = old_password=1" in my.cnf? I have had issues where it tells me the client is out of date and I have had to update the password individually in the mysql console via the OLD_PASSWORD() function.
Is this an issue?
Should MYSQL old_password =1 with ART PHP RPMS?
Should MYSQL old_password =1 with ART PHP RPMS?
Later,
acidbox
Plesk 7.5.4 RHEL3
acidbox
Plesk 7.5.4 RHEL3
Scott,
Is this because of a limitation by PHP, or just backwards compatibility with MySQL 3.2?
If disable old_passwords=1 and I create a script to update each domain by resetting the password with PASSWORD() instead of OLD_PASSWORD(), will PHP work normally?
The problem I'm having right now is that every time you create a MySQL database in plesk, you have to manually run the OLD_PASSWORD() query in mysql or phpMyAdmin in order to use that DB with PHP.
What's the best way to get off the old_passwords?
Thanks for your help.
Is this because of a limitation by PHP, or just backwards compatibility with MySQL 3.2?
If disable old_passwords=1 and I create a script to update each domain by resetting the password with PASSWORD() instead of OLD_PASSWORD(), will PHP work normally?
The problem I'm having right now is that every time you create a MySQL database in plesk, you have to manually run the OLD_PASSWORD() query in mysql or phpMyAdmin in order to use that DB with PHP.
What's the best way to get off the old_passwords?
Thanks for your help.
Later,
acidbox
Plesk 7.5.4 RHEL3
acidbox
Plesk 7.5.4 RHEL3
-
- Atomicorp Staff - Site Admin
- Posts: 8355
- Joined: Wed Dec 31, 1969 8:00 pm
- Location: earth
- Contact:
Thats probably a question better aimed at a DBA, but I suspect the best way to do it is to dump out all your databases. Remove everything from mysql completely (yum remove mysql-server, rm -rf /var/lib/mysql) and then reinstall with mysql 4.1, and re-import all your data.
Thats the lazy way to do it, I suspect you could probably just redo the mysql database as well.
Thats the lazy way to do it, I suspect you could probably just redo the mysql database as well.