Mysql - Problem Z Revoke

[adrub]

Witam

Zacząłem niedawno naukę mysql i mam problem

 

o co tutaj chodzi

 

[root@localhost ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with; or \g.
Your MySQL connection id is 16
Server version: 5.0.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all
    -> on *
    -> to ble identified by 'ble'
    -> with grant option;
ERROR 1046 (3D000): No database selected
mysql> grant all on *.* to ble identified by 'ble' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> revoke all privilages, grant
    -> from ble;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privilages, grant
from ble' at line 1

 

co robię nie tak, o co chodzi z tym errorem??

na google nie znalazłem odpowiedzi

[@sunrise]

mysql> revoke all privilages, grant

-> from ble;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'privilages, grant

from ble' at line 1[/code]

 

co robię nie tak, o co chodzi z tym errorem??

na google nie znalazłem odpowiedzi

 

REVOKE ALL PRIVILEGES, GRANT OPTION FROM ble