Miscellaneous MySQL queries

mysql.sql

# Random Rating Generator
INSERT INTO tbl_name ( rating ) VALUES ( ROUND(rand() * 5,2) );

# Create user 'hackerearth' and password 'passphrase'
CREATE USER 'hackerearth'@'localhost' IDENTIFIED BY 'passphrase';

# Grant superuser privileges to db 'test', user 'hackerearth', and hostname 'localhost'
GRANT ALL PRIVILEGES ON `test`.* TO 'hackerearth'@'localhost';

# To see privilages related changes in effect.
FLUSH PRIVILEGES;