Ad Widget

Collapse

Problem with mysql_pconnect

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shaihi
    Junior Member
    • Oct 2004
    • 17

    #1

    Problem with mysql_pconnect

    Hi,
    When I try to open the index page I get this message:
    Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/zabbix/public_html/html/include/db.inc.php on line 32
    Error connecting to database [Access denied for user ''@'localhost' to database 'zabbix']

    As you can see the problam is that MySQL does not recieve the user name and password of the root correctly.
    I have checked db.inc.php. What could be the problem?
    Thanks,
    Shai
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Google

    http://dev.mysql.com/doc/mysql/en/Old_client.html
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • shaihi
      Junior Member
      • Oct 2004
      • 17

      #3
      Thanks,
      Sorry I'm a newbie and I thought what you pointed to doesn't concern me cause I just installed both server and client of MySQL ver. 4.1.x

      Comment

      • Alexei
        Founder, CEO
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Sep 2004
        • 5654

        #4
        MySQL related issue

        I think it does concern you.

        Have you recompiled ZABBIX after new MySQL was installed? I believe MySQL client libraries used by ZABBIX daemons are incompatible with the MySQL server, that's why you have this problem.
        Alexei Vladishev
        Creator of Zabbix, Product manager
        New York | Tokyo | Riga
        My Twitter

        Comment

        • shaihi
          Junior Member
          • Oct 2004
          • 17

          #5
          I didn't recompile, but I used the OLD_PASSWORD func. and it worked...
          Thanks,
          Shai

          Comment

          • peter_milburn
            Junior Member
            • Sep 2005
            • 25

            #6
            That also worked for me as well.

            Good to see forums that actually work

            Pete

            Comment

            Working...