Skip to content

Home

Jump to bottom
songwutk edited this page May 2, 2023 · 6 revisions

If down docker container and up again, frappe can't run because db connection error.

change data in mysql global_priv table change host column, set value to %

MariaDB [mysql]> select host,user,password from user;
+--------------+-------------+-------------------------------------------+
| Host         | User        | Password                                  |
+--------------+-------------+-------------------------------------------+
| localhost    | mariadb.sys |                                           |
| localhost    | root        | *2D2954754BDCC00EF903F3A2457FCDFBE1162EA0 |
| %            | root        | *2D2954754BDCC00EF903F3A2457FCDFBE1162EA0 |
| 192.168.64.4 | frappe      | *033A297071D7C0D656B88C9FC113C36DCD8CDAF0 |
+--------------+-------------+-------------------------------------------+
4 rows in set (0.009 sec)

MariaDB [mysql]> RENAME USER "frappe"@"192.168.64.4" TO "frappe"@"%";
Query OK, 0 rows affected (0.065 sec)

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.070 sec)
Clone this wiki locally