Setup Percona on Debian 7 Rumi, November 23, 2017 MySQL multi-master replication is an excellent feature within MySQL. However, there is only one problem; standard multi-master replication seems to never be as stable as something like master-slave replication. It is always in need of attention. That is where Percona comes into play. The Percona team has developed an amazing… Continue Reading
Moving MySQL/Windows to same version of MySQL/Linux Rumi, August 5, 2017 Moving MySQL/Windows to same version of MySQL/Linux. You can mysqldump all the databases as follows: C:\> mysqldump -uroot -p –routines –triggers –flush-privileges –all-databases > MySQLData.sql Move MySQLData.sql to Linux box and run the reload mysql -uroot -p < MySQLData.sql Continue Reading
Upgrade mysql 5.5 to 5.6 in Ubuntu 14 Rumi, June 2, 2017 While I was installing idoit- the cmdb and IT documenting platform, struggling with a pre-requisite of having mysql version 5.6 which is not shipped by native in ubuntu 14 installations. So had to google it and found some solution, however the one that worked for me which I’m sharing below:… Continue Reading
Increase MySQL connections max_connections Rumi, January 19, 2017 If you need to increase MySQL Connections without MySQL restart do like below mysql> show variables like ‘max_connections’; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | max_connections | 100 | +—————–+——-+ 1 row in set (0.00 sec) mysql> SET GLOBAL max_connections = 150; Query OK, 0 rows affected (0.00 sec)… Continue Reading
Fixing error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ Rumi, January 17, 2017 For all you Ubuntu/MySQL developers out there, have you ever seen the following? neo@thematrix:~$ sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [fail] * Starting MySQL database server mysqld [ OK ] /usr/bin/mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ So,… Continue Reading
Reset a MySQL root password for Debian Rumi, July 14, 2016 Use the following steps to reset a MySQL root password by using the command line interface. Stop the MySQL service (Ubuntu and Debian) Run the following command: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: sudo /etc/init.d/mysqld stop Start MySQL without a password Run… Continue Reading
Reinstalling MySQL on CentOS/Redhat 6 Rumi, February 7, 2016 Some time we faces issues with MySQL installation on Linux machine. If we simply remove MySQL packages and re-install doesn’t fixes the issue, in that case old settings may still exists on server which again affects new install. In that case first uninstall MySQL completely from system and erase all… Continue Reading
Importing Big mysqldump with Progress Bar PV Rumi, June 6, 2014 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV… Continue Reading
How to reset MySQL Root Password in Linux Rumi, June 6, 2014 First, Let’s stop the mysql service, In Red Hat’s family (Red Hat Enterprise, Fedora, CentOS) the Mysql Daemon is called ‘mysqld‘, but in Debianlike Ubuntu based distributions and OpenSuse its called ‘mysql‘. I’ll be using the debian based naming sudo service mysql stop OR sudo /etc/init.d/mysql stop Now, we’ll… Continue Reading
Importing Big mysqldump with Progress Bar PV Rumi, December 12, 2013 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV using-… Continue Reading