MARIADB Configure how remote access is allowed

First, configure the user to allow access, in an authorized manner to the user rights

1	GRANTALL PRIVILEGES ON *.* TO ‘root‘@‘%‘IDENTIFIED BY ‘123456‘ WITH GRANTOPTION;

Description: Root is the user logging into the database, 123456 is the password to log in the database, * means that any source of any host, anyway, is the right to a large appearance.

Finally, you should not forget to make the refresh effective after you configure the permissions.

1	flush privileges;

It's OK to visit again.

MARIADB Configure how remote access is allowed