PHP not recognizing admin in MySQL

gizelle · #1 (**permalink**) 04-15-07, 07:28 PM

I'm new to both PHP and MySQL. I have set up MySQL and my databases show up, I can do queries from MySQL. Things are fine.

Now I am trying to create and access MySQL databases using PHP. Unfortunately they always start out with defining a 'user' and 'password'. As I am the administrator (on my home computer), when I go into MySQL Monitor, it immediately asks for my password. There is no area to differentiate there are different user accounts. It assumes I am the administrator.

When setting up MySQL, it never asked for a name, just a password. I tried setting up another user account with password and Granted full privileges to all databases. However when I put in that name and password, nothing happens. I don't even get the error messages I programmed in (if I did it right.).

I'm not looking for homework help. I'm just wondering if I installed something wrong or left out a step with MySQL and now the PHP is not acknowleging.

Anyway, here is my code:

PHP Code:


			
$DBConnect=@mysqli_connect("localhost", "user name", "password")

    Or die("<p>Unable to connect to the database server.</p>" . "<p>Error code " . mysqli_connect_errno() . ":" . mysqli_connect_error()) . "</p>";

    

$DBNAME="hit_counter";

if (!@mysqli_select_db($DBConnect, $DBName) ) {

    $SQLstring="CREATE DATABASE $DBName";

    $QueryResult=@mysqli_query($DBConnect, $SQLstring)

        Or die("<p>Unable to execute the query.</p>" 

        . "<p>Error Code " . mysqli_errno($DBConnect)

        . ":" . mysqli_error($DBConnect) ) . "</p>";

        mysqli_select_db($DBConnect, $DBName);

    }

$TableName="count";

$SQLstring="SELECT * FROM $TableName";

$QueryResult=@mysqli_query($DBConnect, $SQLstring);

if (!$QueryResult) {

    $SQLstring="CREATE TABLE $TableName (countID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY)";

    $QueryResult=@mysqli_query($DBConnect, $SQLstring)

        Or die("<p>Unable to create the table.</p>"

        ."<p>Error code " . mysqli_errno($DBConnect)

        . ":" . mysqli_error($DBConnect) ) . "</p>";

}

$SQLstring="INSERT INTO $TableName VALUES (NULL)";

$QueryResult=$mysqli_query($DBConnect, $SQLstring)

    Or die("<p>Unable to exeucte the query.</p>"

    ."<p>Error code " . mysqli_errno($DBConnect)

    . ":" . mysqli_error($DBConnect) ) . "</p>";

$Hits=mysqli_insert_id($DBConnect);

echo "<h1>There have been $Hits hits to this page!</h1>";

mysqli_close($DBConnect);

I tried substituting 'root' as the user with my password, but that didn't work either.

I'm working on Windows XP, and it did have mssql already on it. I went into msconfig and unchecked the box for it under 'services' thinking it may be trying to run along with MySQL.

Too new to know if one has anything to do with the other.

Gizelle