Alan Williamson wrote:
>>I have made a user with the following command:
>>GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
>
> Silly question Morten, and I am sure you have probably done it, but
> you are definitely running:
>
> % mysql> FLUSH PRIVILEGES;
You only need to FLUSH PRIVILEGES if you directly edit the mysql db tables.
It is not needed with GRANT, REVOKE, or SET PASSWORD. See the manual for
the details <http://dev.mysql.com/doc/mysql/en/privilege-changes.html>.
Michael
Strange, because it work after i did a FLUSH PRIVILEGES.
thank you alan.
Morten
| Thread |
|---|
| • SV: show master/slave status privileges ? | Morten Kallesøe | 3 Sep |