[Linux] Remote MySQL

Recently, I'm trying to remote access MySQL database from different computer.
Finally I have it work!

Step 1: change setting info in /etc/mysql/my.cnf

• comment out bind-address = 127.0.0.1 (it's for localhost only)
• add safe-show-database (for security reason)
• change server and client mysql default port 3306 to any other port number (e.g. 12345)
  

Step 2: save my.cnf file and restart MySQL
Step 3: open the specific port you just set
Step 4: test & done!

[Linux] Kubuntu hostname setup

I saw my kubuntu box displayed as "Unknown" server name in my router.
Here is the solution to fix unknown hostname problem:
sudo vi /etc/dhcp3/dhclient.conf
change send host-name "newHostName";

Learned from: Fix hostname unknown in router

[Linux] Kubuntu Printer Setup

Kubuntu 6.06 Printer Setup

Maybe your system can setup printer correctly, if not, here is the solution:

sudo foomatic-cleanupdrivers
sudo adduser cupsys shadow
sudo dpkg-reconfigure cupsys

Open your browser and type the url:
http://localhost:631/

Step by step to setup your printer:

1. click "Administraion" Tab
2. from the listing printers, click to add the correct one
3. change to "Printers" Tab, click "Set as Default"
4. Done