Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Newbe question
March 12, 2005, 1:09 pm
rate this thread
I ran "GRANT ALL PRIVILEGES ON `mysql`.* TO 'mpeloso'@'%' WITH GRANT OPTION"
I would suspect that mpeloso would have privileges to Select, Insert, ect.
But when I look in the user table there is an "N" in all the priveleges
When I look at the DB table there are "Y"'s
Why does the user table have "N"'s?
Re: Newbe question
That is not needed when using GRANT.
"Modifications to the grant tables that you perform using GRANT or
REVOKE are noticed by the server immediately. If you modify the grant
tables manually (using INSERT, UPDATE, and so on), you should execute a
FLUSH PRIVILEGES statement or run mysqladmin flush-privileges to tell
the server to reload the grant tables."
- » Creating FULLTEXT index OK on command line, but NOT with DBI...?
- — Next thread in » MySQL Database Forum
- » Re: MySQL 4.0.18 InnoDB configuration issues on SuSE 9.1 Pro
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum