Re: Error logging in to mysql

[Micah Gersten]

If you see the:
mysql >
prompt, then you are already logged into MySQL.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Vinay Nagrik 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.
>
>