RE: installing mysql / error
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: 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
[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: 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
[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] Try starting mysqld-nt with the --skip-grant-tables option. Then attempt to login from the command line. If this works, the privileges for the ODBC account are wrong or there is a password set. You can fix the privileges or reset the password once you are logged in. Then you can restart the server normally. --- 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]
