[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: <mysql@lists.mysql.com> 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]
