By default MySQL installs a configuration file with big caches and uses up more memory than is needed on most server setups. If like me you are struggling for free ram you may wish to use MySQL’s my-small.cnf configuration file which is included in the packages documentation folder, usually found at /usr/share/doc/mysql-server-5.0/examples.
Simply backup your existing [...]
Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. Significant features are:
* Schedule full and incremental logical or raw backups of your MySQL database
* Centralized backup management
* Perform backup that is the best match for [...]
This short article explains how you can use a short script to check
whether your MySQL master master replication is working as expected or
not.
Read more at HowtoForge
MySQLTuner
is a Perl script that analyzes your MySQL performance and, based on the
statistics it gathers, gives recommendations which variables you should
adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently.
Read more at HowtoForge
How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session?
Setting up mysql password is one of the essential tasks. root user is MySQL admin account. Please note that Linux / UNIX login root account for your operating system and MySQL root are different. They [...]
Setting up a LAMP server is a common task for systems administrators, and FreeBSD is one of the most reliable and stable operating systems available. Why not combine both LAMP and FreeBSD to build a fast and reliable Web server?
Read more at Linux.com
If you forgot your mysql password and you have root access in your linux box, just follow this steps.
1. Stop MYSQL service
# /etc/init.d/mysql stop
or
# service mysqld stop
Read more at dralnux
This document describes how to install a Proftpd server that uses
virtual users from a MySQL database instead of real system users. This
is much more performant and allows to have thousands of ftp users on a
single machine. In addition to that I will show the use of quota with
this setup.
Read more at HowtoForge
This guide shows how you can write the Apache2 access log to a MySQL
database instead of a file. To achieve this, I use the Apache2 module
mod_log_sql. I’m using a Debian Etch server in this tutorial.
Read more at HowtoForge
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; and many more.
Read more at [...]
This guide explains how to set up WebDAV with MySQL authentication
(using mod_auth_mysql) on Apache2 on a Debian Etch server. WebDAV
stands for Web-based Distributed Authoring and Versioning and
is a set of extensions to the HTTP protocol that allow users to
directly edit files on the Apache server so that they do not need to be
downloaded/uploaded via FTP. [...]
This tutorial is based on Falko Timme’s tutorial for MySQL Cluster
5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x
management, 2 x storage nodes and 2 x balancer nodes. This cluster is
load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and [...]
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.
MySQL Workbench has many functions and features; this article by Djoni Darmawikarta shows some of them by way of an example. We’ll build a physical data model [...]
If you have set up MySQL replication, you probably know this
problem: sometimes there are invalid MySQL queries which cause the
replication to not work anymore. In this short guide I explain how you
can repair the replication on the MySQL slave without the need to set
it up from scratch again.
Read more at HowtoForge
Reset MySQL password in FreeBSD
by alamster in June 2nd, 2008
Database Tags: change root mysql db, login to 127.0.0.1 in mysql db, reset mysql password
Just another post for my archive
One our sandbox accidently delete root account with host ‘localhost’. We need to recover the account by grant new root account [...]