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
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
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 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
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
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?
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
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
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
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