I have created a mySQL database (my first), and successfully tested it within phpMyAdmin. Now I'm trying to connect to it through a php program, and it's not working. I get this message:



(The actual message, of course, contains my actual database user name and database name.)
Here is the code I'm using. The values I enter in each of the variables exactly matches the values that appear in phpMyAdmin for my database. The code below has "dummy" values, except for the value 'localhost', which is what is actually in my code.



...what am I missing, that keeps me from being able to get to my database?

Hi,

Usually, I wouldn't define constants for this, I would just do a variable, however it's irrelevant to the problem.

From what, I see, you're missing the MySQL resource identifier in your mysql_select_db function.

Try altering the line:



And see if that helps. Notice, I added the $dbc (your connection identifier) as the second argument to the mysql_select_db function.

Try that and see if it helps!

Sincerely,

Thanks for the suggestion...

Tried it again twice, once simply adding the second argument as you suggested, and then again by also using constants instead of variables in the call.

No go; both times I get the same result as before.
Apparently I connect to mySQL okay, but am denied access to my database.

I also tried two variations of my dbusername: once with the username preceded by my domain account name ('accountname_dbusername'), and once without the 'accountname_' prefix. Same result - the error message mirrors back the name I attempt, and says access is denied.

Ernie

In cPanel, below the section where you create MySQL databases and users, did you grant permissions to this database for that new user you created?

Hi,

I took care of it for you. Try accessing your database now.

For future reference, when you create a user and a database, you also have to assign permissions to access the database.

You'll see the first section on the MySQL page where it says:

User <select menu> DB: <select menu>
Privilages <checkboxes>

Add User to DB

Just complete that form and you should be all set!

I'm pretty sure I had assigned privileges... I left the "ALL" checkbox checked, right after the word Privileges, when I created the user.

In any case, I have now copied&pasted the php code that was displayed by phpMyAdmin, and I think I'm successfully connected...

not sure what was different, from the code I originally entered... couldn't see a difference at first glance, but I'll go look more closely now.

Thanks again,

Ernie

Gremlins

Of the human type ?

Caveman

Ah, something else I notice now that wasn't "intuitively obvious" in phpMyAdmin:

YOu have to "add user" twice --- first, to create the user, in the panel underneath the "main" database maintenance panel, and then, INSIDE the main maintenance panel, you have to ADD that newly created user. The second "add user" seems to be the step that actually assigns privileges...

Ernie