Finbi connects to native MySQL

1、win+R Input CMD, Press ctrl+shift+enter, Administrator access ;

2、cd MySQL Under the table of contents bin Catalog ; Get into mysql root directory ;

3、mysql -u root -p password;

4、show global variables like 'port'; Check the port ： It's usually 3306

5、show databases; View the database name to use ; for example mysql etc.

6、 Get into Finebi Management system , Data connection , New data connection ;

7、 Database name ：mysql（ Library name to use ）（ Add after ?useSSL=false&serverTimezone=UTC）

Complete as ：mysql?useSSL=false&serverTimezone=UTC

8、 Host name ：localhost, port ：3306（ Of the query port value ）

9、 Fill in the user name and password ;

10、 Write a simple verification statement sql go in ;

11、 Test connection , Show that the connection is successful ;