ODBC Connection?

MaxD

I've just set up mySQL 4.1 and created a simple test script. When I run the script it gives me this warning:

Warning: mysql_connect(): Access denied for user 'ODBC'@'localhost' (using password: YES) in E:\WWW\Apache2\htdocs\MD-design\dbtest.php on line 15

I seem to remember the last time I set a server up (on Win98se) I had to add an ODBC connection in the ODBC Data Source Administrator in my Control Panel. But I don't remember how to do this, or if it's still valid, nor can I find any useful information online.

I would have figured that between mySQL's msi installer, the configuration program and MySQL Administrator, this wouldn't be an issue, but I was wrong.

Any help or hints would be greatly appreciated.

bastien

Not required to set up a dsn. You need to tune the mysql a little bit (I am assuming this was an upgrade from a previous version)

from the manual
After upgrading, update the grant tables to have the new longer Password column that is needed for more secure handling of passwords. The procedure uses mysql_fix_privilege_tables and is described in Section 2.10.7, “Upgrading the Grant Tables”. If you don't do this, MySQL will not use the new more secure protocol to authenticate. Implications of the password-handling change for applications are given later in this section.

MaxD

nope fresh install

planetsim

Did you edit anything in the MySQL DB Tables. (MySQL DB has most of the user, db, table configuration).

MaxD

I made a new schemata, but I didn't touch the "mysql" schemata.

MaxD

I've been playing around with MySQL Admin, and found an area to assign query privaledges to users, so I gave "root" all the privaledges, and now I'm getting the error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in E:\WWW\Apache2\htdocs\MD-design\dbtest.php on line 2

line 2 is this:

$link = mysql_connect("localhost", "root", "password")

any ideas?

bastien

ty using the mysqli library. uncomment it in the ini file and comment out the mysql library

MaxD

there is no mySQLi entry in my php.ini file. I've tried uninstalling everything and reinstalling everything, Apache2, then PHP4.3.1, then mySQL4.1
I used the windows installer for each.

But it still won't work. I'm missing something, and I can't find this issue in any manual or tutorial.

bastien

the windows installer will NOT give you the full php package with all the librabries...download the zip version and extract the libraries from that