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's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access denied for user - I cant work this out
Hi Peter, There is a password being suppled - see code (btw, its local testing only, hence the root user) //Database Settings $db_host = 'localhost'; //database hostname $db_name = 'powerpla_powerplay'; //database name $db_user = 'root'; //database USER name $db_pass = 'rootpass'; // database password function db_connect() { if ($dbc = @mysql_connect($db_host, $db_user, $db_pass)) { if (!mysql_select_db($db_name)) { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } else { die('pCould not connect to the database because: b' . mysql_error() . '/b/p'); } } -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 mysql - check your code to see if this is correct. Peter -Original Message- From: Christian Biggins [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 12:27 To: mysql@lists.mysql.com Subject: 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's and connected with them - obviously its more a server issue than mysql (I think)... MySQL version is 4.0.21 PHP Version 4.3.8 On a Win2k server using apache 2 (just a local testing server). Any info would be muchly appreciated. Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 http://www.fusiononline.com.au/ Email: [EMAIL PROTECTED] Phone: 0410 596 841 _ From: Michael Mason [mailto:[EMAIL PROTECTED] Sent: Friday, 20 August 2004 12:09 AM To: 'MySQL Mailing List' Subject: MySQL Purchase Options Hi all. Just a quick question (I hope). I'm looking to buy a MySQL license and noticed an array of different options on their website. The MySQL Box sounds promising as all I want to do is host some web applications locally for our internal use. Any thoughts.? Michael Mason Business Support Services ArrasR People Tel: 01706 342310 Mobile: 07793 782287 Fax: 01706 642754 http://www.cipd.co.uk/cande/annual Visit Arras People at the Chartered Institute of Personnel and Development Conference and Exhibition - 27th-29th October 2004. http://www.arraspeople.co.uk/ The Project Management Recruitment Specialists http://www.rec.uk.com/ Member of the Recruitment Employment Confederation (00052055) The views expressed in this mail are entirely those of the sender, and do not necessarily represent the views or position of Arras Services Ltd. The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in relation to the contents of this information is strictly prohibited and may be unlawful. Neither the sender nor the represented institution is liable for the correct and complete transmission of the contents of this e-mail, or for its timely receipt.
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] Sent: Saturday, 14 August 2004 3:34 PM To: [EMAIL PROTECTED] Subject: MYSQL and COMMANDFOR DUMP FILE Dear Driends, From command prompt I want to generate dump files of database tables. Any guidance how do I do the same. Inform, please. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]