host 作为标识。每个账户可以设置一个 密码。 通过 MySQL 客户端连接到 TiDB 服务器，通过指定的账户和密码登陆： 1. shell> mysql --port 4000 --user xxx --password 使用缩写的命令行参数则是： 1. shell> mysql -P 4000 -u xxx -p 添加用户有两种方式： 通过标准的用户管理的 SQL 语句创建用户以及授予权限，比如 互信配置成功。 1. ansible -i inventory.ini all -m shell -a 'whoami' 执行以下命令如果所有 server 返回 root 表示 tidb 用户 sudo 免密码配置成功。 1. ansible -i inventory.ini all -m shell -a 'whoami' -b 2. 执行 local_prepare.yml playbook，联网下载 docker-compose exec tispark-master /opt/spark/bin/spark-shell 来访 问 Spark shell。 1. $ docker-compose exec tispark-master /opt/spark/bin/spark-shell 2. ... 3. Spark context available as 'sc' (master = local[*]

installed TiUP successfully: Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open a ========= Have a try: tiup playground =============================================== Note the Shell profile path in the output above. You need to use the path in the next step. 2. Declare the global path of the correspond- ing Shell profile file. You need to modify ${your_shell_profile} in the following source command according to the path. In this case, $ �→ {your_shell_profile} is /Users/user/.zshrc

installed TiUP successfully: Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open a ========= Have a try: tiup playground =============================================== Note the Shell profile path in the output above. You need to use the path in the next step. 2. Declare the global path of the correspond- ing Shell profile file. You need to modify ${your_shell_profile} in the following source command according to the path. In this case, $ �→ {your_shell_profile} is /Users/user/.zshrc

| sh 安装完成后会提示如下信息： Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open ======== 2. 声明全局环境变量。 注意： TiUP 安装完成后会提示 Shell profile 文件的绝对路径。在执行以下 source 命令前，需要将 ${your_shell_profile} 修改为 Shell profile 文件的实际位置。 source ${your_shell_profile} 3. 在当前 session 执行以下命令启动集群。 • 直接执行 | sh 安装完成后会提示如下信息： Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: bash Shell profile: /home/user/.bashrc /home/user/.bashrc has been modified to add tiup to PATH open

| sh 安装完成后会提示如下信息： Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open ======== 2. 声明全局环境变量。 注意： TiUP 安装完成后会提示 Shell profile 文件的绝对路径。在执行以下 source 命令前，需要将 ${your_shell_profile} 修改为 Shell profile 文件的实际位置。 source ${your_shell_profile} 3. 在当前 session 执行以下命令启动集群。 • 直接执行 | sh 安装完成后会提示如下信息： Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: bash Shell profile: /home/user/.bashrc /home/user/.bashrc has been modified to add tiup to PATH open

installed TiUP successfully: Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open a ========= Have a try: tiup playground =============================================== Note the Shell profile path in the output above. You need to use the path in the next step. 2. Declare the global path of the correspond- ing Shell profile file. You need to modify ${your_shell_profile} in the following source command according to the path. In this case, $ �→ {your_shell_profile} is /Users/user/.zshrc

sh 安装完成后会提示如下信息： 76 Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open ======== 2. 声明全局环境变量。 注意： TiUP 安装完成后会提示 Shell profile 文件的绝对路径。在执行以下 source 命令前，需要将 ${your_shell_profile} 修改为 Shell profile 文件的实际位置。 source ${your_shell_profile} 3. 在当前 session 执行以下命令启动集群。 • 直接执行 sh 安装完成后会提示如下信息： 78 Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: bash Shell profile: /home/user/.bashrc /home/user/.bashrc has been modified to add tiup to PATH open

successfully installed TiUP: Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open a ========= Have a try: tiup playground =============================================== Note the Shell profile path in the output above. You need to use the path in the next step. 2. Declare the global path of the correspond- ing Shell profile file. You need to modify ${your_shell_profile} in the following source command according to the path. In this case, $ �→ {your_shell_profile} is /Users/user/.zshrc

| sh 安装完成后会提示如下信息： Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open ======== 2. 声明全局环境变量。 注意： TiUP 安装完成后会提示 Shell profile 文件的绝对路径。在执行以下 source 命令前，需要将 ${your_shell_profile} 修改为 Shell profile 文件的实际位置。 source ${your_shell_profile} 3. 在当前 session 执行以下命令启动集群。 • 直接执行 | sh 安装完成后会提示如下信息： Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: bash Shell profile: /home/user/.bashrc /home/user/.bashrc has been modified to add tiup to PATH open

successfully installed TiUP: Successfully set mirror to https://tiup-mirrors.pingcap.com Detected shell: zsh Shell profile: /Users/user/.zshrc /Users/user/.zshrc has been modified to add tiup to PATH open a ========= Have a try: tiup playground =============================================== Note the Shell profile path in the output above. You need to use the path in the next step. 2. Declare the global path of the correspond- ing Shell profile file. You need to modify ${your_shell_profile} in 99 the following source command according to the path. In this case, $ �→ {your_shell_profile} is /Users/user/