red hat , apache , mysql and php

[slam]

Trying to get this working.
Installed red hat 8. with apache, mysql, php as initial install options
php works with a test <?php info()?> shows --with-mysql=shared/usr

but I cannot access functions of mysql I get an err
Fatal error: Call to undefined function: mysql_connect() in /var/www/html/view.php on line 1

any ideas

[Dolda2000]

Do you have mysql support in your PHP distribution? Is this somehing that you've compiled yourself or something that came with the distro?

[slam]

this came with the distro and I chose the options in red hat setup to run php. mysql and apache.. I didn't compile it by hand.

edit:
the php is 4.2.2 which should support mysql

[slam]

bump

[sykkn]

Have you installed php-mysql? If not ... that could be your problem.

[slam]

I installed apache,php and mysql all at initial os install
php works (ie php info gives me details such as --with-mysql (installed))
but database access does not.

[Dolda2000]

What sykkn means is that there is a package that is required for the actual integration between PHP and MySQL, namely the php-mysql package. It mainly provides the shared object /usr/lib/php4/mysql.so.

[slam]

Installed red hat without apache , php or mysql
then downloaded all 3
unzipped.
tried to install mysql got errors
ran rpm and installed mysql
now my sql says
access denied for user root@localhost (using password no)

any ideas why I cannot log into mysql

then I plan on reinstalling php and apache
is the php-mysql thing in the php download? or is that somewhere else

[genlee]

mysql_install_db

to reset your password.

[wassy121]

mysql was actually a bastard to set up from source. It took me like 45 minutes, and I have done it before too. I can usually install a package in like 10 minutes (I have it down to a science). Pitfalls to watch out for: Make sure you have a default /etc/my.conf (or wherever your sysconfdir is). Make sure it is actually named my.cnf. Yeah, that took me 10 minutes to find. Also, make sure /var/data (or wherever your localstatedir is) is owned by the person running mysql (usually mysql or mysqld or daemon). Make sure you have innodb either set up correctly, or turned off. That was another 15-20 minutes. Stupid mysql It is okay, the end result (bugzilla running happily) was worth it.