Knowledge Walls
John Peter
Pune, Maharashtra, India
How to manage users in Mysql? in Cool Topics of MySQL
4450 Views
Add Users
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
Reset Password
SET PASSWORD FOR 'username'@'host' = PASSWORD('password');
Drop Users
DROP USER 'username'@'host';
GRANT privileges 
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details