[GUIDE-DETIALED] How to setup a server!

Page 11 of 20 « First 910 11 1213 Last »
03/19/2010 00:30 Medo21#151
i made what u said,but it don't work,i want someone tell me how to make someone connect to my db ? and what this one should do? and ty arthur for ur guide
03/19/2010 00:53 King_Arthur#152
Quote:
Originally Posted by Medo21 View Post
i made what u said,but it don't work,i want someone tell me how to make someone connect to my db ? and what this one should do? and ty arthur for ur guide
Code:
grant all privileges on *.* to 'username' @ 'ipaddress' identified by 'password';
This will give whatever person you put in full database access to do anything but add other people. They could potentially drop your whole database if they wanted to. So you should use a nice GUI like navicat and remove what you don't want them to have access to. On the other side, you could do:
Code:
grant usage on *.* to 'username' @ 'ipaddress' identified by 'password';
and then add only what you want them to have access to. The first option is usually easier.
03/19/2010 00:59 Medo21#153
i did this and it says when i added the user name and pass and give them to my friend,it said that he can't connect or something like that
03/19/2010 01:04 King_Arthur#154
Make sure any firewalls or routers are configured to let inbound connections from his IP and port 3306 is open as well.
03/19/2010 01:09 Medo21#155
i did that,now it says access is denied for.....,in the HostName/Ip Address,what i have to put in it and in Connection name
?
03/19/2010 01:14 King_Arthur#156
Connection name can be anything. For hostname/ipaddress most people just put in the IP of the person you are trying to let connect. Have them go to a site like [Only registered and activated users can see links. Click Here To Register...] and have them send you the IP. Then go to his user and change the ip that is there.
03/19/2010 01:22 Medo21#157
ty Arthur,now i need to delete everything was saved from the begining,there's ppls name in donations and castle and i will try to restart everything,tell me the way if u wanna :P
03/19/2010 01:30 King_Arthur#158
This will wipe everything: [Only registered and activated users can see links. Click Here To Register...]
03/19/2010 01:56 Medo21#159
Nothing works in the shopping mall,what i should do?
03/19/2010 23:29 Medo21#160
i mean when i first entered the game (my server) and opened the mall to check if it works,i can't buy anything..what i have to do?
03/23/2010 23:46 Medo321#161
Is there a problem with item.dat or anything?
03/25/2010 21:38 denersc#162
it says invalid username or password when i try to login. Im sure everything is set to root and test, what do i do?
03/25/2010 22:17 King_Arthur#163
Quote:
Originally Posted by denersc View Post
it says invalid username or password when i try to login. Im sure everything is set to root and test, what do i do?
root.test is for your database. They are not login credentials to login to the game. You must add an account to your database to login to the game or use one that has already been created.
03/25/2010 23:25 Medo21#164
if ur db is the Mannequin db,then ur game account login id is dark and pass is explorer
03/25/2010 23:39 thaisun#165
Hey, two things, when i try to epen msg server or npc.exe, the open and say unable to connect to database, then close. and the time it actually did work, my server when i tried to login, said it was down. any help?
Page 11 of 20 « First 910 11 1213 Last »