mysql

Reset MySQL Root Password

Submitted by admin on

Blog tags: 

First of all you will need to ensure that your database is stopped:

/etc/init.d/mysql stop

Now you should start up the databa using the mysqld_safe command:

  1. /usr/bin/mysqld_safe --skip-grant-tables &
  2. [1] 6702
  3. Starting mysqld daemon with databases from /var/lib/mysql
  4. mysqld_safe[6763]: started

Now that the server is running with the --skip-grant-tables flag you can connect to it without a password and complete the job:

  1. mysql --user=root mysql
  2. Enter password:

CentOS 5.1 MySQL Master- Master Replication

Submitted by admin on

Blog tags: 

Introduction

In a database driven enviroment, it is important to ensure that the database has a zero downtime. Typically, end-users rate their service providers on uptime and disaster rsponse. In this howto, you will configure a MySQL Master and Master enviroment which allows database information to be replicated to more than one source.

The Servers:

  • Server1(Adama) 192.168.0.100
  • Server2(Starbuck) 192.168.0.103

Basic Preparation:

Subscribe to RSS - mysql