復(fù)制代碼 代碼如下:

mysql - u root -p

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

mysql> drop user root@192.168.0.1;