Guest User

Untitled

a guest
Dec 28th, 2018
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. sudo /etc/init.d/mysql stop
  2. sudo mysqld --skip-grant-tables &
  3. mysql -u root -p
  4. UPDATE user SET Password='B@itza321' WHERE User='root'; FLUSH PRIVILEGES; exit;
  5. sudo /etc/init.d/mysql stop
  6. sudo /etc/init.d/mysql start
  7.  
  8. CREATE USER 'USER'@'%' IDENTIFIED BY 'PASSWORD';
  9.  
  10. GRANT ALL PRIVILEGES ON db_name.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD';
Add Comment
Please, Sign In to add comment