954,585 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

mysql_connect

hi can anybody please help me with this,
i had install a php script but i got some problem with mysql_connect

the below is the error message:

Warning: mysql_connect(): Access denied for user: 'maximus_dbwebnews@localhost' (Using password: YES) in /home/maximus/public_html/webnews/WebNews/admin/func/db.inc.php on line 25
Database error: Link-ID == false, pconnect failed
MySQL Error: 0 ()
Session halted.

http://www.maximus-host.com/webnews/

i dont know what to do with this, and where is wrong?

please anyone help me with this!
Thank You!

dannyshi
Newbie Poster
3 posts since Feb 2005
Reputation Points: 10
Solved Threads: 0
 

Your php script can't connect to the database. Open the file db.inc.php and make sure that the server name (usually localhost), database name, database username, and database password are all correct.

cscgal
The Queen of DaniWeb
Administrator
19,432 posts since Feb 2002
Reputation Points: 1,474
Solved Threads: 230
 

Before you start cooking up PHP, ASP, PERL or other scripts I highly recommend making sure your User Access to your database is viable. To the point use MySQL Administrator or MySQL QueryBrowers or if you prefer the cmd line you can use mysql.exe

Make sure the Users have been GRANT'd access for the DATABASE on the HOST you are planning on using. For example, if you have a user called dbuser that needs to root access to database Maximus from host woobie you would need to:

GRANT ALL ON maximus.* TO dbuser@woobie IDENTIFIED by 'password'

Now if ol' dbuser is a shared access account that say can be used on multiple client computers you should wildcard the host. Thus a SQL statement like:

GRANT SELECT, INSERT, UPDATE, DELETE on maximus.* TO dbuser@'%' IDENTIFIED BY 'password'

Your case is probably related to the user name not being allowed to access the database from the host you are running the app. Thus revisit the user accounts and you should be able to trace it back from there. Note - I would definitly use a tool like MySQL Query Browser to validate the user logins and capabilities BEFORE I started applying scripts.

mcldev
Light Poster
31 posts since Feb 2005
Reputation Points: 10
Solved Threads: 3
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You