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]

Were you able to create the database?

[Uronacid]

Were you able to create the database?

I applogize, here is the full read out from my PHP:

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)

I'm able to create the database from the backend using the admin username/password and the following commands:


1. mysql -u root -p
2. <my password>
3. CREATE DATABASE myblog;


I'm unable to do it via PHP.

[mipadi]

What versions of MySQL and PHP are you using?

[Uronacid]

What versions of MySQL and PHP are you using?

Hmmm, how would I check that on Ubuntu?

[mipadi]

`php --version` and `mysql --version`

[Uronacid]

`php --version` and `mysql --version`

PHP 5.2.6-2ubuntu4.2 with Suhosin-Patch 0.9.6.2 (cli)
mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2

[mipadi]

Hm...that error can happen if you're using MySQL > 4.1 and PHP < 4, but it looks like you're okay. Hrm...

[Uronacid]

Hm...that error can happen if you're using MySQL > 4.1 and PHP < 4, but it looks like you're okay. Hrm...

Yeah, I know, I've been browsing the internet like a wild animal looking for a reason but I just can't seem to find one. I checked the php.ini file and everything seems OK, and I don't think this has any thing to do with nginx. I would venture to guess that PHP just talks directly with the MySQL service and relays the informations back to the webserver to display on the webpage. :/

[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!

[Mickey]

Topic closed & moved.