Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL web connection problem.

Status
Not open for further replies.

Zyxian

Technical User
Apr 29, 2002
42
US
If I have a user who has all rights to a database and can connect to mysql from a shell prompt, see and make changes to that database but when the same user trys to connect via a php page gets an "Access denied for user...." message. What do I need to check/look at to fix this?
 
The "user" isnt the one connecting, your webserver is the one connecting, normally apache will run with group apache and user apache, set up a user called apache and allow access rights to the db. ***************************************
Party on, dudes!
[cannon]
 
Well I fixed it. I had only grant'ed the user@localhost. I needed to grant user@machine.domain.com. Once I did that I was able to get in via the web.

Thanks KarveR for the quick response.

Zyxian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top