Trouble With PHP/MySQL, Permissions??? Options

[Uronacid]

The connection to the database is fine, however I keep getting the following error when I attempt to run a query:
Access denied for user 'administrator'@'localhost' (using password: NO)

Here is my PHP:

CODE

<?php
        //this script connects to the mysql server database
        
        $username = 'administrator';//stores the username
        $password = "********";//stores the password
        
        if ($dbc = mysql_connect('127.0.0.1', $username, $password)) {
            
            print '<p>Successfully connected to the MySQL!</p>'; //print a message if it was a success
            mysql_close(); // close the database
            
            if (@mysql_query('CREATE DATABASE myblog')) {//Try to create the database
                
                print '<p>The database has been created!</p>';//Creating the database was successful
                
            } else {
            
                print '<p style="color: red;">Could not create the database because:<br />;' . mysql_error() . '</p>';
            
            }
            
            if (@mysql_select_db('myblog')) {
                
                print '<p>Database has been selected!</p>';
            
            } else {
            
                print '<p style="color:red;">Could not select the database because:<br />' . mysql_error() . '</p>';
            
            }
        
        } else { //connection failed
            
            print '<p style="color:red;">Could nor connect to MySQL:<br />' . mysql_error() . "</p>";
        
        }
        
    ?>

Successfully connected to the MySQL!

Could not create the database because:
;Access denied for user 'administrator'@'localhost' (using password: NO)

Could not select the database because:
Access denied for user 'administrator'@'localhost' (using password: NO)

[mipadi]

Oh, wait!

CODE

mysql_close(); // close the database

Probably shouldn't close the DB connection if you want to create a database or run SELECT statements.

[Uronacid]

Oh, wait!

CODE

mysql_close(); // close the database

Probably shouldn't close the DB connection if you want to create a database or run SELECT statements.

OMG thank you!!!! *hug* I should have noticed that. Man, it sure helps to have a second set of eyes some time.

Successfully connected to the MySQL!

Could not create the database because:
;Can't create database 'myblog'; database exists

Database has been selected!