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;