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]
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: 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]
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.
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
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: mysql@lists.mysql.com 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]
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]
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: Fw: installing mysql / error
David Katz [EMAIL PROTECTED] wrote on 12/30/2004 01:32:41 PM: I'm going to the dos window on the server and typing mysql to kick it off. That's when I get the error. OK, mysql is the client that comes with the server. What you attempted to do was to login as nobody and you said you weren't going to provide a password. What you should have typed is mysql -u root so that you attempt to connect as the mysql user root. That is one of the two accounts set up by default when you install a new MySQL server. I think you have accomplished all of the setup steps down to here: http://dev.mysql.com/doc/mysql/en/Post-installation.html I especially think that you are ready for step 2.9.3 - Securing the Initial MySQL Accounts http://dev.mysql.com/doc/mysql/en/Default_privileges.html Try it out and let me know if you need more information. Shawn Green Database Administrator Unimin Corporation - Spruce Pine - 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 / 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]
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]
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]