"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] >
