mysql_pconnect problem

[Anon]

Hi,

We have apache 1.3.19, PHP4.0.2 and mysql installed in our redhat linux 6.2 system. For some reasons, we got error message " denied for user: nobody@localhost (Password :YES)". Database in my local machine.

Code: mysql_pconnect("$localhost","$username", "$password") or die ("couldnt connect database");

mysql, php and apache all are located in directory /usr/local/.

I dont know why we got the "nobody@localhost"? In httpd.conf of apache, group and user is nobody, do you think we need to change them, if so, what we should do? by the way, mysql was installed by standard way.

This is errors caused by mysql or php configuration or apache configuration? or mysql database user set up?

thanks,
Hui

[brandonschnell]

check to be sure the proper username & password are being used by php then look at the permissions in mysql. most likely the error is caused by the configuration of mysql.

mysql will try to authenticate you with the first valid username & hostname it finds. if you have a user of nobody@localhost (or "%@") in the mysql permissions, remove the user.

[phui_99]

Hi,

Thanks a lot for help.

When I set up password for user table using mysql, I couldnt get the password what I set, instead of getting one password created by mysql -- very long letter.

Do you think that it is neccesary to edit .sql file in www home directory like /usr/local/apache/htdocs to access mysql database via web interface? Or just store everything in mysql server and retrieve data via PHP code?

In mysql user table, we do have localhost as host, also lot of other names as host too, but don't have nobody as user. However, we do have lot of kinds of users.

Here I am attached couple of files stored in www home directory:

1. //database.php
   <?php

$hostName="localhost";
$userName="pathmicroarray";
$password="pathmicroarray";
$databaseName="searchdb";
$userTableName="sample, gene, GB"; // some tables name for searchdb

$PHP_AUTH_USER="";
$PHP_AUTH_USER="";
?>

2. database.sql // databasetables

MySQL dump 6.4

Host: localhost Database:searchdb

create database searchdb;
use searchdb;

#

Table structure for 'GeneFeature"

#
CREATE TABLE Gene ( //
CREATE TABLE sample (// cut content
CREATE TABLE GB (//
....

3. use mysql;

insert into user
values('%','pathmicroarray','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y');
flush privileges;

insert into user
values('localhost','pathmicroarray','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y','Y','Y');
flush privileges;

UPDATE user SET Password=PASSWORD('pathmicroarray') WHERE
user='pathmicroarray';
FLUSH PRIVILEGES;

sorry for the long email.

Once again, appreciate your advice.

Hui