nixCraft

I am having problems accessing Mysql with PHP on Fedora Core 4. My code is one that I copied to suit my case from Hard Coder as follows:
<?
$dbhost="localhost";
$dbuser="root";
$dbpassrd="adminpass";
$dbname="guestbk_db";
$dbconnect=mysql_connect($dbhost, $dbuser, $dbpassrd) or die("Error Connecting the Database Server!");
mysql_select_db($dbname, $dbconnect) or die("Error Selecting the Database!");
?>

When I try to load the pages I get the error as defined on die() above.

Any better way I can get it fixed. I googled some sites which hinted on installing php-mysql rpm. I did that but it went on asking for more files. I am using Fedora Core 4. I checked my installation on Webserver and Database Server, everything is installed. So where can be the problem? What do I do?

Ngalye
(newbie Linux newbie)

What does your phpinfo() command says? Do you have the proper mysql libraries loaded?

In a new file on your web server, type the following:
Open the file within your browser. It shows all the loaded modules/extensions within PHP. Check for any mysql related extensions.

Use yum command to install php and related dependencies.

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

Thank you Amitabh,

For the code above, I got the PHP info page loaded. Here's the extract from Mysql support table. I copied everything for your expert eyes to figure out if there's something missing.



mysql

MySQL SupportenabledActive Persistent Links 0 Active Links 0 Client API version 4.1.11 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
DirectiveLocal ValueMaster Valuemysql.allow_persistentOnOnmysql.connect_timeo ut6060mysql.default_hostno valueno valuemysql.default_passwordno valueno valuemysql.default_portno valueno valuemysql.default_socketno valueno valuemysql.default_userno valueno valuemysql.max_linksUnlimitedUnlimitedmysql.max_persist entUnlimitedUnlimitedmysql.trace_modeOffOff

mysqli

MysqlI SupportenabledClient API version 4.1.11 MYSQLI_SOCKET /var/lib/mysql/mysql.sock


DirectiveLocal ValueMaster Valuemysqli.default_hostno valueno valuemysqli.default_port33063306mysqli.default_pwno valueno valuemysqli.default_socketno valueno valuemysqli.default_userno valueno valuemysqli.max_linksUnlimitedUnlimitedmysqli.reconnect OffOff

Is it that I did not specify port number on my code?

Over to you again,...

Noel.