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!

Grant Access To Remote IP Address

Custom Title Activated
Loyal Member
Joined
Aug 23, 2010
Messages
1,529
Reaction score
404
This tutorial for connecting Mysql with Navicat on your Windows side

Swordsman Online VirtualBox Repack + Server Files
http://forum.ragezone.com/f869/release-swordsman-online-virtualbox-repack-1005099

Open Terminal console on CentOS or use Putty

Connect to mysql server:
Code:
mysql -u root -p mysql

Grant access to a new database:
If you want to add a new database called pw for user root and remote IP 192.168.2.2 (this is your Windows local ip) then you need to type the following commands at mysql> prompt:

Code:
mysql> CREATE DATABASE [COLOR="#FF0000"]pw[/COLOR];
mysql> GRANT ALL ON [COLOR="#FF0000"]pw[/COLOR].* TO [COLOR="#FF0000"]root[/COLOR]@'202.54.10.20' IDENTIFIED BY '[COLOR="#FF0000"]game[/COLOR]';

Default;
Mysql database name: pw
Mysql login: root
Mysql password: game
 
Back
Top