Re: inquiry

[Paul DuBois]

At 21:06 +1100 3/9/03, Philip McCarthy wrote:
>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?

You could try putting these lines in C:\my.cnf:

[client]
user=user_name

>
>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?

No.  mysql_install_db is for Unix installations.  It's not needed for
Windows, because the data directory (including the mysql and test
databases) comes preinitialized with Windows distributions.

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