[ solved] Mysql connection issue
mageunic opened this issue ยท 0 comments
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