Re: Error logging in to mysql

[Vinay Nagrik]

Dear list,

I have also tried

mysql > mysql -u root -p

and every combination there of.

Even though I don't get a command

"Enter Password",

I still type my 'password' on the next arrow

>  <my_password>

and then I get the following message

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
corresponds to your MySQL server version for the right syntax to use near
'mysql

The problem is trivial and I am sure other novices must have encountered the
similar thing.

Thanks.

nagrik

On Thu, Jun 18, 2009 at 2:23 PM, Vinay Nagrik <vnagrik@stripped> wrote:

> Dear list,
>
> I have downloaded and installed mysql database and finding difficulty in
> the very first step.  I am logged on as 'administrator' on my machine and
> have a password assigned to me.
>
> I can ensure through 'Microsoft services' that mySQL database is running
> and I do get the prompt on 'mysql' after typing in the same command.
>
> However when I type
>
> mysql > mysql -p
>
> The screen does not show
>
> "Enter Password"
>
> Also when I type the command ' show databases'.  It shows following
> databases "Without my being logged in"
>
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | test               |
> +--------------------+
> 2 rows in set (0.00 sec)
>
> Can someone please take me pass the logging in command.  I, as an
> administrator want to create more users for mysql database.
>
> For some this must be a trivial problem.  Thanks in advance.
>
> --
> Thanks
>
> Nagrik
>



-- 
Thanks

Nagrik