Category Archives: Mysql

How To Import a Mysql Database on the Command Line

Every so often its useful to import a .sql (exported sql file) into mysql. Make sure the database already exists. mysql -u root -p create database NAMEOFDB; exit then import you db.. mysql -uUSERNAME -pPASSWORD NAMOFDB < MYDATABASE.sql

Posted in Command Line, Mysql | Leave a comment

A Good Centos System Administration Book

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 … Continue reading

Posted in Apache, Centos 5.2, Command Line, General, General Command Line, Mysql, Networking, Open Source, RHEL5, Security, Snort, Zenoss | Tagged | 1 Comment

How To Set Root Password on Mysql on Centos

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

Posted in Centos 5.2, Mysql | Tagged , | Leave a comment

How To Monitor Mysql using Zenoss

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 … Continue reading

Posted in Mysql, Zenoss | Tagged , | Leave a comment

Install Mysql Server on Centos 5.2

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

Posted in Centos 5.2, Mysql | Tagged , | Leave a comment