MariaDB – allow user to connect from anyhost

Use the following command in your server to allow user to connect from anyhost:

RENAME USER 'root'@'localhost' TO 'root'@'%';
FLUSH PRIVILEGES;