Advertisement
Guest User

Untitled

a guest
Jun 21st, 2016
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. ## mysql: show mysql host,user,passwd
  2. SELECT Host,user,password FROM mysql.user WHERE User = "root" ORDER BY (Host="localhost") ASC ;
  3.  
  4. ## mysql: set empty root password
  5. update user set password=PASSWORD("") where User='root';
  6. flush privileges;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement