#安装mysql
sudo pacman -S mysql 
#初始化mysql
sudo mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
#使用生成的随机密码登陆
mysql -u root -p"[passwd]"
#修改root密码
mysql> alter user 'root'@'localhost' identified by "newpasswd";

#创建用户
CREATE USER 'USERNAME'@"HOST" IDENTIFIED BY 'PASSWD';

#授权 privileges 包括all privileges, select, insert, update, delete等
#database_name.* 对某个数据库的所有表授权， database_name.table_name可以指定表进行授权。
GRANT privileges ON database_name.* TO 'username'@'host';
#刷新授权
FLUSH PRIVILEGES;
#查看用户的权限
SHOW GRANTS FOR "username"@"host";
#撤销权限
REVOKE privileges ON database_name.* FROM 'username'@'host';

#删除用户
DROP USER 'username'@'host';

#修改用户主机
DROP USER 'username'@'host';
CREATE USER 'username'@'another_host' identified by 'passwd';