, 2011 3:53:23 AM
Subject: Re: mysql server does not recognize user password
Why does mysql say using password: no? Seems to me the password is
not
being sent.
On Oct 18, 2011 8:37 PM, Tim Johnson t...@akwebsoft.com wrote:
linus:~ tim$ sudo mysql
Password:
.
mysql SELECT
Am 19.10.2011 01:36, schrieb Tim Johnson:
try mysql -u tim -p
Same error:
ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
password: NO)
and enter yur password in the followed dialog
Doesn't even ask for the pwd..
then your mysql CLIENT is broken or somehow
* Reindl Harald h.rei...@thelounge.net [111018 23:24]:
Am 19.10.2011 01:36, schrieb Tim Johnson:
try mysql -u tim -p
Same error:
ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
password: NO)
and enter yur password in the followed dialog
Doesn't even ask for
Am 19.10.2011 17:45, schrieb Tim Johnson:
* Reindl Harald h.rei...@thelounge.net [111018 23:24]:
Am 19.10.2011 01:36, schrieb Tim Johnson:
try mysql -u tim -p
Same error:
ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
password: NO)
and enter yur password in the
using 5.1.57 on Mac Lion.
blush I've done this a dozen times, but I've missed something.
Am setting up a new mysql installation ...
I have granted a user as follows (between lines of asterisks)
linus:~ tim$ sudo mysql
Password:
Welcome
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
- Mark
-Original Message-
From: Tim Johnson [mailto:t...@akwebsoft.com]
Sent: woensdag 19 oktober 2011 1:02
To: MySQL ML
Subject: mysql server does not recognize user password
using 5.1.57 on Mac Lion.
blush I've
Am 19.10.2011 01:03, schrieb Tim Johnson:
Now when I try to log in with host as localhost, user as tim
with 'secret' password:
linus:~ tim$ mysql --host=localhost --user=tim --password=secret
ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password:
NO)
Huh!
did you
* Mark ad...@asarian-host.net [111018 15:14]:
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
Not originally, but I repeated the grant then
issued
flush privileges;
quit
and have the same problem
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot
* Reindl Harald h.rei...@thelounge.net [111018 15:14]:
Am 19.10.2011 01:03, schrieb Tim Johnson:
Now when I try to log in with host as localhost, user as tim
with 'secret' password:
linus:~ tim$ mysql --host=localhost --user=tim --password=secret
ERROR 1045 (28000): Access denied for
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually this problem comes when you have the anonymous user in the grant
tables (''),
MySQL has a tricky way of processing the grant tables.
Sometimes you can be surprised by what you read issuing:
SELECT
* Claudio Nanni claudio.na...@gmail.com [111018 17:02]:
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually this problem comes when you have the anonymous user in the grant
tables (''),
MySQL has a tricky way of processing the grant tables.
Sometimes you
* Tim Johnson t...@akwebsoft.com [111018 17:47]:
Got this...
mysql select host,user,password from user;
+-+--+---+
| host| user | password |
Why does mysql say using password: no? Seems to me the password is not
being sent.
On Oct 18, 2011 8:37 PM, Tim Johnson t...@akwebsoft.com wrote:
* Claudio Nanni claudio.na...@gmail.com [111018 17:02]:
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually
Cc: mysql@lists.mysql.com
Sent: Wednesday, 19 October, 2011 3:53:23 AM
Subject: Re: mysql server does not recognize user password
Why does mysql say using password: no? Seems to me the password is
not
being sent.
On Oct 18, 2011 8:37 PM, Tim Johnson t...@akwebsoft.com wrote:
linus
14 matches
Mail list logo