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
