MySQL :: Change user password

Posted by blackonsole on December 30th, 2012 01:22 AM | No Comment
:: How to change user password in MySQL mysql -uroot -p mysql> use mysql; mysql> set password for 'username'@'hostname' = password('new-user-password');   :: Links + Google + CyberCiti
Read More

MySQL :: dump a few tables

Posted by blackonsole on December 18th, 2012 12:56 PM | No Comment
:: How to dump a few tables in mysql mysql databasename -u -p -e 'show tables like "table_name_%"' | grep -v Tables_in | xargs mysqldump -u -p >   :: Link + Google + StactExchange
Read More

MySQL :: Cannot load from mysql.proc. The table is probably corrupted

Posted by blackonsole on December 18th, 2012 12:52 PM | 2 Comments
:: How to fix Cannot load from mysql.proc. The table is probably corrupted in mysql Try to run this command line: mysql_upgrade or mysql_upgrade -uroot -p --force   :: Link + Google + WebCheatSheet
Read More

DirectAdmin :: Enable PHP Zend Module

Posted by blackonsole on December 7th, 2012 01:03 PM | No Comment
:: How to enable PHP Zend Module on DirectAdmin cd /usr/local/directadmin/custombuild vi options.conf # change on this line: zend=yes ./build zend + checking $ php -v PHP 5.3.19 (cli) (built: Dec 6 2012 16:00:25) Copyright (c) 1997-2012 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies ...
Read More

cPanel :: MySQL server is currently offline

Posted by blackonsole on November 22nd, 2012 03:40 AM | No Comment
:: How to fix if you got "MySQL server is currently offline" in cPanel just change mysql root password via WHM: WHM - SQL Services - MySQL Root Password - Change the password   :: Links + Google + HostOutCast
Read More

Linux :: fsck lvm partition

Posted by blackonsole on November 20th, 2012 12:27 PM | No Comment
:: how to fsck lvm partition using live cd / cd rescue boot the linux livecd / cd rescue and do these: vgchange --ignorelockingfailure -ay lvscan --ignorelockingfailure fsck -y /dev/VolumeGroup/LVname   :: Link + Google + AZhowto
Read More

WHM / cPanel :: installing red5 server

Posted by blackonsole on November 20th, 2012 05:57 AM | No Comment
:: How to install red5 in cPanel Server + Setup apache ant wget //mirror.cc.columbia.edu/pub/software/apache//ant/binaries/apache-ant-1.8.4-bin.tar.gz tar -xzf apache-ant-1.8.4-bin.tar.gz mv apache-ant-1.8.4 /usr/local/ant + export ant variable temporary export ANT_HOME=/us/local/ant export PATH=$PATH:/usr/local/ant/bin permanent echo 'export ANT_HOME=/usr/local/ant' >> /etc/bashrc echo 'export PATH=$PATH:/usr/local/ant/bin' >> /etc/bashrc + installing java yum install java-1.6.0-openjdk java-1.6.0-openjdk-devel + compiling red5 wget //www.red5.org/downloads/red5/1_0/red5-1.0.0-RC2.tar.gz tar -xzf red5-1.0.0-RC2.tar.gz mv ...
Read More
Older Entries «