Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Mysql error

Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
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.
 
Junior Spellweaver
Joined
Jul 11, 2006
Messages
139
Reaction score
0
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.
 
Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
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
 
Elite Diviner
Joined
May 25, 2006
Messages
484
Reaction score
0
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.
 
Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
how wood i set them like u mean the pw for all 3 or just mangos and root?
 
Banned
Banned
Joined
Oct 20, 2006
Messages
3,245
Reaction score
1,652
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.
 
Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
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?
 
Elite Diviner
Joined
May 25, 2006
Messages
484
Reaction score
0
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
 
Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
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
 
Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
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
 
Newbie Spellweaver
Joined
Jan 8, 2006
Messages
65
Reaction score
0
well i do have that too but still doesnt work

can it be something esle? wrong witht the server
 
Back
Top