Results 1 to 3 of 3

Thread: cnnot connect myql from php

  1. #1
    Join Date
    Apr 2005
    Posts
    9

    Question cnnot connect myql from php

    i use php 4.3.11 and mysql 4.1.11on apache server 13.27 in xp.
    my problem:
    when i try to connect on mysql from php i have this error maessage:
    'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
    i think i made all configuration settings, but obviously something doesn't work.
    can someone help me?

  2. #2
    Join Date
    Apr 2005
    Location
    florida
    Posts
    89
    I suppose that in php: the app user is "app_user" and the password is "app_user_pass"

    Do this and it will be fine:

    1) connect as root: on your localhost:
    mysql -u root -h localhost -p (press enter)

    2) enter the root password (enter)

    3) type: use mysql (to change db to MYSQL)

    4)type: UPDATE user SET password = old_password('app_user_password') WHERE user = 'app_user';

    5) FLUSH PRIVILEGES;

    and go and refresh your page...give a smile ..

    Good luck.

  3. #3
    Join Date
    Apr 2005
    Posts
    9

    problem solved

    i used an itegrated php-mysql-apache software and i have no more problems. thanks anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •