MySql – Create read-only user
March 21st, 2012 by Youzhny
Most useful for second or third level support people where people have skills to check db directly but in case you do not want them to make changes, Read only user can be created for them in Mysql DB. (more…)
How-to config MySQL Master/Slave Replication
December 29th, 2011 by Youzhny
How To Set Up Database Replication In MySQL
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy...
Installing Apache2 With PHP5 And MySQL Support On Fedora 14 (LAMP)
November 28th, 2010 by jennyamy
Installing Apache2 With PHP5 And MySQL Support On Fedora 14 (LAMP)
LAMP is short for Linux, Apache, MySQL,
PHP. This tutorial shows how you can install an (more…)
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Fedora 12 x86_64)
November 16th, 2010 by jennyamy
This tutorial is Copyright (c) 2009 by Falko Timme. It is derived from a tutorial from Christoph Haas which you can find at http://workaround.org. You are free to use this tutorial under the Creative Commons license 2.5 or any later version.
This document describes how to install a mail server based on Postfix that is based on virtual users and domains, i.e. users and domains that are in a MySQL database....Full Mail Server Solution w/ Virtual Domains & Users (Debian Etch, Postfix, Mysql, Dovecot, DSpam, ClamAV, Postgrey, RBL)
November 15th, 2010 by jennyamy
I. Introduction
This guide describes how to set up a full email solution in Debian Linux (all code is from Debian Etch). I was asked to design a secure, scalable, portable solution for a small company. While the guide references many ‘servers’, the company only had 4 physical machines, Xen was used to virtualize the entire solution. That particular aspect of the system is not discussed...MySQL recover root Password
November 15th, 2010 by upa_kid
In this tutorial we will show you how to change the root password in MySQL. we will show you also how to recover your MySQL password :
1-Mysqladmin command to change root password :
To setup root password for first time, use mysqladmin command at shell prompt as follows:
$ mysqladmin -u root password NEWPASSWORD
However, if you want to change (or update) a root password, then you need to use...Intrusion Detection: Snort, Base, MySQL, and Apache2 On Ubuntu 7.10 (Gutsy Gibbon) (Updated)
November 15th, 2010 by jennyamy
This tutorial is based on another howto written by DevilMan, however I didn’t like the idea of manually compiling every package or the use of a GUI to get the software installed. This howto will work on a Gutsy Server or Gutsy desktop. With that said some of this howto is a direct copy from the original.
In this tutorial I will describe how to install and configure Snort (an intrusion detection...Enable the query cache in MySQL to improve performance
November 14th, 2010 by upa_kid
If you want to get optimized and speedy response from your MySQL server then you need to add following two configurations directive to your MySQL server:
query_cache_size=SIZE
The amount of memory (SIZE) allocated for caching query results. The default value is 0, which disables the query cache.
query_cache_type=OPTION
Set the query cache type. Possible options are as follows:
0 : Don’t cache...How Do I Enable Remote Access To MySQL Database Server?
November 14th, 2010 by upa_kid
By default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server.
MySQL Remote Access
You need type the following commands which will allow remote connections.
Step # 1: Login Using SSH (if server is outside your data center)
First, login over ssh to remote MySQL database server:
ssh...Recover MySQL root Password
November 14th, 2010 by upa_kid
You can recover MySQL database server password with following five easy steps.
Step # 1: Stop the MySQL server process.
Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.
Step # 3: Connect to mysql server as the root user.
Step # 4: Setup new mysql root account password i.e. reset mysql password.
Step # 5: Exit...Tutorial: MySQL Connection Management and caching in PHP
November 13th, 2010 by upa_kid
Jay Pipes writes about MySQL Connection Management and caching in PHP.
This small tutorial will help you understand the MySQL Connection Management and caching in PHP.
FTA, “This article is intended to highlight various basic topics concerning proper methods of handling connections to MySQL databases in PHP, guidelines for caching dynamic content, and a technique called “lazy loading”....
Web server setup, DNS and Email Hosting, Domain Registrars
November 12th, 2010 by VarIncart
I have two VPS servers, one in the USA and one in New Zealand. This post explains a little bit about my current VPS providers, web server setup, DNS and email hosting, and the domain registrars I use.
Current VPS providers
My New Zealand VPS provider is Sitehost, and my US based VPS provider is Linode. I moved to the Sitehost VPS from a dedicated server with the same company and to Linode from VPS.net.
The...