MariaDB – allow user to connect from anyhost

Cristi Draghici June 15, 2016 June 15, 2016

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;