mysql> grant all privileges on *.* to cc@ '10.0.0.1 ' identified by 'password '; Query OK, 0 rows affected (0.02 sec)