Trouble importing data from mysql

Hi help1212 , Thank you for reaching out to the Microsoft Fabric Community Forum.

Make sure the MySQL service is running on your machine and that you can sign in directly using a tool like MySQL Workbench or the command line. If that direct login fails, fix the account before testing in Power BI. Next, install the correct MySQL Connector that matches your Power BI Desktop version (found under File -> About). Most people use the 64-bit edition of Power BI, so install the 64-bit version of either Connector/NET or Connector/ODBC. After installing, restart Power BI so it detects the new driver.

If Power BI still reports an authentication problem, open MySQL as an administrator and adjust the login to use a compatible authentication plugin. Run this command:

ALTER USER 'powerbi'@'localhost'
IDENTIFIED WITH mysql_native_password BY 'StrongPassword1!';
FLUSH PRIVILEGES;

Then reconnect in Power BI using Server = localhost:3306, Authentication = Database, and the username and password you just confirmed. Once the connector is installed, the service is reachable and the login works at the MySQL level, Power BI should establish a connection without further prompts.

Also, please refer below document:

Power Query MySQL database connector - Power Query | Microsoft Learn