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:
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
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
-
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
localhost is a
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
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 I was
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
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