cannot select database

Status
Not open for further replies.

slyrzmb

New Member
Messages
3
Reaction score
0
Points
0
I am having a problem selecting my database after connecting to it using PHP. I am building a simple login but it wont select my db....some help please...i can't find anywhere in phpAdmin where i can set privileges to connect....
 

descalzo

Grim Squeaker
Community Support
Messages
9,373
Reaction score
326
Points
83
Any error messages?
Are you using mysql_XXXX or mysqli_XXXX ?
Are you testing the result of xxxx_connect() to see if it is valid vs being false?
 

gomarc

Member
Messages
516
Reaction score
18
Points
18
If you already created the database, go to cPanel->MySQL Databases to Add New User and then Add User To Database. Finally don’t forget to give this user the appropriate privileges.

If you want to start from scratch, use cPanel->MySQL Database Wizard through all the steps.
 

stpvoice

Community Support Rep
Community Support
Messages
5,987
Reaction score
212
Points
63
Ensure that you give a MySQL user the appropriate privelages for what you want to do-or it will not work and give you error messages.
 
Status
Not open for further replies.
Top