Help php script access phpMySQL database

helpmeok · #1 (**permalink**) 06-30-2008, 12:37 AM

I have a php script that is that far away form accessing a phpMySQL database. Perhaps someone can look at it and tell me what to do next. pms.helpmeok.com

Jacob · #2 (**permalink**) 07-01-2008, 08:57 AM

What?

Please post the PHP in the php tags so that we can see more accurately.

The link is being removed due to lack of post count.
Please be more specific, like what your error is, etc.

If you do not reply to this topic or edit your first post, the thread will be deleted.

helpmeok · #3 (**permalink**) 07-01-2008, 02:05 PM

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'tothabr'@'localhost' (using password: YES) in /home/prisp/public_html/helpmeok/pms/dab.php on line 8
Unable to select database

you can run my program and see the code at pms.helpmeok.com

Jacob · #4 (**permalink**) 07-01-2008, 09:42 PM

Have you made sure you've connected to your database?

I kind of can't look at your code, because I'm on my phone.
If you posted it here, I could help more.

Edit: oh, missed the error.
You got the connection to your db by the looks of it.
Make sure your username is in the form of

Code:

 cpaneluser_databaseuser

So if your cpanel log in was PMS, and your DB username was smp, then your log in would be...

Code:

PMS_smp

this doesn't go for your password.
Make sure you have written your db name i n the form of

Code:

 cpanelusername_dbname

For example, you cpanel log in is PMS, and your DB name is db, it'll appear

Code:

PMS_DB

Another thing, make sure you've added the username to the database with full permissions.

HBZSoftware.com · #5 (**permalink**) 07-07-2008, 06:31 AM

You need to make sure your database user has permission to access your database, and make sure your MySQL username and password are the same as the ones you are using in your code.