- 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:
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:
Default;
Mysql database name: pw
Mysql login: root
Mysql password: game
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