This error is caused when the server isn't started. Make sure that you start the server first, then log in. When you skip the HOSTS.FRM tables (by doing mysqld --skip-grant-tables), you have to restart the server normally to effect your changes in the mysql root user.
J.R. -----Original Message----- From: David Katz [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 10:30 AM To: Tom Crimmins Cc: mysql@lists.mysql.com Subject: 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: <mysql@lists.mysql.com> 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: <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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
