/etc/my.cnf HowTo - Linux / Unix Q & A from nixCraft

Fix Host ‘IP’ is blocked because of many connection errors on MySQL/MariaDB

November 15, 2017November 15, 2017in CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, Suse, Troubleshooting, UNIX last updated November 15, 2017

I am trying to login to my mysql/mysqld server using the following Unix command:
$ mysql -u foo -h 172.16.5.100 -p dbnmame
But greeted with the following error on screen:
ERROR 1129 (HY000): Host ‘172.16.5.100’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
How do I fix this problem on a Linux or Unix-like system?

How to set and enable MariaDB slow query log

March 29, 2017March 29, 2017in BASH Shell, CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, RedHat and Friends, Suse, UNIX last updated March 29, 2017

I setup MariaDB server on Linux. How do I enable slow query log in MariaDB server on Linux or Unix-like system?

MySQL: Connect From an Other System / Computer

April 18, 2011in MySQL, RedHat and Friends last updated April 18, 2011

How do I connect to my MySQL database server from an other server (say Apache or Tomcat app server) in same VLAN under CentOS / Fedora / RHEL / Redhat Linux?

MySQL: Set Cache Size

April 16, 2009April 16, 2010in MySQL last updated April 16, 2010

How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?

Where Are MySQL Files Stored in a UNIX / Linux Harddisk

February 25, 2009August 8, 2017in CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, RedHat and Friends, Suse, UNIX last updated August 8, 2017

I am a new MySQL user on Unix-like systen. Where are my mysql/mariadb database and table files are stored in a UNIX or Linux operating systems? Where does MySQL stored the data in my harddisk? How do I find out the location?

MySQL Bin Files Eating Lots of Disk Space

December 16, 2008December 18, 2008in CentOS, Debian / Ubuntu, File system, Linux, MySQL, Storage, Ubuntu Linux, UNIX last updated December 18, 2008

Q. I get a large amount of bin files in the MySQL data directory called “server-bin.n” or mysql-bin.00000n, where n is a number that increments. What is MySQL Binary Log? How do I stop these files being created?

MySQL: Change Default Port Under Linux / UNIX

August 26, 2008in CentOS, Debian / Ubuntu, Linux, MySQL, Networking, RedHat and Friends, Solaris-Unix, Suse, Ubuntu Linux, UNIX last updated August 26, 2008

Q.I’m using MySQL 5 under Red Hat Enterprise Linux 5. How do I change default mysql server port (tcp port 3306) under Linux or UNIX operating systems?