mysql_connect

Reply

Join Date: Feb 2005
Posts: 3
Reputation: dannyshi is an unknown quantity at this point 
Solved Threads: 0
dannyshi dannyshi is offline Offline
Newbie Poster

mysql_connect

 
0
  #1
Feb 17th, 2005
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!
Reply With Quote Quick reply to this message  
Join Date: Feb 2002
Posts: 12,035
Reputation: cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light cscgal is a glorious beacon of light 
Solved Threads: 128
Administrator
Staff Writer
cscgal's Avatar
cscgal cscgal is offline Offline
The Queen of DaniWeb

Re: mysql_connect

 
0
  #2
Feb 17th, 2005
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.
Dani the Computer Science Gal
Follow my Twitter feed! twitter.com/daniweb
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 31
Reputation: mcldev is an unknown quantity at this point 
Solved Threads: 2
mcldev mcldev is offline Offline
Light Poster

Re: mysql_connect

 
0
  #3
Feb 19th, 2005
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC