Posted 2020-09-02 with tags MariaDB, MySQL, sysadmin

On the interactive prompt use the follwing to create a separate user in mariadb/mysql for remote administration:

GRANT ALL ON *.* TO 'administrative_user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILGES;

Make sure to update your mysql/mariadb config file to accept remote connections and add an entry in the firewall to allow access.

To grant access to a block of IP addresses the portion after the @ syntax can take the following form:

GRANT ALL PRIVILEGES ON *.* TO 'sergey_brin'@'192.168.100.%' IDENTIFIED BY 'hunter!' WITH GRANT OPTION;