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 the server immediately.
If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should
execute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or
mysqladmin reload to tell the server to reload the grant tables. Otherwise your
changes will have no effect until you restart the server. If you change the grant
tables manually but forget to reload the privileges, you will be wondering why
your changes don't seem to make any difference!
When the server notices that the grant tables have been changed, existing client
connections are affected as follows:
Table and column privilege changes take effect with the client's next request.
Database privilege changes take effect at the next USE db_name command.
Global privilege changes and password changes take effect the next time the client
connects.
-------------------
"Robert A. Knop Jr." wrote:
> 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:
>
> mysql> set password for root=password('newrootpw');
> mysql> \q
>
> shell$ mysql -p -u root
> Enter password:
>
> Welcome to the MySQL monitor. Commands end with ; or \g....
>
> So far so good. Next I try to create another database and another user.
>
> mysql> create database rknop;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> grant all on rknop.* to rknop identified by 'testpw';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> \q
>
> Here's the problem:
>
> shell$ mysql -p -u rknop rknop
> Enter password:
> ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES)
>
> I've also tried (as root in mysql)
>
> mysql> set password for rknop=password('testpw');
>
> To no avail. For reference, the user table has:
>
> mysql> select * from user where user='rknop'\G
> *************************** 1. row ***************************
> Host: %
> User: rknop
> Password: 12ab181d57a7f4be
> Select_priv: N
> Insert_priv: N
> Update_priv: N
> Delete_priv: N
> Create_priv: N
> Drop_priv: N
> Reload_priv: N
> Shutdown_priv: N
> Process_priv: N
> File_priv: N
> Grant_priv: N
> References_priv: N
> Index_priv: N
> Alter_priv: N
> 1 row in set (0.00 sec)
>
> The /var/log/mysqld.log file says nothing after the startup "ready for
> connections" message, and as such can shed no light on the situation.
>
> Can anybody offer me any suggestions as to how to get around this
> predicament?
>
> Thanks,
>
> -Rob
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
