FLuxCP Message: SQLSTATE[HY000] [1130] Host 'xxxxxxxxxxx' is not allowed to connect to this MariaDB server

[Dolphin86]

im trying to install flux cp but this error came up saying host is not allowed to connect, also i upload mysql database user,

i have my web hosting and my vps on different hosting

 

 

server.php: are these correct? if so it will still have same result

<?php
return array(
	// Example server configuration. You may have more arrays like this one to
	// specify multiple server groups (however they should share the same login
	// server whilst they are allowed to have multiple char/map pairs).
	array(
		'ServerName'     => 'Jebat RO FluxCP',
		// Global database configuration (excludes logs database configuration).
		'DbConfig'       => array(
			//'Socket'     => '/tmp/mysql.sock',
			//'Port'       => 3306,
			//'Encoding'   => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
			'Convert'    => 'utf8',
				// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
				// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
			'Hostname'   => 'VPS IP',
			'Username'   => 'root', <-- should these be root or non root linux user? i try both didnt work
			'Password'   => 'HIDE',
			'Database'   => 'server_rag',
			'Persistent' => true,
			'Timezone'   => null // Example: '+0:00' is UTC.
			// The possible values of 'Timezone' is as documented from the MySQL website:
			// "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."
			// "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)
			// **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."
		),
		// This is kept separate because many people choose to have their logs
		// database accessible under different credentials, and often on a
		// different server entirely to ensure the reliability of the log data.
		'LogsDbConfig'   => array(
			//'Socket'     => '/tmp/mysql.sock',
			//'Port'       => 3306,
			//'Encoding'   => null, // Connection encoding -- use whatever here your MySQL tables collation is.
			'Convert'    => 'utf8',
				// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
				// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
			'Hostname'   => 'VPS IP',
			'Username'   => 'root',
			'Password'   => 'HIDE',
			'Database'   => 'server_rag',
			'Persistent' => true,
			'Timezone'   => null // Possible values is as described in the comment in DbConfig.
		),
		// Login server configuration.
		'LoginServer'    => array(
			'Address'  => 'VPS IP',
			'Port'     => 6900,
			'UseMD5'   => false,
			'NoCase'   => true, // rA account case-sensitivity; Default: Case-INsensitive (true).
			'GroupID'  => 0,    // Default account group ID during registration.
			//'Database' => 'ragnarok'
		),
		'CharMapServers' => array(
			array(
				'ServerName'      => 'JebatRO FluxCP',
				'Renewal'         => false,
				'MaxCharSlots'    => 9,
				'DateTimezone'    => null, // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
				//'ResetDenyMaps'   => 'sec_pri', // Defaults to 'sec_pri'. This value can be an array of map names.
				//'Database'        => 'ragnarok', // Defaults to DbConfig.Database
				'ExpRates' => array(
					'Base'        => 100, // Rate at which (base) exp is given
					'Job'         => 100, // Rate at which job exp is given
					'Mvp'         => 100  // MVP bonus exp rate
				),
				'DropRates' => array(
					// The rate the common items (in the ETC tab, besides card) are dropped
					'Common'      => 100,
					'CommonBoss'  => 100,
					// The rate healing items (that restore HP or SP) are dropped
					'Heal'        => 100,
					'HealBoss'    => 100,
					// The rate usable items (in the item tab other then healing items) are dropped
					'Useable'     => 100,
					'UseableBoss' => 100,
					// The rate at which equipment is dropped
					'Equip'       => 100,
					'EquipBoss'   => 100,
					// The rate at which cards are dropped
					'Card'        => 100,
					'CardBoss'    => 100,
					// The rate adjustment for the MVP items that the MVP gets directly in their inventory
					'MvpItem'     => 100
				),
				'CharServer'      => array(
					'Address'     => 'VPS IP',
					'Port'        => 6121
				),
				'MapServer'       => array(
					'Address'     => 'VPS IP',
					'Port'        => 5121
				),
				// -- WoE days and times --
				// First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday
				// Second parameter: Starting hour in 24-hr format.
				// Third paramter: Ending day (possible value is same as starting day).
				// Fourth (final) parameter: Ending hour in 24-hr format.
				// ** (Note, invalid times are ignored silently.)
				'WoeDayTimes'   => array(
					//array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM
					//array(3, '14:00', 3, '15:00')  // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM
				),
				// Modules and/or actions to disallow access to during WoE.
				'WoeDisallow'   => array(
					array('module' => 'character', 'action' => 'online'),  // Disallow access to "Who's Online" page during WoE.
					array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE.
				)
			)
		)
	)
);
?>

 

 

 

ok soo 

GRANT ALL PRIVILEGES ON `database`.* TO 'username'@'ip' IDENTIFIED BY 'password' WITH GRANT OPTION;

database is rathena_rag

username is non root linux id

ip is my vps ip or my web hosting ip?

and password is my non root linux id password?

Edited March 28, 2020 by dolphincute

[Dolphin86]

solution is to add new user on phpmyadmin with adding my webhosting IP on host box, after that edit my server.php on flux config files

all done problem solve thanks to @Sans

Edited March 28, 2020 by dolphincute

[chronoscrowler]

Hi Dolphincute,

 

I have the same issue now, do add the new user on the webhost phpmyadmin? please can you let me know how to fix this? thanks!

[xJhay]

On 3/29/2020 at 12:50 AM, dolphincute said:

solution is to add new user on phpmyadmin with adding my webhosting IP on host box, after that edit my server.php on flux config files

all done problem solve thanks to @Sans

life saverrrrrrrrrr.