windows安装在线Sql查询工具“Sqlpad”

windows安装Sqlpad

 

1.安装nodeJS

官网下载安装 https://nodejs.org/en/

 

2.安装sqlpad

npm install sqlpad -g

 

3.启动

• 启动之前需要新建配置目录

C:\Users\Administrator\sqlpad\db

• 将上面目录作为初始目录启动sqlPad

  sqlpad --dbPath "C:\Users\Administrator\sqlpad\db"

   

启动成功

C:\Users\Administrator>sqlpad --dbPath "C:\Users\Administrator\sqlpad\db"
optional driver ../drivers/unixodbc not available

Port 80 already occupied. Using port 81 instead.

Welcome to SQLPad!. Visit http://localhost:81 to get started

 

 碰到问题

[SELECT ERROR] -  ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决：

mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.27 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.08 sec)