MARIADB Allow remote access

Enter the MARIADB server and change the value of the Mysql.user host field to% to indicate that you can log on to the MySQL server as root on any client machine, and it is recommended that you set it to% at development time.

1 MariaDB [(none)]> use MySQL

2

3 Database changed

4MariaDB [mysql]> Update user set host = '% ' where user = ' root ';

5

6Query OK, 1 row affected (0.11 sec)

7

Rows matched:1 changed:1 warnings:0

Replication code grants any host access to data:

1 MariaDB [mysql]> GRANT all privileges on * * to ' root ' @ '% ' identified by ' root '

2 with GRANT OPTION;

3 Query OK, 0 rows Affected (0.00 sec)

Refresh the permissions configuration to make it effective:

1 MariaDB [mysql]> FLUSH privileges; You can then log on to the database using root on any other host.

MARIADB Allow remote access