powerbi

If you are trying to connect Power BI to a Mysql/MariaDB server and receive the error “MySQL: Host ‘IP’ is not allowed to connect to this MariaDB server” perform the following

Login into the server via ssh

sudo bash

mysql -u root -p

Enter your mysql password

Type in the following:

CREATE USER 'newusernamehere'@'localhost' IDENTIFIED BY 'newpassword';
GRANT ALL PRIVILEGES ON *.* TO 'newusernamehere'@'localhost' WITH GRANT OPTION;
CREATE USER 'newusernamehere'@'%' IDENTIFIED BY 'newpassword';
GRANT ALL PRIVILEGES ON *.* TO 'newusernamehere'@'%' WITH GRANT OPTION;

Now retry your connection in Power BI using the new user and password you specified above