-
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?
-
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.
-
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
-
Forum Rules
|
|