When installing MySQL on a server and want to access it from an other machine than itself, this is easy done and should work on most platforms.

1. After installation of MySQL open up MySQL prompt.
# mysql -u root

2. Change to mysql database as default database and update access for root account.
mysql> use mysql
mysql> update db set Host=’%’ where db=’mysql’;
mysql> exit

3. Restart MySQL and you should be able to access it from another host and configure it the way you want.
# /etc/rc.d/mysql restart

Setting a static ip on openSUSE in server mode isn’t hard, one just need to remember to fill in all necessary settings.


1. Start yast2 and go to Network Settings and fill in following information.
% sudo -i
# yast2
Go to: Network Devices -> Network Settings -> Hostname/DNS
Set: Hostname, Write Hostname to /etc/hosts, Domain Name, Name Server 1-4 and Domain Search

2. Set default gateway, needed for internet/network access.
Go to: Network Devices -> Network Settings -> Routing
Set: Default Gateway

Click Ok and your settings will be saved, reboot the server to initiate the settings.

In short while there will be a new category called openSUSE, that will contain various tips and how-to’s for openSUSE.

The reason why i focus more on openSUSE is the fact that I’m very interested in programming in .NET with Mono and the Mono & MonoDevelop packages are fresher than those on Ubuntu, i will certainly keep Ubuntu for some of my systems as i run Zimbra on it, and i will not abandon it completely, still like Ubuntu, it just doesn’t do it for me right now.

If you can read this it means that i have decided to remove my static page as a startpage on my blog for now, from now on it will show my latest posts directly on my startpage.

This is to give my page a more blog like look as this tool is meant for.

/Soulskater