Problem connecting with mysql

[pellon]

Hi

I have problems to connect with a mysql databse, i have already red many topicss about this issue but it is still not working... 

i go to get data-mysql database, then in Server i write the  server IP and the database name.

I go to database (instead of windows option) and then i fill username and password (same ones used for the odbc connection) and i get the following error: "we couldnt authenticate with the credentials provided. Please try again"

Both odbc for 32 and 64 bits connections are working (Test in odbc connector states that connection works), i am using same user name and password (copy-pasted them). The most surprising thing for me is that i can connect and use queries for the same database in an excel file, so it should be any odbc connection issue (as i have read is the most common issue)

The database i am connecting to has to be accesed via port 33306 instead of default 3306. The odbc connections are set up with 33306 and no problem, i dont know if this is the cause of the problem, cause i see no option to change connection port in power bi...on the other hand, is possible to set the connection with the dsn instead of the ip?

Thanks!

[pellon · Accepted solution]

Its already solved.

i just wrote ip : port and it worked.