Enable MySQL query logging in Ubuntu

In this post, I explain about how to enable MySQL query logging for all queries. To enable query logging, historically you needed to edit my.cnf file under /etc/mysql path. However, the path and the file name is not valid anymore. In the newer versions, you need to edit mysqld.cnf that … Continue Reading →

How to resolve error 1175 in MySQL Workbench

MySQL Workbench is a useful visualization tool for database architects, which provides similar features to PostgreSQL pgAdmin. Even though, that I am not a big fan of MySQL (I am a Postgres zombie 😉 ) , I cannot escape from it since it is widely used anywhere in any project. … Continue Reading →

Concat two strings in postgreSQL and MySQL

Recently, I have faced with the situation that I had to update one column value with the combination of two strings (one is another column string and the other one is a single word) for entire table. One way is to update each row manually but what if there are … Continue Reading →

Installing LAMP

LAMP stands for Linux, Apache, MySql, and PHP. Installing mentioned packages in Linux is not difficult task as some users think that it is complex and procedure involves in manipulating many text file which is haunting and exhaustive. In fact installing LAMP if is not simpler than Xampp or Wamp … Continue Reading →

Some Basic SQL Queries

Today I was looking for a specific paper out of the huge bulk of my notes and I have found notes about SQL paper which I wrote them when I was in level one. Therefore, I organized the notes and prepare a short review of basic SQL queries here. I … Continue Reading →

MySQL basic commands

MySQL database is tightly coupled with Linux and in many extends it cannot be separated from Linux in my point of view. In this post I want to describe about some basic commands of MySQL. Note that MySQL also has GUI in Linux but I prefer to work in command … Continue Reading →