Advertisement
kazoda

/usr/bin/mysql_secure_installation

Jun 4th, 2012
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  1. mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
  2. mysql> DELETE FROM mysql.user WHERE User='';
  3. mysql> DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
  4. mysql> DROP DATABASE test;
  5. mysql> DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';
  6. mysql> FLUSH PRIVILEGES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement