After modifying user privileges, the new privileges do
not take immediate effect. You need to "load" the
changes by issuing the following command:
FLUSH PRIVILEGES;
See the MySQL manual page
http://www.mysql.com/doc/en/FLUSH.html#IDX601 for more
detail.
--- Dan Jones <[EMAIL PROTECTED]> wrote:
>
- Original Message -
From: "Dan Jones" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Sunday, October 19, 2003 7:02 PM
Subject: MySQL's 'myslq' database
> When you make changes to the mysql database (the data
When you make changes to the mysql database (the database which controls
how MySQL works), does MySQL automatically load the updates? When
adding users or changing security permissions for hosts or users or
databases, it seems like some updates take affect immediately and some
don't. Are you supp
