SamatsWiki

• Diff for "CheatSheet/MySQL"

   1 CREATE DATABASE dbname;
   2 GRANT USAGE ON dbname.* TO username@'%';
   3 GRANT ALL ON dbname.* TO username@'%';
   4 SET PASSWORD FOR username@'%' = PASSWORD('blah');
   5 FLUSH PRIVILEGES;

   1 SET PASSWORD = PASSWORD('blah');

   1 mysql -u root
   2 mysql> SET PASSWORD FOR root@localhost = PASSWORD('new_password');

   1 drop database test;
   2 use mysql;
   3 delete from db;
   4 delete from user where not (host="localhost" and user="root");
   5 flush privileges;

   1 REVOKE ALL PRIVILEGES ON *.* FROM username@'%';
   2 REVOKE GRANT OPTION ON *.* FROM username@'%';
   3 DELETE FROM mysql.user WHERE (User='username' and Host='%');