I'm having a headache with this one, I've used WSN on 3 servers already and i wanted to purchase another licence for another domain today but i can't figure out the following problem:
- Client does not support authentication protocol requested by server; consider upgrading MySQL client Failed! Please check the database info you supplied and try again.
Access denied for user 'ODBC'@'localhost' (using password: NO)
This is on IIS server (i'm installing it for a company that has its own server). I can create users and tables and everything i want when i use the command lines on the server everything is fine. And i even tried with all users including the "root"
BUT when trying to install i have this.
MYSQL version is 4.1 and it is a basic install of PHP + mysql on a SUB-domain (problem?..should not be)
Please help me, i'm used to WSN now, i don't want to have to use another script !!
It says you need to create and use a mysql username and password. Whatever you supplied in the WSN setup isn't what you put in mysql. And it indicates it's not using a password, which is odd and sounds like a gaping security hole in the server.
The message at the top suggests that mysql is wrongly installed with mismatched client vs. server versions, and tells you to upgrade the mysql client. (I don't know if simply using a wrong username/password would cause this error to appear misleadingly or not.)
You'd best check an IIS or MySQL forum, I don't have any experience setting up MySQL on IIS.
Thanks for your answer Paul. Actually im using the right user/password that's why i don't understand, probably a wrong intall yes. I'll post the answer if i can find it.
Comments on ODBC connect on IIS :(
Beginner
Usergroup: Customer
Joined: Mar 15, 2005
Total Topics: 3
Total Comments: 6
Hi,
I'm having a headache with this one, I've used WSN on 3 servers already and i wanted to purchase another licence for another domain today but i can't figure out the following problem:
- Client does not support authentication protocol requested by server; consider upgrading MySQL client
Failed! Please check the database info you supplied and try again.
Access denied for user 'ODBC'@'localhost' (using password: NO)
This is on IIS server (i'm installing it for a company that has its own server).
I can create users and tables and everything i want when i use the command lines on the server everything is fine.
And i even tried with all users including the "root"
BUT when trying to install i have this.
MYSQL version is 4.1 and it is a basic install of PHP + mysql on a SUB-domain (problem?..should not be)
Please help me, i'm used to WSN now, i don't want to have to use another script !!
Thanks.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It says you need to create and use a mysql username and password. Whatever you supplied in the WSN setup isn't what you put in mysql. And it indicates it's not using a password, which is odd and sounds like a gaping security hole in the server.
The message at the top suggests that mysql is wrongly installed with mismatched client vs. server versions, and tells you to upgrade the mysql client. (I don't know if simply using a wrong username/password would cause this error to appear misleadingly or not.)
You'd best check an IIS or MySQL forum, I don't have any experience setting up MySQL on IIS.
Beginner
Usergroup: Customer
Joined: Mar 15, 2005
Total Topics: 3
Total Comments: 6
Thanks for your answer Paul.
Actually im using the right user/password that's why i don't understand, probably a wrong intall yes.
I'll post the answer if i can find it.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
'ODBC' seems like an odd mysql username. Isn't ODBC some sort of microsoft database thing?
Beginner
Usergroup: Customer
Joined: Mar 15, 2005
Total Topics: 3
Total Comments: 6
Hi Paul,
Glad to tell you we've fixed the problem by using PHP version 4.3.10, MySQL version 3.23.49-nt. (for those who would have the same issues)
We'll purchase and install next week