abernal's blog

Install MySQL in Ubuntu

sudo apt-get install mysql-server

Setup root password

mysqladmin -u root password password

​Create a database

1. Login to the mysql console

$ mysql -u root -p

2. Execute the next command

mysql> CREATE DATABASE newdb CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Describe a table

mysql> DESCRIBE <table_name>

This will show the table fields and their features

Install Maven in Ubuntu

sudo apt-get install maven

Check Maven installation

mvn -version

Increase memmory allocation

1. Create a file within your home directory

$ vim .mavenrc

2. Insert the next lines

export MAVEN_DEBUG_OPTS="-Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000"

export MAVEN_OPTS="-Xms1024m -Xmx1024m -noverify -XX:MaxMetaspaceSize=760m"

​3. Add these lines into the .bashrc file

if [ -f ~/.mavenrc ]; then
    . ~/.mavenrc
fi