MYSQL Access problem

[g]

I have a php scripted that access a mysql database. I use the same
access methods in other scripts and it access it the database fine:

if (!($connection = @ mysql_pconnect($hostName,
$username,
$password)))
showerror();

if (!mysql_select_db($databaseName, $connection))
showerror();
but I have one script were I get the error message:

Access denied for user: '@localhost' to database 'winestore' (# 256).

So is there something else it could be expect the password or user
name???

[dariush]

You may try something like this

<?php

$lnk = mysql_connect('localhost', 'mysql_user', 'mysql_password')
or die ('Not connected : ' . mysql_error());

// make foo the current db
mysql_select_db('foo', $lnk) or die ('Can\'t use foo : ' . mysql_error());

?>Database Migration ExpertsSQLPorter(Database migration
toolkit)www.realsoftstudio.com"g" <th********************@yahoo.co.uk> wrote
in message news:20**************************@posting.google.c om...

I have a php scripted that access a mysql database. I use the same
access methods in other scripts and it access it the database fine:

if (!($connection = @ mysql_pconnect($hostName,
$username,
$password)))
showerror();

if (!mysql_select_db($databaseName, $connection))
showerror();
but I have one script were I get the error message:

Access denied for user: '@localhost' to database 'winestore' (# 256).

So is there something else it could be expect the password or user
name???

[Yves Brault]

It seems that your variable $username is not defined or is empty...
"dariush" <da*****@realsoftstudio.com> wrote in message
news:M0*******************@news20.bellglobal.com.. .

You may try something like this

<?php

$lnk = mysql_connect('localhost', 'mysql_user', 'mysql_password')
or die ('Not connected : ' . mysql_error());

// make foo the current db
mysql_select_db('foo', $lnk) or die ('Can\'t use foo : ' . mysql_error());

?>Database Migration ExpertsSQLPorter(Database migration
toolkit)www.realsoftstudio.com"g" <th********************@yahoo.co.uk> wrote in message news:20**************************@posting.google.c om...

I have a php scripted that access a mysql database. I use the same
access methods in other scripts and it access it the database fine:

if (!($connection = @ mysql_pconnect($hostName,
$username,
$password)))
showerror();

if (!mysql_select_db($databaseName, $connection))
showerror();
but I have one script were I get the error message:

Access denied for user: '@localhost' to database 'winestore' (# 256).

So is there something else it could be expect the password or user
name???