-
Follow Us
-
Translator
Twitter Updates
- Auto Draft - http://bit.ly/c12ibN 2010-07-21
- Auto Draft - http://bit.ly/detQ6n 2010-07-21
- Auto Draft - http://bit.ly/anJMKX 2010-07-20
- More updates...
-
Recent Posts
Tags
Advertising Amazon EC2 Centos centos5.2 Clocking IT Cluemapper commandline Command Line EC2 Elgg elgg centos5.2 General git GoogleReader Hyperic laconica ldap Mobile Mongrel Monitoring Mysql Network openoffice Open Source php Project Management Redmine remote admin RSS Ruby Ruby on Rails Security Snort SSH subversion taskfreak terminal Twitter Ubuntu8.10 ubuntu8.10 Firewall virtualmin centos5.2 Vista Wordpress Xenserver Zenoss
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 Centos
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
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
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