Mysql error

[xzeusx]

Hello I having trouble with the connection to the database its on another computer and i use navicat to connect to mysql and it says that im not allowed to connect to this mysql can anyone help me?

All the ports are open for the computer so cant be that.

 

[Cobra101]

Username/Password. Also might not have been configed right. You need to select an option in the instance config of mysql to allow other computers root access.

 

[xzeusx]

im using mangos ~amber~ rev and it standalone but when ever i try and connect from my other computer to enter the DB i get message that my host Ip is not allowed to connect to the mysql

 

[EvilRyu]

im using mangos ~amber~ rev and it standalone but when ever i try and connect from my other computer to enter the DB i get message that my host Ip is not allowed to connect to the mysql

When you run the sql from the frontend, goto adminphp.
And make sure privlegies are set correctly.

 

[xzeusx]

how wood i set them like u mean the pw for all 3 or just mangos and root?

 

[Yamachi]

No, you need to set up a user privilege for the computer you are trying to connect to the database with. Choose a username and pass, and in the "host" section, put the IP of the machine that you are trying to connect to the DB with, or leave it blank to allow any host to connect with that user and pass.

 

[xzeusx]

ahh i see now thx

 

[xzeusx]

one problem left do i have to make a privlege for ppl thats coming on b/c now i cant connect to the server keeps telling me connecting?
but the site works and everything

some thing to do with mysql?

 

[EvilRyu]

one problem left do i have to make a privlege for ppl thats coming on b/c now i cant connect to the server keeps telling me connecting?
but the site works and everything

some thing to do with mysql?

You must of done something wrong when setting up your ip's, recheck what ip's the server is being used.
Should all be set to 127.0.0.1 if your playing on the same computer, or even on lan. You would just edit your games wtf file to match the computers ip on the network.

As for outbound server, you would have to make an no-ip account or any other one like it.

Check: mangosd.conf realmd.conf "I think your running a diskw one" So make sure you edit: diskw\www\index.php and config.php to match the ip's with realmd.conf

 

[xzeusx]

well i checked the mangos.conf and realmd.conf there both the same
there 127.0.0.1;3306;root;*****;mangos same with logn

um and for the config.php i check
'host'=>'localhost',
'user'=>'root',
'password'=>'*****',
'db'=>'realmd'

and for the index.php there is nothing to change there

 

[xzeusx]

well i checked the mangos.conf and realmd.conf there both the same
there 127.0.0.1;3306;root;*****;mangos same with logn

um and for the config.php i check
'host'=>'localhost',
'user'=>'root',
'password'=>'*****',
'db'=>'realmd'

and for the index.php there is nothing to change there

EDIT: Frnds tell me that they connect and they select a realm but the realm list keeps popping up

 

[shivajiva101]

What have you got for address in the realmlist table?

 

[xzeusx]

my router ip

 

[shivajiva101]

It works much better with a no-ip

 

[xzeusx]

well i do have that too but still doesnt work

can it be something esle? wrong witht the server