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
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
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
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
...
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
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
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 ...