Php not rendering

[Ch3vr0n]

Im running apache 2.0.54 and php 5.0.4, mysql 4.1.13a and phpMyAdmin All is installed well and when i open the page with <?php phpinfo(); ?> the basic info is displayed.

The problem persists in 3 variations.

v1) I have a copyright made up, and the table has been created locally with the right values. But instead of showing the info i get "Access denied for user 'ODBC'@'localhost' (using password: NO)" while in the php code the password and login have been set to the local admin account data. I dont know how to change that username "root". So the copyright dont work locally (it works fine online but im rewriting my website).

v2) I have a page with a menu on top that generates a table with info via php into an iframe, same issue it works fine online but not offline. All it does when clicking on one of the link is showing the same page including menu links in that iframe and not rendering the code.

on almost all pages with mysql_connect i get that ODBC error. Can somebody help me ?

[Xnuiem]

the first error is just a permissions issue. You need to add the user to MySQL and set it up to access with the correct permissions and database. If you do an insert instead of a grant, make sure to bounce MySQL.

I dont really understand the second issue, define "offline" for me.

[Ch3vr0n]

i installed apache, mysql, php, ... on this pc. So that defines offline (online = my webserver). (windows)

the main user that was through the setup config wizard was "root" and a password i chose. So how can i and another user ?

Insert ?? Grant ?? bounce mySQL ???

[Xnuiem]

Insert & Grant are both types of MySQL statements, bouce means to restart.

I dont know about your "offline" issue, you may need to examine what is different between your servers. Start with URLs to make sure you are using relative ones anywhere you can.

Somewhere you are attmpting to connect to MySQL using the ODBC username, that should change to "root" i assume from your posts.

[Ch3vr0n]

my official webserver runs on linux, im want to test my new site on my pc (windows). The server settings are using "localhost" MySQL connections are made with user "root" and the password. Thats why i dont understand what that ODBC does there.

So how can i add an extra mysql or phpmyadmin user, if that is needed to fix ?

[Xnuiem]

It might be some type of default in the php, i dont know where else the ODBC would come from.

You can google for how to add a user to MySQL for your version, it would be a lot easier than trying to figure out my explaination.