Flux CP Error on MyAccount and Databases

[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 March 27, 2012 by acnauchiha

[Asura]

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.

[acnauchiha]

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)

[Asura]

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

[JayPee]

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.

[acnauchiha]

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! *-*

[whitesn]

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 )

[acnauchiha]

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 )

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.