apache+php+mysql problem

Ding Li achillis2002 at gawab.com
Thu Jun 24 23:55:18 UTC 2004


Hi,all

I followed the instruction to configure apache+php+mysql at 
http://www.hut.fi/~tkarvine/lamp-linux-apache-mysql-php.html.

|1.edit /etc/httpd/conf/httpd.conf|
Find the section about homepages by searching |ctrl-W| for public_html, 
then comment out the line with |UserDir disable| and remove the comment 
char "|#|" from the line
|UserDir public_html|
2.|/etc/init.d/httpd restart|
|3.|Create a directory for homepages. Home directory, public_html and 
all directories under public_html must be executable (x) by all, so that 
web server can access files under them if it knows their name. Files 
must be readable by the web server.

|cd $HOME|
|mkdir public_html|
|echo "my homepage" > public_html/index.html|
|chmod a+x $HOME $HOME/public_html|
|chmod a+r $HOME/public_html/index.html|

Now Apache is working. I can see the webpage from http://localhost/~username

4.create hello.php at |$HOME/public_html|
|<?php echo "Hello PHP World, 2+2 is " . (2+2); ?>
Text outside code block is printed normally to web page.

Php should work as well. I can see the result by connecting to 
http://localhost/~username/hello.php


5.create mysql datebase.
||mysql|
||>
|USE test;
SHOW tables;
CREATE TABLE persons( name VARCHAR(50), email VARCHAR(50) );
SHOW tables;
DESC persons;
INSERT INTO persons VALUES('Tero Karvinen', 'karvinen at-sign iki.fi');
SELECT * FROM persons;
INSERT INTO persons VALUES('Sample Person', 'recycle at nosuch.invalid');
SELECT * FROM persons;
QUIT;

6.create ||$HOME/public_html/database.php, just copy and paste, save as 
database.php.


7. http://localhost/~username/database.php

|It works fine until the last step(7th step).I didn't get the correct 
result. Instead, I got an error

PHP database example - http://iki.fi/karvinen.

*Warning*: mysql_connect(): Access denied for user: 'root at localhost' 
(Using password: NO) in */home1/dingli/public_html/database.php* on line *8*
Could not connect : Access denied for user: 'root at localhost' (Using 
password: NO)


I think I might need to set the mysql password? But I have no idea 
what's going on of mysql since I'm new to mysql. Could anyone help me to 
figure out what's wrong? and how can I let php+mysql work? I put some 
useful info at the end.

My system is FC1 and here are the packages I installed:
$ rpm -aq | grep httpd
redhat-config-httpd-1.1.0-5
httpd-manual-2.0.47-10
httpd-2.0.47-10
$ rpm -aq | grep php
php-pgsql-4.3.4-1.1
phpMyAdmin-2.5.0-1rh
php-ldap-4.3.4-1.1
php-4.3.4-1.1
php-imap-4.3.4-1.1
php-odbc-4.3.4-1.1
php-mysql-4.3.4-1.1
$ rpm -aq | grep mysql
mod_auth_mysql-20030510-3
mysql-server-3.23.58-4
mysql-3.23.58-4
php-mysql-4.3.4-1.1

Thanks for any replies.;)

Ding





More information about the fedora-list mailing list