I see 2 possible problems:
1) syntax: I had to experiment with the mysql line a bit before
it worked. Try:
mysql -urknop -p
password
(Note no space before username, password last)
2) Your user has no permissions at all: I've never tried that, but
I wouldn't be surprised if it made login impo
> It's probably a good idea to remove the entry for ''@'localhost'.
For many reasons, yes. :)
-Rob
(SPAMblocker food: sql table query database)
--
-=-=-= Rob Knop =-= [EMAIL PROTECTED] =-= http://www.pobox.com/~rknop =-=-=-
Help the EFF protect basic freedoms online: http://www.eff.org
Robert A. Knop Jr. writes:
> > localhost is a special value (meaning connection over unix socket
> > rather than TCP/IP), and it's not matched by % in this case. You
> > need to grant access to user@localhost as well.
>
> (Is this in the manual? If so, I didn't find it.
Heh, it turns out that
> localhost is a special value (meaning connection over unix socket
> rather than TCP/IP), and it's not matched by % in this case. You
> need to grant access to user@localhost as well.
Aha! That did the trick. Thank you very much.
(Is this in the manual? If so, I didn't find it. It would pro
Robert A. Knop Jr. writes:
>ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES)
>
> mysql> select * from user where user='rknop'\G
> *** 1. row ***
>Host: %
>User: rknop
localhos
> I don't know if this is it, but
I don't think so; I've tried "flush privileges", even though the docs don't
state it's necessary for GRANT or SET PASSWORD. I've also tried stopping
and restarting the mysqld process.
-Rob
-
B
I don't know if this is it, but
--
6.11 When Privilege Changes Take Effect
When mysqld starts, all grant table contents are read into memory and become
effective at that point.
Modifications to the grant tables that you perform using GRANT, REVOKE, or SET
PASSWORD are noticed by t
OK, I think I've read the docs and am doing everything right, but I simply
cannot get the "mysql" program to accept a password for any user other than
root.
I'm on RedHat Linux 7.2, with MySQL version 3.23.46.
I can get the root password set up fine, and I log in with it. I can even
change it:
