help about flux

[darking123]

i used the official flux cp and it works

but when i used other flux cp themes or flux cp integrated

this message shows

Access denied for user 'root'@'localhost' (using password: YES)

[Sryx]

'DebugMode'            => true,

$showExceptions  = true;

For more error info.

[darking123]

got an error sir

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in/home/reviser/public_html/themes/default/gthemes/playerCap.phpon line 9

Access denied for user 'root'@'localhost' (using password: YES)

this is my playerCap.php

<?php
if (! defined('FLUX_ROOT')) exit;

$host  = $session->loginAthenaGroup->connection->logsDbConfig->Hostname();
$username  = $session->loginAthenaGroup->connection->logsDbConfig->getUsername();
$password  = $session->loginAthenaGroup->connection->logsDbConfig->getPassword();
$db    = $session->loginAthenaGroup->connection->logsDbConfig->getDatabase();
$link = mysql_connect($host, $username, $password) or die(mysql_error());
@mysql_select_db($db,$link);
$sql = "SELECT COUNT(`char`.char_id) AS total FROM {$server->charMapDatabase}.`char` ";
if (Flux::config('HideTempBannedStats')) {
$sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = `char`.account_id ";
$sql .= "WHERE login.unban_time <= UNIX_TIMESTAMP()";
}
if (Flux::config('HidePermBannedStats')) {
if (Flux::config('HideTempBannedStats')) {
 $sql .= " AND login.state != 5";
} else {
 $sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = `char`.account_id ";
 $sql .= "WHERE login.state != 5";
}
}
$result = mysql_query($sql,$link);
mysql_close($link);
$arr = mysql_fetch_array($result);
$player_cap = $arr['total'];
?>
<p id="playerCap"><?php echo $player_cap; ?></p>

Edited December 26, 2012 by glemor123

[Sryx]

Try to be specific in this part. Just change those value.

$host  = '127.0.0.1';
$username = 'root';
$password  = '';
$db   = 'db_name';

[darking123]

i already did but there is still the problem

[Winz]

Try to grant the flux CP table from the MySQL,

CLI:

GRANT SELECT, INSERT, DELETE ON `FluxCP database name / schema name` TO root@'localhost' IDENTIFIED BY 'the password for root password';

Then, do:

 FLUSH PRIVILEGES; 

Have a nice day!

[darking123]

already done there still an error

[Winz]

hmm, just to make sure, did you put your password on the configurations properly?

Have a nice day!

[darking123]

yes i put and i double check

my original flux cp works

but when i add the other themes i got that error

[Winz]

well then, may I have a copy of the files too? I want to try it too.

have a nice day!

[darking123]

here http://rathena.org/board/files/file/2363-free-flux-themes-design-no-2/

anyone who can help me

i still need help

[Winz]

hello, glemor123

Thank you for giving me the link. I've tried it too and it works perfectly on me..

Maybe, you want to consider reinstalling your fluxCP by re-pasting your fluxcp-renewal.rar to your htdocs and try to use 'ragnarok' (or whatever your Ragnarok Server use to connect to your SQL database) as your FluxCP Username, instead of root.

Have a nice day!

[darking123]

hello, glemor123

Thank you for giving me the link. I've tried it too and it works perfectly on me..

Maybe, you want to consider reinstalling your fluxCP by re-pasting your fluxcp-renewal.rar to your htdocs and try to use 'ragnarok' (or whatever your Ragnarok Server use to connect to your SQL database) as your FluxCP Username, instead of root.

Have a nice day!

i already tried that many times but still the problem occur

[Mootie]

First of all before adding new theme make sure that you are using renewal flux that compatible with the theme that you are doing to use....( uhhh corret )