Forward port 80 to LAN WebServer , this is to have home webserver
can be used for others port also

Very Simple, here is the image, click to enlarge

[root@db-svr ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> CREATE DATABASE linux_db;
Query OK, 1 row affected (0.03 sec)

mysql> GRANT SELECT,INSERT,UPDATE,DELETE
-> ON linux_db.*
-> TO linux@localhost
-> IDENTIFIED BY 'linuxdbpaswd';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database
+--------------------+
| information_schema
| linux_db
| mysql
+--------------------+
3 rows in set (0.00 sec)

mysql> \q
Bye
[root@db-svr ~]#

By Default MySQL server will answer any incoming telnet to
the machine from outside, so we need to disable this

(Add entry at my.cnf)
[root@noc ~]# nano -w /etc/my.cnf

[mysqld]
bind-address=127.0.0.1

(Restart MySQL)
[root@noc ~]# /sbin/service mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
[root@noc ~]#

(From Now any scan to that port from outside will not be answered)

MySQL need to clean up for security reason after first installation
Do as following :-

[root@svr ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop database test;
Query OK, 0 rows affected (0.02 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> delete from db;
Query OK, 2 rows affected (0.00 sec)

mysql> delete from user where not (host="localhost" and user="root");
Query OK, 3 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye

From Linux Laptop

ssh -f -L 3000:localhost:3306 root@db-server.net sleep 2d

Now open MySQL Administrator make connection



click Connect and there you go



FYI, dont worry server status shown down, its local in laptop is down
but the server you maintain remote is alive ,

happy backup :)