My router was recently changed and I tried to bridge it (act only as a modem) but it didn’t work. I had a perfect working Linksys router but my ISP had to changed my old modem to a 2 in 1 piece of shit Motorola SBG6580. The default gateway for the Motorola is different than the Linksys so I had to re-configure my server, which I did however there were some stuff that wasn’t working correctly. I didn’t know how to track it down or how to fix it so instead of going thru that headache I decided to change the Motorola default gateway/LAN IP address to what the Linksys was and it worked.
To change the LAN IP address from 192.168.0.1 to 192.168.1.1
log into you motorola router 192.168.0.1
Basic-> Setup-> change Lan Ip address to 192.168.1.1
then click apply. you wont be able to connect to wireless internet
so connect to the Ethernet cord and go to
Basic-> Setup-> click “Renew WAN LEASE”
After a long research and unnecessary changes in order to access mysql database over a PHP script or a command line/terminal. What is needed is to add privilege to you MySQL database and edit the my.cnf file, eg:
mysql> GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;
and comment out the line in /etc/mysql/my.cnf
# bind-address = 127.0.0.1
I’m using Ubuntu 11.10 and it didn’t need to install telnetd, or mess with the iptables. Again all is needed is to give or change mysql privileges and edit my.cnf.
Now an issue you may come across is having a firewall on your system like shorewall. Either stop shorewall (/etc/init.d/shorewall stop) or give privileges to allow access by editing the /etc/shorewall/rules and type mysql as an additional ACCEPT permission.
Now to access it outside your home network and anywhere in the world you’ll need to access your router port forward. Insert mysql port 3306 like you would do for you http 80 and ssh 22 request.
$ mysql -h192.168.1.1 -uUSERNAME -pPASSWORD
if you telnet you should see this
user@ubuntu:~ $ telnet youdomain.com 3306
Connected to yourdomain.com.
Escape character is '^]'.