darking123 Posted December 26, 2012 Posted December 26, 2012 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 Posted December 26, 2012 Posted December 26, 2012 'DebugMode' => true, $showExceptions = true; For more error info.
darking123 Posted December 26, 2012 Author Posted December 26, 2012 (edited) 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 Posted December 26, 2012 Posted December 26, 2012 Try to be specific in this part. Just change those value. $host = '127.0.0.1'; $username = 'root'; $password = ''; $db = 'db_name';
darking123 Posted December 26, 2012 Author Posted December 26, 2012 i already did but there is still the problem
Winz Posted December 26, 2012 Posted December 26, 2012 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 Posted December 26, 2012 Author Posted December 26, 2012 already done there still an error
Winz Posted December 26, 2012 Posted December 26, 2012 hmm, just to make sure, did you put your password on the configurations properly? Have a nice day!
darking123 Posted December 26, 2012 Author Posted December 26, 2012 yes i put and i double check my original flux cp works but when i add the other themes i got that error
Winz Posted December 26, 2012 Posted December 26, 2012 well then, may I have a copy of the files too? I want to try it too. have a nice day!
darking123 Posted December 26, 2012 Author Posted December 26, 2012 here http://rathena.org/board/files/file/2363-free-flux-themes-design-no-2/ anyone who can help me i still need help
Winz Posted December 27, 2012 Posted December 27, 2012 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 Posted December 27, 2012 Author Posted December 27, 2012 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 Posted December 27, 2012 Posted December 27, 2012 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 )
Question
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)
13 answers to this question
Recommended Posts