At 11:22 AM 8/17/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I had already run the command:
grant all on tracerlock.test to bhaselto identified by "<password>"
and that didn't work when I did it, but I didn't restart mysql after running the command. Probably it was the restart of MySQL that made the difference.
http://www.mysql.com/doc/en/Privilege_changes.html
"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!"
The page says that if you change the grant tables MANUALLY, you have to restart the server.
I changed the grant tables using the GRANT syntax, and the page says: "Modifications to the grant tables that you perform using GRANT, REVOKE, or SET PASSWORD are noticed by the server immediately" -- no restart or flush is supposed to be required.
Yes,
That's exactly what I was wondering. I posted the link to you, because you said that it was probably because you restarted MySql, it worked.
Which version are you running?
When I execute grant statements, they usually work without any flush priveleges or a restarting of the server. But I always do these two steps, just to be on the safe side.
You know, I wouldn't like some user be welcomed with an ugly message that goes "Table is read-only." I will be the loser.
But anyways.. as you've got your problem fixed, there is absolutely no worry, and this thread can be closed.
-- No, but he says that all Gods are good :w _________________________________________ Meet the guy at http://www.meetRajesh.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
