DaniWeb Forum Index > Web Development > PHP

help with mysql_connect();

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2004

Posts: 27

Reputation: odee is an unknown quantity at this point

Solved Threads: 0

odee

Offline

Light Poster

help with mysql_connect();

Feb 22nd, 2005

i can't connect to mysql. the error is

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in 
C:\Documents and Settings\...
Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in 
C:\Documents and Settings\...

im using the script here in the php tutorial:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$Host = "mysqllocation"; //location of mySQL on server
$User = "username"; //my username
$Pass = "mypass"; //my password
$Name = "db"; //name of the database to be used
$Table = "tabledb"; //name of the table within the database
 
mysql_connect ($Host, $User, $Pass, $Name, $Table) or die 
("unable to connect to database");
@mysql_select_db("$Name") or die ("unable to select DB");
$sqlquery = "SELECT * FROM $Table WHERE opinion = 'is horrible'";
$result = mysql_query($sqlquery);
$number = mysql_num_rows($result);
$Host = "mysqllocation"; //location of mySQL on server
$User = "username"; //my username
$Pass = "mypass"; //my password
$Name = "db"; //name of the database to be used
$Table = "tabledb"; //name of the table within the database

mysql_connect ($Host, $User, $Pass, $Name, $Table) or die 
("unable to connect to database");
@mysql_select_db("$Name") or die ("unable to select DB");
$sqlquery = "SELECT * FROM $Table WHERE opinion = 'is horrible'";
$result = mysql_query($sqlquery);
$number = mysql_num_rows($result);

•

Join Date: Feb 2005

Posts: 31

Reputation: mcldev is an unknown quantity at this point

Solved Threads: 2

mcldev

Offline

Light Poster

Re: help with mysql_connect();

Feb 22nd, 2005

IMHO, definitely upgrade MySQL if you can (depends on data migration basically). Just remember the later the version the more stable and feature rich the release. One other thing about connecting to MySQL or any other SQL server for that matter. However if your data set is small or reproducible then by all means proceed with the upgrade to the latest "stable" release.

Now back to your MySQL connect issue. Since the connect operation is your authentication into the DBMS it should be treated as an atomic operation. That is, pass or fail. Similarly the select is critical unless somehow your app can switch to a different DB which is highly unlikely. So.... here is an example you can customize that uses the die() function. From a networking perspective - MAKE SURE YOU CAN USE MySQL Query or MySQL Administrator with the user name, password, and DB so that you can prove the context. If it fails then you must GRANT access most likely.

<?php
define("DB_USER", "dbuser");
define("DB_PASSWORD", "dbuser99");
define("DB_HOST", "192.168.1.220");
define("DB_NAME", "test");

// Connect to the MySQL server
$db_connection = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or
die('Could not connect to MySQL: ' . mysql_error());

// Select the database
mysql_select_db(DB_NAME) or die('Could not select the database: ' . mysql_error());
?>