Re: installing mysql / error

2005-01-03 Thread David Katz
I did the first 2 step you listed below, but when I typed in the mysql -u root, I got a new error message ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061) Thanks David. - Original Message - From: Tom Crimmins [EMAIL PROTECTED] To: David Katz [EMAIL PROTECTED] Cc

Fw: installing mysql / error

2004-12-30 Thread David Katz
We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 (28000): Access denied for user 'ODBC' @'localhost' (using password: NO) Any ideas on what we can

Re: Fw: installing mysql / error

2004-12-30 Thread David Katz
I'm going to the dos window on the server and typing mysql to kick it off. That's when I get the error. - Original Message - From: [EMAIL PROTECTED] To: David Katz [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, December 30, 2004 1:13 PM Subject: Re: Fw: installing mysql

Re: installing mysql / error

2004-12-30 Thread David Katz
When I try 'mysql -u root' I get the same error, except root is in the place of ODBC ERROR 1045 (28000): Access denied for user 'root' @'localhost' (using password: NO) - Original Message - From: Tom Crimmins [EMAIL PROTECTED] To: David Katz [EMAIL PROTECTED] Cc: mysql

Aliases

2003-11-09 Thread David Katz
I am trying to do a select statement where I am using one of the aliases in the where clause. I keep getting an error that the field does not exist. example: Select invno, invdate, invamt, left(invdate,2) as month from salesfile where month = '01' MySql keeps telling me that month is not a

multitable sum problem

2003-11-07 Thread David Katz
I have the following two tables: salesinvoiceslysalesinvoices salesrepidsalesrepid invamt lyinvamt I am trying to get a current year and last year sum for each sales rep. The problem is it looks like it is resuming each file for each