Saturday, August 29, 2009

Acess MySQL from anywhere (Ubuntu)

1. edit /etc/mysql/my.cnf
2. locate line that read as [mysqld]
3. make sure line skip-networking is commented and add line bind-address=YOUR-SERVER-IP
4. restart mysql service to take change in effect /etc/init.d/mysql restart
5. grant privileges in MySQL, GRANT ALL ON *.* TO 'username'@'%' IDENTIFIED BY 'PASSWORD';
6. update iptables, iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT

Firefox3 URL/Address Bar Tweak

Firefox3 address bar is running very slow. The following is a little workaround for it:

In about:config page, change these keys:

browser.urlbar.matchOnlyTyped = True
browser.urlbar.matchBehaviour = 2
browser.urlbar.maxRichResults = (max results, put between 2-5)
browser.urlbar.search.timeout = (search timeout, put something lower than 100, depending on your needs)