#创建数据库
CREATE DATABASE ceshi CHARACTER;
#创建数据库登录用户
CREATE USER 'ceshi'@'%' IDENTIFIED BY 'ceshi';
GRANT ALL PRIVILEGES ON ceshi.* TO 'test'@'%';
FLUSH PRIVILEGES;
# 更新登录密码
use mysql
update user set authentication_string = password('123456') where User = 'root';
FLUSH PRIVILEGES;
6、退出数据库,再次登录(使用设置的账号和密码)
mysql -h 127.0.0.1 -P 4000 -u root -p --prompt="tidb> "