Mysql/hive/redis

Rename table

ALTER TABLE table_name RENAME TO new_table_name;

[1]

Create user

CREATE USER 'newuser'@'localhost' IDENTIFIED BY ‘password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@‘localhost';
FLUSH PRIVILEGES;

DROP USER ‘demo’@‘localhost’;

[2]