Archive

Archive for the ‘Mysql’ Category

A Good Centos System Administration Book

February 3rd, 2009 No comments

I have been a big fan of the unleashed guides every since I purchased Mac OS X Tiger Unleashed. I loved this book as it was both great for beginners but had some reallly good advanced sections that allowed me to learn some great stuff on mac os x.

So, naturally, when I was looking for a guide to Centos, I purchased another unleashed book. As you probably know, Red Hat Enterprise Linux (RHEL) and Centos are basically the same product, minus the proprietary Redhat pieces and non GPL pieces that are not legally available for free. CentOS takes the GPL portions and repackages them as CentOS. This logically led me to Red Hat Enterprise Linux 5 Administration Unleashed. I found this to be a decent book that is great starting point for using Centos, though not as advanced as I would have liked.





Anyone have any suggestions for an advanced system admin book for Centos?

How To Set Root Password on Mysql on Centos

December 20th, 2008 No comments

Various ways to set or change the root password on mysql.

Using mysqladmin application

/usr/bin/mysqladmin -u root password ‘new-password’

/usr/bin/mysqladmin -u root -h CENTOS52 password ‘new-password’

 

Using mysql on commandline

mysql -u root mysql

set password for root@localhost=PASSWORD(‘yourpassword’);

exit

Categories: Centos 5.2, Mysql Tags: ,

How To Monitor Mysql using Zenoss

December 4th, 2008 No comments

On the Zenoss server ensure your device has the Mysql zenpack

On the mysql server you plan to monitor do the following;

Add a user to Mysql so that zenoss can connect.

mysql -u root -p

grant ALL PRIVILEGES ON *.* TO ‘zenoss’@'yourzenossdomain’ IDENTIFIED BY ‘yourpassword’;

FLUSH PRIVILEGES;

Don’t forget to open port 3306 on the firewall of the Mysql server if necessary.

On the Zenoss server add the mysql user and password to zproperties of the device.

If Mysql version <5 then need to make a local copy of Mysql template on the device (go into Template section and click copy) and change the property to false for Version > 5

You can test that your monitored server can authenticate from your Zenoss server by

mysql -u zenoss -p -h yourmonitoredserverip

Categories: Mysql, Zenoss Tags: ,

Install Mysql Server on Centos 5.2

December 3rd, 2008 No comments

yum install mysql-server

service mysqld start

Set the root password

/usr/bin/mysqladmin -u root password ‘new-password’

or

/usr/bin/mysqladmin -u root -h CENTOS52 password ‘new-password’

and finally, make sure it turns on automatically after reboots.

chkconfig mysqld on

Categories: Centos 5.2, Mysql Tags: ,