Archive for 'Mysql'

How to: Setup Nagios Center : NagCen

In the world of open source, when it comes to monitoring, Nagios is the most preferred choice. But managing multiple Nagios screens can be a daunting task. while looking for a simple solution i came across NagCen.

NagiosCenter is a centralized viewer to show data of several (more than one) Nagios server spreaded in different networks. It uses therefore a parser in python and also an PHP Mysql Web-fronted.

Read the complete article »

Recover Mysql root password

Mysql

One of the very worst scenarios for a system administrator is when they forget a password for the root account. That is the same case when a Database admin does the same for the root account for Mysql Database. So to help here, these are the following steps which one can perform to recover the root password back for Mysql database.

Read the complete article »

How To: Change Mysql root Password

Mysql

Changing Mysql password is one of the very essential & critical task which you need to do while taking care of the database. By default "root" comes up with admin privileges and no password for root. Just to be clear, this root user is different from what your Linux/Unix system root user is, so changing password for this user, won't change password for root user for operating system.

Mysql stores the password in the "user" table in "mysql" database. To change/update a password, we need to update that table data. That can be done either at the OS level with "mysqladmin" command or either at the Mysql level with sql command.

Read the complete article »

O’Reilly Velocity Online Conference

Theme: Speed and Stability
The Velocity Online Conference is the meeting ground where emerging trends are examined, predictions are made, and business models vetted in the Performance and Operations ecosystem. In this two hour online conference, you’ll have the opportunity to hear from experts, share your ideas, ask questions, and join in a conversation with panelists and other participants, all …

Read the complete article »

Setup Apache, Mysql and PHP on SUN Solaris

My last post was about the installation of Apache, PHP and Mysql on linux platform but recently i was looking for some document which could explain the installation of these open source applications on the solaris machine.

I found a lots of blogs/posts for the same but most of them are outdated and not completely explained.

But this article shows …

Read the complete article »