I installed MySql-Admin version 3.4 on my RedHat 5 system running Apache 2.2 and PHP 5.1.6
I made it through installation but I could not log in afterwards.
The error message is the standard for a bad password (Access denied for user 'mysqladmin'@'localhost' (using password: YES))
With a bit of help from NetBeans and the PHP debugger I believe the problem is with the DES encryption/decryption of the password.
I uninstalled it and used the same zip file to load onto a Windows XP also running Apache 2.2 and PHP 5.2.6 and everything seems to work as advertised.
Is this a known issue with 64bit systems?
Joe
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The main Problem ist password encryption, mysql changed the encryption for passwords on MySQL Server version over 5.0 - on Linux it automatically uses the new encryption type - that is not supported by MySQL Admin yet.
I posted something about that in this forum before:
"Hi!
That's a problem between the PHP mysql library and the MySQL 5.x server.
MySQL 5.x uses per default the a better auth. mode, that is not supported by PHP versions with older mysql clients.
You can fix, that problem by changing the auth mode to the mode support by older clients by changing your password.
SET PASSWORD FOR 'me'@'my_server' = OLD_PASSWORD('my_new_pw')
"
Greets
BWA
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I installed MySql-Admin version 3.4 on my RedHat 5 system running Apache 2.2 and PHP 5.1.6
I made it through installation but I could not log in afterwards.
The error message is the standard for a bad password (Access denied for user 'mysqladmin'@'localhost' (using password: YES))
With a bit of help from NetBeans and the PHP debugger I believe the problem is with the DES encryption/decryption of the password.
I uninstalled it and used the same zip file to load onto a Windows XP also running Apache 2.2 and PHP 5.2.6 and everything seems to work as advertised.
Is this a known issue with 64bit systems?
Joe
Hey!
The main Problem ist password encryption, mysql changed the encryption for passwords on MySQL Server version over 5.0 - on Linux it automatically uses the new encryption type - that is not supported by MySQL Admin yet.
I posted something about that in this forum before:
"Hi!
That's a problem between the PHP mysql library and the MySQL 5.x server.
MySQL 5.x uses per default the a better auth. mode, that is not supported by PHP versions with older mysql clients.
You can fix, that problem by changing the auth mode to the mode support by older clients by changing your password.
SET PASSWORD FOR 'me'@'my_server' = OLD_PASSWORD('my_new_pw')
"
Greets
BWA