mysql> GRANT ALL ON *.* TO 'qzl'@'localhost' IDENTIFIED BY 'Qzl123456!'; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> GRANT ALL ON *.* TO 'qzl'@'127.0.0.1' IDENTIFIED BY 'Qzl123456!'; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> GRANT ALL ON qzl.* TO 'qzl'@'192.168.70.133' IDENTIFIED BY 'Qzl123456!'; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> GRANT ALL ON *.* TO 'qzl'@'%' IDENTIFIED BY 'Qzl123456!'; Query OK, 0 rows affected, 1 warning (0.00 sec)查看授权 取消授权REVOKE



