I think it is better to use MySQL Administrator if you are a beggineer.
I still use it and it is very useful.
________________________________
From: Rafael Herrera <rafael@stripped>
To: Vinay Nagrik <vnagrik@stripped>
Cc: php@stripped
Sent: Friday, June 19, 2009 2:36:47 AM
Subject: Re: Error logging in to mysql
Dear friend, it's possible that you haven't setup your password yet...
to setup a password, try this command:
mysqladmin -u root password your_new_passwd
then, at the next try, do the following to login with your new password:
mysql -u root -p
now you must inform your new password... then the mysql prompt will be
right next to you then you can input your SQL queries by hand...
regards!
On Thu, Jun 18, 2009 at 7:26 PM, Vinay Nagrik<vnagrik@stripped> wrote:
> 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
>
--
Rafael de Paula Herrera
--
MySQL PHP Mailing List
For list archives: http://lists.mysql.com/php
To unsubscribe: http://lists.mysql.com/php?unsub=1
