Mastering MySQL Database Connectivity: Part 1 - ODBC

Hello, fellow tech enthusiasts! I Welcome you to our multi-part video tutorial series on connecting to a MySQL database using various applications. In this first part, we'll be setting up an ODBC connection to a MySQL database using Windows Administrative Tools. If you're struggling to establish an ODBC connection to a MySQL database through Windows Administrative Tools, you've come to the right place. Towards the end of the video, I have a special bonus tip for you! Make sure to stick around till the end to catch this valuable nugget of information.
Timestamps:
00:21 Example
03:31 MySQL Workbench and ODBC driver download information
04:58 Create Schema
06:33 Import data from csv file
09:10 Create user and grant privileges
10:46 Create ODBC connection
14:47 Connect Excel to MySQL database using ODBC connection
16:38 Connect Power BI to MySQL database using ODBC connection
18:15 Bonus tip
Download links:
MySQL Workbench - dev.mysql.com/...
MySQL ODBC Driver - dev.mysql.com/...
MySQL Connector/NET Latest version -dev.mysql.com/...
MySQL Connector/NET Older versions - downloads.mysq...

[@SwachalanKaar]

Timestamps:
00:21 Example
03:31 MySQL Workbench and ODBC driver download information
04:58 Create Schema
06:33 Import data from csv file
09:10 Create user and grant privileges
10:46 Create ODBC connection
14:47 Connect Excel to MySQL database using ODBC connection
16:38 Connect Power BI to MySQL database using ODBC connection
18:15 Bonus tip

[@abrarbajwa4878]

Is there anyway to connect power bi to essbase or Oracle fusion cloud? Can you recommend any bi connector to get Oracle fusion cloud.

[@SwachalanKaar]

Yes, you can find the details in the following documentation.
learn.microsoft.com/en-us/power-query/connectors/essbase
docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-analytics-cloud-microsoft-powerbi.html#GUID-A69C7A4E-3968-4DCE-A7F8-0AB01D268CE5