DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- PHP (http://www.daniweb.com/forums/forum17.html)

- - mysql_connect (http://www.daniweb.com/forums/thread18811.html)

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!

Re: mysql_connect

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.

Re: mysql_connect

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.