Re: [LHA-misc] mysql question ...

[Neil C. <nc...@ho...>]

Andy Worthington wrote:
> 
> How exactly are you accessing it and what is the message it is giving back.

Remember this is PHP:

  $XHost = "diane";
  $XPort = 1128;		// Too bad we can't use its names instead

  $dbuser  = 'LHAP';		//
  $dbhost  = 'localhost';	//
  $dbpass  = 'LHAP';		// Please use a better one than the default!
  $dbname  = 'X10';		//
  $dbtable = 'device';		//

  //------ DATABASE CONNECTION --------//
  $mysql_link     = mysql_connect($dbhost, $dbuser, $dbpass); // Line 97
  $column         = mysql_list_fields($dbname, $dbtable, $mysql_link);
  $sql            = "SELECT * FROM $dbtable;";
  $result         = mysql_db_query($dbname, $sql);


Warning MySQL Connection failed: Access denied for user 'LHAP@localhost'
(Using password YES) in /.../lhap.php on line 97

BTW: I have the db access working now, as soon as I figure out the
user issue I'll post everything. It's slow but not too bad.

-- 
Linux Home Automation           Neil Cherry             nc...@ho...
http://members.home.net/ncherry                         (Text only)
http://meltingpot.fortunecity.com/lightsey/52           (Graphics)
http://linuxha.sourceforge.net/				(SourceForge)