Jump to content


Photo

Unable to connect to mysql database


  • Please log in to reply
3 replies to this topic

#1 jones15

jones15
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 15 October 2006 - 01:33 AM

I installed php 5.1.4, Apache 2.2.2 and mysql 5 on a Fedora Core 5 server.

Everything works independently.  I even have phpMyAdmin working fine.  I finally figured out how to get the --with-mysql in the ./configure list (instead of --without-mysql). 

Yet when I try the mysql_connect command with a host, username and password, I get an error that it can't connect to the database and it doesn't even use the defined username/password. 

It says :  Access denied for user 'apache'@'localhost' (using password: YES).

Where did apache come from?  I don't have it anywhere in my code and its not written anywhere in my php.ini file.

Why doesn't it respect my username!?!

#2 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 15 October 2006 - 01:45 AM

You have to set the admin username and password  for mysql ok.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#3 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 15 October 2006 - 11:01 AM

You have not set the correct permissions for the apache username to connect to  MySQL

You need to setup permissions for the apache username.

#4 jones15

jones15
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 15 October 2006 - 09:58 PM

How do I do that?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users