[Problem]Homepage error!

Page 2 of 2

04/22/2013 20:33 Spartan#117#16

You can type it in the MySQL console, but i recommend you to type it in Navicat or some other MySQL Client.

This is how you get to the MySQL console:

Code:

mysql -u root -p

Then you can type or copy and paste(with the right mouse button if you use PuTTY) the querys into the console. Don't forget to end every query with a semicolon! ( semicolon -> ; )

04/23/2013 11:58 HDesign#17

I do not know how to use a program PuTTY :)
I use Virtual Box

04/23/2013 14:50 Spartan#117#18

You should use a MySQL client, if you don't know how to run those querys in the console.

Use [Only registered and activated users can see links. Click Here To Register...].

04/23/2013 16:31 HDesign#19

i have navicat
but i don't know where can i type it

Code:

CREATE USER 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';

Code:

GRANT ALL ON account.* TO 'USERNAME'@'%';
GRANT ALL ON common.* TO 'USERNAME'@'%';
GRANT ALL ON hotbackup.* TO 'USERNAME'@'%';
GRANT ALL ON log.* TO 'USERNAME'@'%';
GRANT ALL ON player.* TO 'USERNAME'@'%';

Code:

FLUSH PRIVILEGES;

:)
( navivat or virtual box ? )

04/23/2013 16:38 Ras3ngan.#20

In navicat click on the server (right mouse button) and click "Console..."
There you can type in those lines.

04/23/2013 17:13 HDesign#21

oh .. thx
but not fixed
i create

Code:

user : roote
password : signe

and type

Code:

GRANT ALL ON account.* TO 'roote'@'%';
GRANT ALL ON common.* TO 'roote'@'%';
GRANT ALL ON hotbackup.* TO 'roote'@'%';
GRANT ALL ON log.* TO 'roote'@'%';
GRANT ALL ON player.* TO 'roote'@'%';

and type

Code:

FLUSH PRIVILEGES;

and edit the index to new user
not fixed :( :(

04/23/2013 18:00 Ras3ngan.#22

I assume you're using a Hamachi server...the Server DB, defined in line 16 would be the one on the Virtual Machine, aka ending with 100 if I'm not totaly wrong.
Also if I see it correctly you're using two databases, one for the website (running on your local xampp most likely) and the one on the server. But since 25.127.15.131 should be the IP of your PC it's the same as localhost, aka 127.0.0.1

04/23/2013 18:12 HDesign#23

okkay Fixed :)

Page 2 of 2