MySQL: Add all privileges for user abc on database basic_data
SHOW GRANTS FOR abc;
//results
GRANT USAGE ON *.* TO 'abc'@'%' IDENTIFIED BY PASSWORD '*38E573FEE0457F38F79B14E4E5381EAA895B5FC1'
GRANT SELECT ON `mysql`.`proc` TO 'abc'@'%'
GRANT ALL PRIVILEGES ON `basic_data`.* TO 'abc'@'%';
SHOW GRANTS FOR abc;
//results
GRANT USAGE ON *.* TO 'abc'@'%' IDENTIFIED BY PASSWORD '*38E573FEE0457F38F79B14E4E5381EAA895B5FC1'
GRANT ALL PRIVILEGES ON `basic_data`.* TO 'abc'@'%'
GRANT SELECT ON `mysql`.`proc` TO 'abc'@'%'