≡ Menu

/etc/my.cnf

MySQL: Connect From an Other System / Computer

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?
[click to continue…]

MySQL: Set Cache Size

How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?
[click to continue…]

Where Are MySQL Files Stored in UNIX / Linux

Where are my mysql database and table files are stored in UNIX or Linux operating systems?
[click to continue…]

MySQL Bin Files Eating Lots of Disk Space

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?
[click to continue…]

MySQL: Change Default Port Under Linux / UNIX

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?
[click to continue…]