Posted by Nathan on 07/12/05 13:34

Hi folks, I wonder if you could help me.

I've done a site for someone and it was developed on my machine, using
Apache. Now I've handed the site over to them, they're trying to get it
to run on IIS.

Now the difficulty is because of their own personal security reasons I
can't even get FTP in for the files or see their computer to have a look
as to what might be causing the problem, and yet they keep asking me if I
know how to solve the problem (grr):

MySQL won't connect.

Using the code:

$db = mysql_connect("localhost", "username","password");
$dbok = mysql_select_db("dbname");

doesn't actually produce any errors but all the mysql_query() say:

Access denied for user 'ODBC'@'localhost' (using password: NO)

So, I suggested maybe he creates the account again using the username
"ODBC", but same errors again.

In mysql he says he did this:

Grant all privileges on *.* to 'odbc'@'localhost' identified by
'password' with GRANT OPTION;

What's also weird, is this was all happening on a 'setup' script designed
to initially create tables and populate the data.

on the main site, it's not giving any errors, but it's not actually
connecting to the database either. As if it's all empty.

It seems like it's connecting to mysql, but not actually sending username
or password so that it gets an access denied.

Does anyone have any experience with setting up IIS for php and MySQL?

Thanks in advance, they wouldn't have had this problem if they'd used
apache, grumble grumble :)

--
Nathan.
Bow to the Cow!

[Back to original message]