Error
Unable to connect to MySQL server, check settings..
Client does not support authentication protocol requested by server; consider upgrading MySQL client
what should I do?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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')
I will release MySQL-Admin 3.2, a smaller update this or next week.
And I hope that I have time to make MySQL-Admin full MySQL 5 compatible until the middle of september.
What PHP version do you use?
Greets
BWA
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Really like this script. I was wondering if it would be possible to not specify a database on login, but be able to access all db's at once and pick the tables from a drop down list of db's. At this point you have to log out of one db and log back in for another one.
Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Welcome to Help
Error
Unable to connect to MySQL server, check settings..
Client does not support authentication protocol requested by server; consider upgrading MySQL client
what should I do?
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')
I will release MySQL-Admin 3.2, a smaller update this or next week.
And I hope that I have time to make MySQL-Admin full MySQL 5 compatible until the middle of september.
What PHP version do you use?
Greets
BWA
Really like this script. I was wondering if it would be possible to not specify a database on login, but be able to access all db's at once and pick the tables from a drop down list of db's. At this point you have to log out of one db and log back in for another one.
Thanks.
Hi!
I know it would be better, but i still didnt't found time to program it, but it's one of my todo's for the next MySQL-Admin release.
Greets BWA
Hi I have installed your program on several web servers to date and it has worked great. Thanks for creating such a simple SQL admin program.
I have just installed it on a new server and when I go to the intstalled directory(http://www.magiclite.com/sql) it gives me this error:
Warning: Failed opening 'shared.inc.php' for inclusion (include_path='') in /home/magic/docs/sql/templates/normal.inc.php on line 5
Fatal error: Call to undefined function: checkuserconnection() in /home/magic/docs/sql/index.php on line 7
The server is running PHP 4.2.3 you can see phpinfo at http://www.magiclite.com/test.php.
Thanks for your help,
Commish467
Hi!
I haven't got a PHP 4.2.3 system yet, but I figured out a solution how it could work.
I built a bugfix, you can donwload it under http://www.mysql-admin.org/load.php?filename=MySQL-Admin_3_3_0_bugfix_1.zip.
If there are still any problems please write back.
Greets
Bernhard Wörndl-Aichriedler
Hi again.
I noticed that the last dot was added to the link, heres the right url
http://www.mysql-admin.org/load.php?filename=MySQL-Admin_3_3_0_bugfix_1.zip
Greets BWA