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

[Jonas D. <jon...@ax...>]

Have you:
1) Added the user/host/password to to the user table of the mysql database? Set the password correctly (Password=password('LHAP')) ?
2) Issued a 'FLUSH priviliges' or a 'mysqladmin reload'

brgds
Jonas

> -----Original Message-----
> From: Neil Cherry [mailto:nc...@ho...]
> Sent: den 29 maj 2001 05:01
> To: lin...@li...
> Subject: Re: [LHA-misc] mysql question ...
> 
> 
> 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)
> 
> _______________________________________________
> http://lists.sourceforge.net/lists/listinfo/linuxha-misc
> To unsubscribe, send "unsubscribe Linuxha-misc"
> in the body of a message to  
> Lin...@li...
>