Remote access to mysql database   Step 1 : vi /etc/my.cnf ——————————————— pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = mysql server ip # skip-networking ——————————————— bind-address : IP address to bind to. skip-networking : Don’t listen for TCP/IP connections [...]

Unofficial, No mess, No thrills, No fluff, No Explanation, Absolutely No Guarantee, Ruff and Gruff howto fix MySQL Databases – Make a temp directory to work in cd /root mkdir mysql_tmp cd mysql_tmp – Locate the database, ussualy a directory in /var/mysql or /var/lib/mysql ls -la /var/mysql/_database_name_ – Stop the mysql service, might be called [...]

MySQL is one of the most important programs on a server, unfortunatly it is also pretty resource intensive. One a server it is not uncommon for a single user or even a query to take up the bulk of the servers cpu cycles. Mytop is a very useful program to see what queries a server [...]

10 Test Postfix To see if Postfix is ready for SMTP-AUTH and TLS, run telnet localhost 25 After you have established the connection to your postfix mail server type ehlo localhost If you see the lines 250-STARTTLS and 250-AUTH everything is fine. Type quit to return to the system’s shell.     11 Populate The [...]

7 Install Amavisd-new, SpamAssassin And ClamAV To install amavisd-new, spamassassin and clamav, run the following command: apt-get install amavisd-new spamassassin clamav clamav-daemon zoo unzip unarj bzip2 You will be asked a few questions: Virus database update method: <– daemon Local database mirror site: <– db.de.clamav.net (Germany; select the mirror that is closest to you) HTTP [...]

This tutorial explains how you can install MySQL Proxy on a CentOS 5 (x86_64) system. MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for unlimited uses; common ones include: load balancing; failover; query analysis; query filtering and modification; [...]