From: Wayne G Leslie
Date: November 26 2012 4:55am
Subject: mysql and php not communicating after upgrade
List-Archive: http://lists.mysql.com/php/218
Message-Id: <1AAF5CE8DF7F974C85131EA9B2FE63B002A163@OC11EXPO26.exchange.mit.edu>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_000_1AAF5CE8DF7F974C85131EA9B2FE63B002A163OC11EXPO26exchang_"

--_000_1AAF5CE8DF7F974C85131EA9B2FE63B002A163OC11EXPO26exchang_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


During a recent system software upgrade (CentOS) on the front-end of our co=
mputing cluster, the mysql area was upgraded without our realizing that it =
was going to be.  Now, php and mysql do not communicate  well with one anot=
her. The version of mysql on the system after the upgrade is 5.1.61.  The m=
ysql originally used was 5.0.45.  PhP was not upgraded and sits at version =
5.3.3.

Execution of a simple php script on our web server

<?php
DEFINE('DB_USER','root');
DEFINE('DB_PASSWORD', 'XXXXXXX');
DEFINE('DB_HOST', 'localhost');
DEFINE('DB_NAME', 'mysql');

$dbc =3D mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);

if (!$dbc) {
    die('Connect Error (' . mysql_errno() . ') ' . mysql_error());

$db_selected =3D mysql_select_db(DB_NAME);

if (!$db_selected) {
    die ('Can\'t use' . DB_NAME . ': ' . mysql_error());
}

echo 'Success... Your connection to the Database is working';
}
?>

gives the result - Connect Error (1045) Access denied for user 'root'@'loca=
lhost' (using password: YES)

While I can access mysql in a simple fashion [mysql --user=3Droot --pass=3D=
XXXXXXXX gives me a mysql prompt], a straightforward mysqladmin command (my=
sqladmin version) gives a similar error to the Connect Error above:

mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Do I have a msyql/php version mismatch?  I have tried a number of potential=
 remedies I found on line but have been unsuccessful to this point.  Guidan=
ce from experts would be much appreciated.

Wayne Leslie

--_000_1AAF5CE8DF7F974C85131EA9B2FE63B002A163OC11EXPO26exchang_--