Re: installing mysql / error
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: Sent: Thursday, December 30, 2004 2:32 PM Subject: RE: installing mysql / error > [snip] > > 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) > > [/snip] > > In that case, you may have a password set for root. To reset the password, > shutdown the mysql server. Then start it from a command line using: > > [PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tables > > Then open another command prompt and run 'mysql -u root' and run the > following query: > > UPDATE mysql.user SET Password='' WHERE User='root' AND Host='localhost'; > > Then shutdown the server, and restart it normally. You should then be able > to connect with 'mysql -u root'. > > --- > Tom Crimmins > Interface Specialist > Pottawattamie County, Iowa > office 712.328.4808 > mobile 402.677.1592 > > > -Original Message- > From: David Katz [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 30, 2004 1:25 PM > To: Tom Crimmins > Cc: mysql@lists.mysql.com > Subject: Re: installing mysql / error > > 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: > Sent: Thursday, December 30, 2004 1:57 PM > Subject: RE: installing mysql / error > > > > [snip] > > 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) > > [/snip] > > > > Ignore my previous post, I misunderstood. > > > > ODBC is the default account on a windows server. You need to use run > 'mysql > > -u root' from a command-line. You should then be able to grant privs to > > [EMAIL PROTECTED] > > > > --- > > Tom Crimmins > > Interface Specialist > > Pottawattamie County, Iowa > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installing mysql / error
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: Sent: Thursday, December 30, 2004 1:57 PM Subject: RE: installing mysql / error > [snip] > 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) > [/snip] > > Ignore my previous post, I misunderstood. > > ODBC is the default account on a windows server. You need to use run 'mysql > -u root' from a command-line. You should then be able to grant privs to > [EMAIL PROTECTED] > > --- > Tom Crimmins > Interface Specialist > Pottawattamie County, Iowa > > > > -- > 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]
Re: Fw: installing mysql / error
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: Sent: Thursday, December 30, 2004 1:13 PM Subject: Re: Fw: installing mysql / error > "David Katz" <[EMAIL PROTECTED]> wrote on 12/30/2004 12:34:31 PM: > > > > > > > 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 try and do? > > > > Thanks > > David. > > Your server IS running or you wouldn't have that error, you would have > seen something else. You left out a critical detail from your original > post: > > What are you doing when you get that error? > > If you are attempting a connection through an ODBC driver, you need to be > aware that even the most up-to-date driver acts like a pre-4.1 client. > That means you may need to follow one or more of the suggestions > documented here: > > http://dev.mysql.com/doc/mysql/en/Problems.html > especially read A.2.3 : > http://dev.mysql.com/doc/mysql/en/Old_client.html > > Let me know if I am on the right track, OK? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: installing mysql / error
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 try and do? Thanks David.
Aliases
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 field. Is there a way to do this? Thanks David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multitable sum problem
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 record. select salesrepid, sum(invamt) as curramt, sum(lyinvamt) as lyamt from salesinvoices,lysalesinvoices group by salesrepid order by curramt; ++-+--+ | salesrepid | curramt| lyamt | +---+---+-+ | 101 | 3434464.00 | 4286744.00 | | 102 | 3507312.00 | 4286744.00 | +---+---+--+ I've attached the individual file records below. Any help would be appreciated. Thanks David. mysql> select salesrepid, invamt from salesinvoices; ++--+ | salesrepid | invamt | ++--+ | 101| 25230.00 | | 101| 34332.00 | | 101| 24564.00 | | 101| 15155.00 | | 101| 43243.00 | | 101| 34352.00 | | 101| 24352.00 | | 101| 13426.00 | | 102| 26330.00 | | 102| 36433.00 | | 102| 25436.00 | | 102| 16335.00 | | 102| 43543.00 | | 102| 34456.00 | | 102| 23422.00 | | 102| 13252.00 | ++--+ mysql> select lysalesrepid, lyinvamt from lysalesinvoices; +--+--+ | lysalesrepid | lyinvamt | +--+--+ | 101 | 25230.00 | | 101 | 34332.00 | | 101 | 24564.00 | | 101 | 15155.00 | | 101 | 32650.00 | | 101 | 43224.00 | | 101 | 43623.00 | | 101 | 45633.00 | | 102 | 23330.00 | | 102 | 34653.00 | | 102 | 23264.00 | | 102 | 26435.00 | | 102 | 43550.00 | | 102 | 32524.00 | | 102 | 32353.00 | | 102 | 55323.00 | +--+--+
