acnauchiha Posted March 25, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 4 Reputation: 0 Joined: 03/07/12 Last Seen: March 27, 2012 Share Posted March 25, 2012 (edited) Hey Guys, I have some troubles with my flux cp, when I click on My account, purchase, item database and mob database an error appears :C Look at this: Error: Flux_Error Message: Failed to create temporary table '_royaltyro.items'. Error info: Array ( [0] => 42000 [1] => 1044 [2] => Access denied for user 'asdasd'@'%' to database '_asdasd' ) How can I fix it? seriuosly I'm suffering with that horrible error messages u_u. than kyu SOLVED ^^ Edited March 27, 2012 by acnauchiha Link to comment Share on other sites More sharing options...
Asura Posted March 25, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted March 25, 2012 Hi acnauchiha, Do you have item_db, and mob_db imported into your SQL database? If yes, please turn the debug mode in 'applications.php' to true and also the error reporting in 'error.php' to true as well; after doing that, report what you see on the very top of the page, there should be an error message. Link to comment Share on other sites More sharing options...
acnauchiha Posted March 25, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 4 Reputation: 0 Joined: 03/07/12 Last Seen: March 27, 2012 Author Share Posted March 25, 2012 Hi Asura, thanks for your reply ^^ Look, I turned on the debug mode (application.php file) and $showexceptions to true in the error.php one but the error message still appearing Error: Flux_Error Message: MySQL error (SQLSTATE: 42000, ERROR: 1044): Access Denied (4 user and database) Link to comment Share on other sites More sharing options...
Asura Posted March 25, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted March 25, 2012 (edited) Hi acnauchiha, It seems that your FluxCP cannot properly establish the connection to your MySQL database. Go to 'servers.php' and confirm your MySQL information to make sure it is correct, and also make sure that the account you are using to access the MySQL has the privilege to be used remotely. If everything checks out; I can only recommend that you contact your webhost and ask him to whitelist your MySQL database IP. Edited March 25, 2012 by Asura Link to comment Share on other sites More sharing options...
JayPee Posted March 25, 2012 Group: Members Topic Count: 47 Topics Per Day: 0.01 Content Count: 633 Reputation: 78 Joined: 11/14/11 Last Seen: September 20, 2017 Share Posted March 25, 2012 Hey Guys, I have some troubles with my flux cp, when I click on My account, purchase, item database and mob database an error appears :C Look at this: Error: Flux_Error Message: Failed to create temporary table '_royaltyro.items'. Error info: Array ( [0] => 42000 [1] => 1044 [2] => Access denied for user 'asdasd'@'%' to database '_asdasd' ) How can I fix it? seriuosly I'm suffering with that horrible error messages u_u. than kyu Base on this error it seems your FluxCP has no rights in CREATE TEMPORARY TABLE. You should grant your FluxCP a CREATE TEMPORARY TABLE in your MySQL. 2 Link to comment Share on other sites More sharing options...
acnauchiha Posted March 25, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 4 Reputation: 0 Joined: 03/07/12 Last Seen: March 27, 2012 Author Share Posted March 25, 2012 Ok, I just sent a message to the webhost manager because you guys are right, My Sql user has not the permissions to make changes on my database or make temporary tables just like the error message says. JayPee ¿How can I grant permissions to my FLUXCP o.o? Anyway. I'm waiting for the webhost manager reply Thank you guys! *-* Link to comment Share on other sites More sharing options...
whitesn Posted March 26, 2012 Group: Members Topic Count: 13 Topics Per Day: 0.00 Content Count: 193 Reputation: 14 Joined: 12/02/11 Last Seen: October 30, 2018 Share Posted March 26, 2012 Why waiting your webhost, you've the right to change it yourself. Go to phpmyadmin as root user then grant CREATE permission for the user you use for fluxcp ( config ) Link to comment Share on other sites More sharing options...
acnauchiha Posted March 27, 2012 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 4 Reputation: 0 Joined: 03/07/12 Last Seen: March 27, 2012 Author Share Posted March 27, 2012 Why waiting your webhost, you've the right to change it yourself. Go to phpmyadmin as root user thengrant CREATE permission for the user you use for fluxcp ( config ) Yeah I know what do you say but I'm not able to do that (1044 error). The webhost manager fixed the trouble ^^ Thank you guys for your time I appreciate it alot. Link to comment Share on other sites More sharing options...
Question
acnauchiha
Hey Guys, I have some troubles with my flux cp, when I click on My account, purchase, item database and mob database an error appears :C
Look at this:
Error: Flux_Error
Message: Failed to create temporary table '_royaltyro.items'.
Error info: Array
(
[0] => 42000
[1] => 1044
[2] => Access denied for user 'asdasd'@'%' to database '_asdasd'
)
How can I fix it?
seriuosly I'm suffering with that horrible error messages u_u.
than kyu
SOLVED ^^
Edited by acnauchihaLink to comment
Share on other sites
7 answers to this question
Recommended Posts