mysql’s useful … sqls
Create a new user:
grant all on mydb.* to myuser@localhost identified by 'mypass';
show grants for ‘username’@'localhost’
revoke all privileges on db_name.* from ‘username’@'localhost’
drop user ‘username’@'localhost’
Comments Off