View Single Post
King Cnut
Senior Member
Join Date: Sep 2014
Old 08-16-2015 , 15:06   Re: [Release] SourceBans: Reloaded 1.5.2F (Updated 2015/05/29)
#157

Quote:
Originally Posted by scso1502 View Post
@ King Cnut

Perhaps increasing the privileges of the MySQL user would help? I don't believe "GRANT and FLUSH PRIVILEGES" will give the access the MySQL user account needs to connect and run correctly with SourceBans. In fact, I don't remember ever seeing anyone restrict the MySQL Sourcebans user account access that way. I don't restrict MySQL user accounts and always use the "ALL [PRIVILEGES]" setting for them. I've never had any problems doing this.

Give it a shot and see...
Sorry for being vague. I do use GRANT ALL as such:

Code:
grant all privileges on sourcebans.* to 'user'@'188.XXX.XXX.XXX' identified by 'password';
188.XXX.XXX.XXX being the address of my game server.

My database.cfg is listed as this:

Code:
	"sourcebans"
	{
		"driver"			"default"
		"host"				"104.XXX.XXX.XXX"
		"database"			"sourcebans"
		"user"				"user"
		"pass"				"password"
		//"timeout"			"0"
		"port"			"3306"
	}
104.XXX.XXX.XXX is the webserver ip where my Database resides.
__________________
*tips fedora, unsheaths katana, teleports behind u, nods respectfully*
King Cnut is offline