| | |
mysql_connect
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Feb 2005
Posts: 3
Reputation:
Solved Threads: 0
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!
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!
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.
•
•
Join Date: Feb 2005
Posts: 31
Reputation:
Solved Threads: 2
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.
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.
![]() |
Similar Threads
- Call to undefined function mysql_connect() (PHP)
- Warning: mysql_connect(): Access denied (PHP)
- Problems with PHP and the mysql_connect() command. (PHP)
- help with mysql_connect(); (PHP)
Other Threads in the PHP Forum
- Previous Thread: PHP-Nuke Tutorial #1: Altering the Header Tags
- Next Thread: DNS record types
| Thread Tools | Search this Thread |
apache api array basic body broken cache cakephp class cms code computing confirm cron curl customizableitems database date date/time delete dynamic email error file filter folder form forum freelancing function functions gc_maxlifetime google header headmethod howtowriteathesis href htaccess html iframe image include ip javascript joomla limit link list login malfunction memmory memory menu method mod_rewrite msqli_multi_query multiple mycodeisbad mysql navigation neutrality oop parameter parsing paypal pdf php phpmysql query question random recourse regex root script search select seo server sessions snippet soap source space sql static support! system table thesishelp trouble tutorial update upload url variable web webdesign xml youtube







