Menu

Welcome to Help

Help
2006-04-03
2013-03-27
  • Nobody/Anonymous

    Welcome to Help

     
    • joe

      joe - 2006-08-10

      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?

       
      • Bernhard Wörndl-Aichriedler

        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

         
    • Fred

      Fred - 2006-10-16

      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.

       
      • Bernhard Wörndl-Aichriedler

        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

         
    • Commish467

      Commish467 - 2006-11-16

      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

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.