VNC on openSUSE 11 was 10.3

As some other colleagues, I ran into some trouble upgrading from openSuse 10.3 to openSuse 11 when using VNC.

My server is located in a data-center, so I usually use ssh to logon. In rare occasions I want to graphically take control (when it’s time for a new kernel). And from openSuse 11 this isn’t that simple anymore.

Lot’s of Google hits on this problem, but it depends on your configuration. I’ve got 2. First:
-edit /etc/xinetd.d/vnc and set depth to 32 bits
-remove any IPv6 reference in your /etc/hosts file

But I know for sure that I’ve accomplished something else when I created my first openSuse 11 (vmware) installation way-back in 2009. I’ve forgotten how I’ve managed that one, but it still has its IPv6 references. So, I’ll get back on that one!

For now, my new (fallback) host is configured for remote access. I’ll get back in touch when I’ve discovered the other solution.

Setting MySQL root password for the first time

Reminder, on Linux set password for the first time:

mysqladmin -u root password THEPASSWORD

Or, when there is a known password:

mysqladmin -u root -p password THEPASSWORD

Or, when using tables (first install or when password is known):

# mysql -u root -pBLABLA
mysql> use mysql
mysql> update user set password=PASSWORD("NEWBLA") where user = 'root';
mysql> flush privileges;
mysql> quit