MySQL/MariaDB root user lost privileges

Issue

• After allowing root to login from remote location, all privileges were lost
• Below command was used:
  CREATE USER root@'%' IDENTIFIED BY 'password';

• When connecting to MariaDB server over network, below error message was returned:

  MariaDB [(none)]> use mysql;
  ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'mysql'
  

• When showing grants, ALL privilege was lost:

  MariaDB [(none)]> show grants for root;
  +-------------------------------------------------------------------------+
  | Grants for root@%                                                       |
  +-------------------------------------------------------------------------+
  | GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*62AB24D83318' |
  +-------------------------------------------------------------------------+
  1 row in set (0.00 sec)