RE: Access denied for user - I cant work this out

} } -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 January 2005 12:27 AM To: Christian Biggins; mysql@lists.mysql.com Subject: RE: Access denied for user - I cant work this out hi you are not passing a password to my

Access denied for user - I cant work this out

Hi All, I am consistently getting; Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) I am connecting through php with the same script I use all the time, I have checked it and dbl checked it for problems. I can connect to mysql in a prompt and I have added new users with all priv

Selecting a random record from more than 1 table

Hi Guys I am trying to display 1 random record taken from 2 tables. I have tried the following; SELECT table1.record1, table1.record2, table2.record1 FROM table1, table2 ORDER BY RAND() Limit 1 With no luck... So now I am trying to use CREATE VIEW but also with no luck... Can anybody help out?

Re: MySQL Purchase Options

The MySQL GNU (GPL) license is free so long as you are not shipping MySQL with your products. There are 2 license options available. http://www.mysql.com/products/licensing/ Hope that helps. Kind Regards, Christian Biggins Web Developer Web: http://www.fusiononline.com.au <h

RE: MYSQL and COMMANDFOR DUMP FILE

Hi, Is this what you need/want? >mysqldump db_name > /path/to/whereever/dump.sql Kind Regards, Christian Biggins Web Developer Web: http://www.fusiononline.com.au Email: [EMAIL PROTECTED] Phone: 0410 596 841 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]