Whats this PHP error mean?

bloom

Hey guys, It wouldnt work connecting to MYSQL databse base with PHP 5 it wouldnt enable it in the PHP, so i went back to PHP 4 where it is automatically enabled now this is error i get

Warning: mysql_connect(): Unknown MySQL Server Host 'bloomdb' (11001) in C:\Program Files\Apache Group\Apache2\htdocs\temp_con.php on line 4
Error - Cannot connect to MYSQL Database

Any idea?

This is doing my head in 🙁

Chris- Thanks in advance!

tsinka

Hi,

that means that the server with the name bloomdb doesn't exist. Check the arguments of mysql_connect.

Thomas

bloom

bloomdb is the database name though, This is the two things im using.

Before i say so you know im using Windows XP - Apache 2 - PHP 4 - MYSQL 4.1.

temp_con.php

<?php
require($_SERVER["DOCUMENT_ROOT"]."/config/db_config.php");

      $connection = mysql_connect($db_name, $db_user, $db_password) or die("Error - Cannot connect to MYSQL Database");
      echo "Connected Successfully";

db_config

<?php
$db_host = "localhost";
$db_user = "root";
$db_password = "password i use to access command prompt in MYSQL";
$db_name = "bloomdb";
?>

If anyone can help me get this sorted id be SO greatful, i am pulling my hair out over this, been trying for days now 🙁

Chris

tsinka

<?php
require($_SERVER["DOCUMENT_ROOT"]."/config/db_config.php");

$connection = mysql_connect($db_host, $db_user, $db_password) or die("Error - Cannot connect to MYSQL Database");
mysql_select_db($db_name,$connection) or die("Cannot select DB");
echo "Connected Successfully";
?>

bloom

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\temp_con.php on line 4
Error - Cannot connect to MYSQL Database

Upgrading MYSQL ?? Im on 4.1 latest one i believe.

Im sorry for being such a nusiance 🙁, I just wnat it to work so much!.

tsinka

MySQL 4.1 is incompatible with the client version used by PHP. Either use the mysqli functions or restart the MySQL server with the option --old-passwords or set the passwords in MySQL with OLD_PASSWORD instead of PASSWORD.

Thomas

bloom

Its embarrasing to ask, but How do i use MYSQLi, As in how will i get PHP to communicate with MYSQL using that ?🙁 .

Im new to this as you can imagine and am feeling really dumb right now 😕 .

Installation
To install the mysqli extension for PHP, use the --with-mysqli=mysql_config_path/mysql_config configuration option where mysql_config_path represents the location of the mysql_config program that comes with MySQL versions greater than 4.1.

I dont even know what that means :queasy:

Chris - Slumps down in embarrasment

tsinka

Ok,

I'd recommend to upgrade to PHP5. You can enable the mysqli extension by copying libmysqli.dll that comes with the zip PHP package to system32. Additionally, make sure that

extension=php_mysqli.dll

is enabled in php.ini.

Then check the manual for some info about mysqli.

Have a look at xampp.

This is an "all incluse" WAMP(S) (and more ... available not only for Windows) package. It's very easy to install and you can switch between PHP4 and PHP5 with just one click.

Thomas