How to reset MySQL root password

Once in a while it happens that I forget the root password of a MySQL server. Several methods are explained in details on the MySQL website.

Until now I’ve always used the –skip-grant-tables method, and I was surprised to see a new method using the –init-file option. I tried it, but it didn’t work for . . . → Read More: How to reset MySQL root password

Using a file to add additional swap space

If you need to add an additional swap space, but you don’t have an available partition for it, or you want the flexibility of changing the size later, you can use a file for your swap. Here is how to do it.

The first step, is to create the files to be of the size . . . → Read More: Using a file to add additional swap space

Setting the hostname in Ubuntu Linux

The command called hostname, allows to show and set the host name. The thing is, that setting the host name in this way is not persistent, and a reboot will revert to the original host name. . . . → Read More: Setting the hostname in Ubuntu Linux

Mounting disks by label and fstab format

Mounting disks by label instead of by device, can be a good idea, because it helps to decouple from the device where your disk get attached. This is especially important for USB drives, that could get attached to different locations, or in virtual environments.

Labels are given to partitions, not to disks, but In my . . . → Read More: Mounting disks by label and fstab format

Mounting a remote filesystem with sshfs

sshfs allows to mount a remote filesystem over the internet easily, provided that you’ve ssh access to it. Here I will go through all the steps necessary to mount a remote filesystem with Ubuntu Linux.

1. installing the software

To check whether sshfs is already installed, just type sshfs on the command line, if you . . . → Read More: Mounting a remote filesystem with sshfs

Ubuntu: adduser or useradd?

Every other month or so, I’ve to add an user to one of my servers. In Ubuntu Linux adduser and useradd are two actual commands to add an user, and they do it a little differently. . . . → Read More: Ubuntu: adduser or useradd?

Installing IE7 and IE8 in Linux with Wine

Normally I would run IE inside a Virtual Machine. I need IE to test my web applications with it. However I wanted to try to run IE7 and IE8 inside Wine (I tried with version 1.3.28). After installing wine and winetricks, from the command line:

export WINEPREFIX=~/.wine_ie7 winetricks ie7 export WINEPREFIX=~/.wine_ie8 winetricks ie8

I’ve then . . . → Read More: Installing IE7 and IE8 in Linux with Wine

Hibernate and MySQL

Since I’ve already wrote about PostgreSQL and H2 Hibernate configuration, I thought it’s a good idea to add MySQL too for my reference.

First I’ve added the dependency to Maven’s pom.xml (see the Maven repository for the latest version).

<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.18</version> </dependency>

The second step is Hibernate configuration, here is an example:

. . . → Read More: Hibernate and MySQL

Hibernate and H2

H2 is a small embeddable Java Database that supports a in memory mode (it also has a server mode). It’s a great choice for testing, since it doesn’t require any DB set up.

To try it out, the first step is adding the dependency to Maven’s pom.xml (see the Maven Repository for the latest version).

. . . → Read More: Hibernate and H2

Hibernate and PostgreSQL

I’m finally fluent in Spring and Spring-MVC and I am studying Hibernate. If I think about DBMS that I’ve been using, I can recall SQL Server, Oracle and a lot of MySQL. As for PostgreSQL, I kept on hearing good news about how robust and standard based it is, but I’ve never had a chance . . . → Read More: Hibernate and PostgreSQL