CREATE USER 'user'@'localhost' IDENTIFIED VIA mysql_native_password USING 'password';
GRANT ALL PRIVILEGES ON `table`.* TO 'user'@'localhost';
REVOKE ALL PRIVILEGES ON `table`.* FROM 'user'@'localhost';
CREATE USER 'user'@'localhost' IDENTIFIED VIA mysql_native_password USING 'password';
GRANT ALL PRIVILEGES ON `table`.* TO 'user'@'localhost';
REVOKE ALL PRIVILEGES ON `table`.* FROM 'user'@'localhost';