mysql - u root -p

mysql> grant usage on *.* to username@192.168.0.1 identified by 'password';

mysql> grant all privileges on newdb.* to username@192.168.0.1;

mysql> grant all privileges on *.* to root@192.168.0.1 identified by '123456' ;

mysql> drop user root@192.168.0.1;