MySQL from Command Line


/ Published in: MySQL
Save to your folder(s)



Copy this code and paste it in your HTML
  1. mysql
  2. mysql -u root -p
  3. SET PASSWORD FOR root@localhost=PASSWORD('#PasswordHere#');
  4. FLUSH PRIVILEGES;
  5. DROP DATABASE #NAME#;
  6.  
  7. <!-- Granting user privileges -->
  8. GRANT ALL PRIVILEGES ON #databaseName#.*
  9. TO 'username'@'localhost'
  10. IDENTIFIED BY '#userpassword';
  11. SHOW GRANTS FOR '#username#'@'localhost'
  12.  
  13. mysql -u #UserName# -p #databaseName#

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.