xuxuclassmate/tidb repository overview

docker pull xuxuclassmate/tidb

docker run --name tidb -d --privileged=true -p 4000:4000 xuxuclassmate/tidb

mysql -h 127.0.0.1 -P 4000 --prompt="tidb> "

#create database

CREATE DATABASE demo CHARACTER;
#create username

CREATE USER 'test'@'%' IDENTIFIED BY 'test';
GRANT ALL PRIVILEGES ON demo.* TO 'test'@'%';
FLUSH PRIVILEGES;
# update user password

use mysql

update user set authentication_string = password('123456') where User = 'root';

FLUSH PRIVILEGES;

mysql -h 127.0.0.1 -P 4000 -u root -p --prompt="tidb> "