Tidb 运维常用命令

常用运维命令

# 建用户和对库授权 CREATE USER 'xx_dev_user'@'%' IDENTIFIED BY 'Dev@2026'; GRANT ALL PRIVILEGES ON `dj_dev`.* TO 'xx_dev_user'@'%'; -- schema：dj_dev ## 授权所有库权限 -- 2. 授予正确权限 GRANT ALL PRIVILEGES ON *.* TO 'xx_test_user'@'%' WITH GRANT OPTION; -- 3. 刷新 FLUSH PRIVILEGES; -- 4. 验证 SHOW GRANTS FOR 'xx_test_user'@'%'; ## 改密码 ALTER USER 'xx_dev_user'@'%' IDENTIFIED BY 'dev@2026';