User Permission MySQL

SET PASSWORD FOR 'JOHN'= PASSWORD('JOHN1');