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: > 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 supposed to restart the server after > modifying the > settings or is it supposed to automatically reflect > the changes? > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
