Updated : Apr 03, 2018 in Linux

Resetting MySQL/MariaDB root password in Ubuntu 16.04

Introduction: In case you have forgotten the 'root' password in MySQL/MariaDB(10.0.x) you can reset the password as follows: Ref: https://kofler.info/root-login-problem-mit-mariadb/ STEPS: Stop the currently running…

Updated : Dec 20, 2016 in Linux

Switch database type from H2 to MySQL in Atlassian Jira

Introduction: After having tested Jira and decided to keep it for production it is very recommended to change the type of database used by Jira.…

Updated : Dec 19, 2016 in Bash

Display MySQL databases types in bash

Based on the site: http://stackoverflow.com/questions/213543/how-can-i-check-mysql-engine-type-for-a-specific-table Here is a bash command that will display the databases types(innoDB or MyISAM) of all the MySQL databases except for…

Updated : Oct 30, 2016 in Linux

Resolving Mysql error: Too many open files

Introduction: As I upgraded from Mysql 5.5 to 5.6 suddenly some sites were showing the following error: ...... Too many open files The issue has…

Updated : May 30, 2016 in Linux

Resetting MariaDB root password in Ubuntu 16.04 LTS

Introduction: Becasue it's such a good article and don't want to lose it, this following article is a full copy (with maybe some minor changes)…

Updated : Jan 21, 2016 in Linux

Create a new database and use in MySQL/MariaDB

These commands will create a new database in MySQL/MariaDB including a new user/password with full access to the DB. mysql -p -u root Enter the…

Updated : Aug 27, 2015 in Linux

Resetting MySQL passwords in Linux Debian/Ubuntu

In Linux Debian/Ubuntu an extra user debian-sys-maint which also has all the access rights is used for maintenance. It can also be used to reset…

Updated : Aug 03, 2015 in Linux

PAM-Mysql user authentication in Ubuntu 14.04 LTS Server

Introduction: As I was wanting to set-up a cluster of web servers based on Apache2 and fcgi I realized that I didn't want to have…

Updated : Oct 10, 2013 in Linux

Rebuild MySQL replication slave LIVE from master

Problem: You have 2 MySQL servers in the configuration Master ==>> Slave and the slave has gone very badly out of sync with the master.…

Updated : Jan 17, 2013 in Linux

logrotate /usr/bin/mysqladmin: refresh failed; error: ‘Unknown error’

Problem: After a fresh install of Debian Squeeze and mysql server, started to appear the following error as email from cron: /etc/cron.daily/logrotate: /usr/bin/mysqladmin: refresh failed;…