If the user was defined using a password, then you must use the password.
If the user was defined without a password, then you must NOT use a
password.
Since the userid is unique key in the grant tables, you can't have it both
ways. Pick one and go with it (best to use the password)
If you really don't want to have to use a password, at least add the
additional restriction of only connecting from a certain host.
Ie: GRANT <privileges> ON dbs.tables(*.*?) TO user@host;
(don;t forget to flush privileges immediately after to make it take affect)
On 3/28/01 12:43 PM, "Hammad Nasim" <[EMAIL PROTECTED]> wrote:
> Hi
> I am having some problems running mysql client. I can connect mysql server
> from client machine by skipping password. But if I try to connect with
> password, message is displayed
> Error 1045: Access denied for user using password.
>
> Kindly help me out here.
>
>
> Hammad
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
