Dynmap-Forge/Fabric

Dynmap-Forge/Fabric

888k Downloads

[ solved] Mysql connection issue

mageunic opened this issue ยท 0 comments

commented

template is bold
sample data is italicized

Issue Description: I'm trying to set up dynmap as standalone server with Mysql DB but I get this error ( [dynmap]: Error creating tables - null, message from server: "Host '127.0.0.1' is not allowed to connect to this MariaDB server" ) when launching the server. I don't know how to solve this problem.....

  • Dynmap Version: dynmap v3.2-beta-1-470
  • Server Version: Spigot/CraftBukkit 1.16.5
  • Pastebin of Configuration.txt: https://pastebin.com/yH3bTfa1
  • Server Host (if applicable): * Selfhosted using AMP CuberCoders*
  • Pastebin of crashlogs or other relevant logs: *[dynmap]: Enabling dynmap v3.2-beta-1-470
    10:52:51
    [dynmap]: Using LuckPerms 5.3.3 for access control
    [dynmap]: Opening MySQL database 127.0.0.1:3306/dynmap as map store
    Server thread/ERROR10:52:51
    [dynmap]: Error creating tables - null, message from server: "Host '127.0.0.1' is not allowed to connect to this MariaDB server"
    [dynmap]: Map storage initialization failure
    Server thread/INFO10:52:51
    [dynmap]: Unloaded 0 components.
    [dynmap]: Disabled
  • Other Relevant Data/Screenshots: *i'm using nextcloud and I have no problem with MariaDB, some info of the config ( my.cnf):
    [server]
    skip_name_resolve = 1
    innodb_buffer_pool_size = 128M
    innodb_buffer_pool_instances = 1
    innodb_flush_log_at_trx_commit = 2
    innodb_log_buffer_size = 32M
    innodb_max_dirty_pages_pct = 90
    query_cache_type = 1
    query_cache_limit = 2M
    query_cache_min_res_unit = 2k
    query_cache_size = 64M
    tmp_table_size= 64M
    max_heap_table_size= 64M
    slow_query_log = 1
    slow_query_log_file = /var/log/mysql/slow.log
    long_query_time = 1

[client]
default-character-set = utf8mb4

[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
transaction_isolation = READ-COMMITTED
binlog_format = ROW
innodb_large_prefix = on
innodb_file_format = barracuda
innodb_file_per_table = 1
bind-address = 127.0.0.1
*

  • Steps to Replicate: error at each server startup

[x ] I have looked at all other issues and this is not a duplicate
[x ] I have been able to replicate this