Hi Dan, If you manually modify the mysql database without using GRANT, then you need to FLUSH PRIVILEGES afterwards to get MySQL to reload the permissions. Of course, restarting the server has the same effect. Using GRANT takes care of everything automatically, though.
Hope that helps. Matt ----- 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 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]
