How MySQL Uses Memory This page lists some of the ways that the mysqld server uses memory, and associated mysqld variable names Memory Use MySQL 5.0 Memory Use MySQL 4.1 MySQL Optimization which covers: – Optimization Overview – Optimizing SELECT and Other Statements – Locking Issues – Optimizing Database Structure – Optimizing the MySQL Server… Continue reading MySQL Optimization / Repair Information
Category: Uncategorized
Securing MySQL.
Due to differing needs and requirements this is difficult to answer except on a case by case basis. The MySQL website has a section regarding general security of a MySQL database available here: http://dev.mysql.com/doc/refman/5.0/en/security.html Additionally some good practices are: Verify your root MySQL account password is set the test account and database that were created… Continue reading Securing MySQL.
How do I backup MySQL in Linux?
1. Copying from the mysql directory By default, MySQL databases on servers that use Linux are stored in the following directory: /var/lib/mysql/ If you shut down the mysqld service first, you can copy your databases to an example /backup directory using the following command: cp –Rp /var/lib/mysql/*.* /backup The –R switch for the cp command means recursive, which you… Continue reading How do I backup MySQL in Linux?
cPanel required ports list
Cpanel required ports list User Opinions ( ) How would you rate this answer? Helpful Not helpful Help us improve. Why was this unhelpful? Thank you for rating this answer. Port Service Protocol Direction Notes 20 ftp tcp inbound/outbound 21 ftp tcp,udp inbound/outbound 22 ssh tcp inbound 25 smtp tcp inbound/outbound 26 smtp tcp inbound/outbound… Continue reading cPanel required ports list
How do I get my mail headers?
Retrieving email headers is a very important step in reporting or troubleshooting any email issue. Here are the steps to get email headers from some of the more popular mail programs: Eudora Pro Double-click on the message to open it in a separate window. Click on the button labeled “BLAH BLAH BLAH” at the top… Continue reading How do I get my mail headers?
Installing VMWare on CentOS 5.x (64-bit)
Installing is easy.Login to the server with the root user. VMWare Install Preparation First, we need to download the VMWare installer.You can get to the download via http://vmware.com/download/server/.Once here, click on the download link, accept the EULA, and download the LinuxTarball (VMware-server-1.0.3-44356.tar.gz in my case): ·Main Download Link: http://vmware.com/download/server/ ·# wget –O vmware-server.tar.gz http://download3.vmware.com/software/vmserver/VMware-server-1.0.3-44356.tar.gz After… Continue reading Installing VMWare on CentOS 5.x (64-bit)
DoS: looking at open connections
Here is a command line to run on your server if you think your server is under attack. It prints our a list of open connections to your server and sorts them by ammount. RedHat: netstat -ntu | awk ‘{print $5}’ | cut -d: -f1 | sort | uniq -c | sort -n BSD: netstat… Continue reading DoS: looking at open connections
How to disable root login through SSH.
Before you do this make sure you have created another user in the wheel group. To disable root login through ssh, edit the following file: # /etc/ssh/sshd_config browse to the following line: PermitRootLogin yes and change to: PermitRootLogin no Save the file and restart ssh. # /etc/init.d/ssh restart If you are ssh’d into the server… Continue reading How to disable root login through SSH.
How do I permit specific users SSH access?
We will be primarily working with one configuration file in this article: OpenSSH – /etc/ssh/sshd_config OpenSSH For locking down which users may or may not access the server you will want to look into one, or more, of the following directives: User/Group Based Access AllowGroups This keyword can be followed by a list of group… Continue reading How do I permit specific users SSH access?
Chrootkit help
SSH as admin to your server. DO NOT use telnet, it should be disabled anyways. #Change to root su – #Type the following wget ftp://ftp.pangeia.com.br/pub/seg/pac/chkrootkit.tar.gz # Check the MD5 SUM of the download for security: ftp://ftp.pangeia.com.br/pub/seg/pac/chkrootkit.md5 md5sum chkrootkit.tar.gz #Unpack the tarball using the command tar xvzf chkrootkit.tar.gz #Change to the directory it created cd chkrootkit*… Continue reading Chrootkit help