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
