Hi Vinay,
Type : mysql -u root -p
this will prompt you for password
Enter password:
If login successful A welcome note will appear ...
you can try GUI interface to manage mysql PHPMyAdmin.
Please let me know if this was helpful.
Regards,
On Fri, Jun 19, 2009 at 2:53 AM, 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
>
