| | |
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 |
5.2.10 action apache api array basic beginner binary broken cakephp checkbox class classes cms code computing confirm cron curl database date delete destroy display domain dynamic echo echo$_get[x]changingitintovariable... email error fatalerror file files folder form forms function functions google header href htaccess html iframe image include indentedsubcategory insert ip javascript joomla limit link load local login mail malfunction menu mlm mod_rewrite multiple mysql mysqlquery neutrality oop paypal pdf php query radio random record reference remote return script search server sessions sockets source space sql syntax system table thesishelp tutorial unset update upload url validation validator variable video web window.onbeforeunload=closeme; youtube







