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;

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

Development