I am having the same problem as this topic.
I used the mariaDB.bat
and my conf/global/sql_connection.conf ended up having this.
sql_connection: {
db_username: "hercules"
db_password: "***"
db_database: "hercules"
}
I updated the file to be the same as the one on github
//================= Hercules Configuration ================================
//= _ _ _
//= | | | | | |
//= | |_| | ___ _ __ ___ _ _| | ___ ___
//= | _ |/ _ \ '__/ __| | | | |/ _ \/ __|
//= | | | | __/ | | (__| |_| | | __/\__ \
//= \_| |_/\___|_| \___|\__,_|_|\___||___/
//================= License ===============================================
//= This file is part of Hercules.
//= http://herc.ws - http://github.com/HerculesWS/Hercules
//=
//= Copyright (C) 2014-2021 Hercules Dev Team
//=
//= Hercules is free software: you can redistribute it and/or modify
//= it under the terms of the GNU General Public License as published by
//= the Free Software Foundation, either version 3 of the License, or
//= (at your option) any later version.
//=
//= This program is distributed in the hope that it will be useful,
//= but WITHOUT ANY WARRANTY; without even the implied warranty of
//= MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
//= GNU General Public License for more details.
//=
//= You should have received a copy of the GNU General Public License
//= along with this program. If not, see <http://www.gnu.org/licenses/>.
//=========================================================================
//= SQL connection configuration file.
//=========================================================================
// This file affects how ALL server sql connections work, unless explicitly
// defined so in the server configuration file (See
// doc/global_configuration.txt for more information).
//=========================================================================
sql_connection: {
// [INTER] You can specify the codepage to use in your mySQL tables here.
// (Note that this feature requires MySQL 4.1+)
//default_codepage: ""
// [LOGIN] Is `userid` in account_db case sensitive?
//case_sensitive: false
// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1.
// Under windows, you want to use 127.0.0.1. If you see a message like
// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
// and you have localhost, switch it to 127.0.0.1
db_hostname: "127.0.0.1"
db_port: "3306"
db_username: "hercules"
db_password: "******"
db_database: "hercules"
//codepage:""
}
I am db name and username appears to be correct as i'm able to connect through mysql workbench.
[Error]: conf/global/sql_connection.conf:1 - syntax error
[Info]: Server uses 'select' as event dispatcher
[Info]: Server supports up to '4096' concurrent connections.
[Error]: conf/global/sql_connection.conf:1 - syntax error
[Status]: Read information about 1 LAN subnets.
[Status]: Read information about 1 trusted IP ranges.
[Status]: Read information about 1 allowed server IP ranges.
[Warning]: Using a wildcard IP range in the allowed server IPs is NOT RECOMMENDED.
[Notice]: Please edit your 'conf/network.conf' allowed list to fit your network configuration.
[SQL]: Access denied for user 'ragnarok'@'localhost' (using password: YES)