List:General Discussion« Previous MessageNext Message »
From:Loren McDonald Date:March 9 2003 7:06pm
Subject:RE: inquiry
View as plain text  
Philip,

For starters, you are not wasting my time.  I know the difficulties, as
it took me a while to get it installed and running.

I would suggest you take a look over your book a little more carefully.
I could be wrong, but it should have mentioned that mysql_install_db is
a shell script for Linux, not usable on Windows.

I don't have the book you are using so I can only refer you to the
windows installation section of the MySQL manual to get the ball
rolling.  After that (after you have it all set up), you "should" be
able to follow your book.

http://www.mysql.com/doc/en/Windows_installation.html
...also see the subsections and the windows specific links.

Also, from what you said, I gather you have not set up one of the my.ini
or my.cfg files.  This is most likely where you are having your
troubles.
For more info about them, start here.

http://www.mysql.com/doc/en/Option_files.html

If after all that you still have troubles, drop me an email (use addy in
my sig below).  State what you did and any error messages you received
and I'll be glad to help get you on the right road again.

-- 
Loren McDonald
mysql-ml@stripped


-----Original Message-----
From: Philip McCarthy [mailto:mcarthyp@stripped] 
Sent: Sunday, March 09, 2003 5:06 AM
To: mysql@stripped
Subject: inquiry

Loren

Firstly thanks heaps for your reply.  I will try and be as specific as
possible to not waste your time.

If indeed the connection is defaulting to the user ODBC and it is set in
one of the my.* files, where can I see this? Fix this?

I should go back a bit and mention that as I was working through my
book, the first hurdle I encountered was setting up the initial grant
tables.  When I typed c:\mysql\scripts\mysql_install_db I got the error
message:

'mysql_intall_db' is not recognized as an internal or external command,
operable program or batch file.

I uninstalled mysql, resintalled and still got the same message.

I gather this should have worked?

I did this by opening 'run' from the start bar, typing in cmd to open
the command line, cd \ to change to the root directory, cd mysql to
change to the mysql folder, cd scripts to change to the scripts folder
and then mysql_install_db to run this.  No luck.

Yours Sincerely

Philip McCarthy
Australia

-----Original Message-----
From: Loren McDonald [mailto:MySQL-ML@stripped] 
Sent: 09/03/2003 7:15 PM
To: 'daniel'; 'Philip McCarthy'; mysql@stripped
Subject: RE: inquiry

First, for some reason the connection attempt is defaulting to the user
ODBC (probably set in one of the my.* files).  If this user does not
exist in the database, it will naturally fail.

Second, concerning the root user, there are actually 2 root user entries
that need the password changed or one user removed.

Specifically: From 4.2.11 Causes of Access denied Errors

A very common error is to insert a new entry with Host='%' and
User='some user', thinking that this will allow you to specify localhost
to connect from the same machine. The reason that this doesn't work is
that the default privileges include an entry with Host='localhost' and
User=''. Because that entry has a Host value 'localhost' that is more
specific than '%', it is used in preference to the new entry when
connecting from localhost! The correct procedure is to insert a second
entry with Host='localhost' and User='some_user', or to remove the entry
with Host='localhost' and User=''.


See the full documentation:
http://www.mysql.com/doc/en/Access_denied.html


-- 
Loren McDonald
mysql-ml@stripped

-----Original Message-----
From: daniel [mailto:daniel@stripped] 
Sent: Sunday, March 09, 2003 1:15 AM
To: Philip McCarthy; mysql@stripped
Subject: RE: inquiry

have u set the pass or is it correct ?

usually mysqladmin -u root password newpassword

then mysqladmin -u root -p create sample_db
>===== Original Message From "Philip McCarthy" <mcarthyp@stripped>
=====
>Dear mysql
>
>
>
>I have just downloaded mysql 3.23 for Windows and I am running XP.
>
>
>
>I have started the service ok and create a database.  I thought I had 
>set my database password ok.  I have been using the book 'Teach
Yourself
>MySQL in 21 days' by SAMS (Mark Maslakowski).
>
>
>
>When I try the statement
>
>
>
>bin\mysqladmin -p CREATE sample_db
>
>
>
>the command asks for a password.  I type in the one I set and the
system
>says
>
>
>
>mysqladmin: connect to server at 'local host' failed
>
>error: 'Access denied for user: 'ODBC@localhost' (Using password: YES)'
>
>
>
>Does it appear that I need to install an ODBC driver?
>
>
>
>Your help is appreciated.
>
>
>
>Yours Sincerely
>
>
>
>Philip McCarthy
>
>NSW Australia
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread134306@stripped>
>To unsubscribe, e-mail
<mysql-unsubscribe-daniel=electroteque.org@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread134307@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-mysql-ml=misterrmac.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread134311@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-mysql-ml=misterrmac.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Thread
inquiryPhilip McCarthy9 Mar
  • Re: inquiryPaul DuBois9 Mar
  • RE: inquiryLoren McDonald9 Mar