RESET NTFS FILE PERMITION
First, open command prompt with administrator permition
Then use this command
icacls * /t /grant Everyone:F
icacls * /t /grant Everyone:F
Code: Status Cancel_Date
-----------------------------------
AAA X 2012-02-01
AAA
BBB X 2012-02-01
AAA D 2012-01-01
AAA
BBB
BBB D 2012-02-01
BBB X 2012-01-01
Code: TotalNotXorD TotalXorD
------------------------------------
AAA 2 1
BBB 1 2
in SQL SERVERSELECT Code,
SUM(CASE WHEN status NOT IN ('X','D') OR status IS NULL THEN 1 ELSE 0 END) TotalNotXorD,
SUM(CASE WHEN status IN ('X','D') AND cancel_date >= '2012-02-01' THEN 1 ELSE 0 END) TotalXorD
FROM tableName
GROUP BY Code
in MS ACCESS SELECT
Sum(IIf(status<>'X' and status<>'D',1,0)) AS TotalNotXorD,
Sum(IIf(status='X' and status='D',1,0)) AS TotalXorD
FROM tableName
GROUP BY Code
zip -r filename.zip files
tar -czvf archive.tar.gz /path/to/directory-or-file or tar -czvf archive.tar.gz /home/ubuntu/Downloads /usr/local/stuff /home/ubuntu/Documents/notes.txt
tar -xzvf archive.tar.gz
find -name *tgzservice httpd stop yum remove php php-*
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm ls -1 /etc/yum.repos.d/epel* /etc/yum.repos.d/webtatic.repo/etc/yum.repos.d/epel.repo /etc/yum.repos.d/epel-testing.repo /etc/yum.repos.d/webtatic.repovi /etc/yum.repos.d/webtatic.repo[webtatic] name=Webtatic Repository $releasever - $basearch #baseurl=http://repo.webtatic.com/yum/centos/5/$basearch/ mirrorlist=http://repo.webtatic.com/yum/centos/5/$basearch/mirrorlist enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-webtatic-andy
yum install httpd service httpd restart
yum install php php-mysql service httpd restart
untuk mencoba silahkan ketikkan
echo "<?php phpinfo();?>" >> /var/www/html/info.php
untuk mencari modul gunakan perintah
yum search php-
yum install mysql-server service mysqld start /usr/bin/mysql_secure_installation
chkconfig httpd on chkconfig mysqld on
yum update yum install php-pear php-devel gcc make pecl install json echo "extension=json.so" >> /etc/php.d/json.ini echo "extension=php_curl.dll" >> /etc/php.ini echo "extension=ffmpeg.so" >> /etc/php.ini echo "extension=json.so" >> /etc/php.ini service httpd restart
CentOS/RHEL 6, 32 Bit (i386):rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpmCentOS/RHEL 6, 64 Bit x86_64):rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpmCentOS/RHEL 5, 32 Bit (i386):CentOS/RHEL 5, 64 Bit (x86_64):rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpmrpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpmstep 2yum install phpMyAdminTroubleshooting : » #2002 – Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) The server is not responding (or the local server’s socket is not correctly configured). ( This means your mysql server service is stopped , you must start the service “service mysql start”) » You don’t have permission to access /phpMyAdmin/ on this server. Open /etc/httpd/conf.d/phpMyAdmin.conf file and find the lines “Deny from All ” and comment those lines and restart httpd service
Reset root password/etc/init.d/mysqld stop mysqld_safe --skip-grant-tables & mysql -u root use mysql; update user set password=PASSWORD("mynewpassword") where User='root'; flush privileges; quit /etc/init.d/mysqld startmencoba hasil reset
mysql -u root -p mysql; select host,user from user; quit /etc/init.d/mysqld startchkconfigsudo /sbin/chkconfig httpd on sudo /sbin/chkconfig --list httpdhttpd 0:off 1:off 2:on 3:on 4:on 5:on 6:offsource : http://www.rackspace.com/knowledge_center/article/centos-apache-and-php-installFIREWALLsudo iptables -I INPUT -p tcp --dport 80 -j ACCEPT sudo service iptables savecheck firewall status sudo netstat -plunt
vi /etc/ssh/sshd_config /etc/init.d/ssh restartUPDATE
apt-get update
apt-get install apache2
apt-get install apache2 php5 libapache2-mod-php5 php-pear 'php5-suhosin
service apache2 restart
rm -fr /var/www/index.html
echo "<?php phpinfo();?>" >> /var/www/index.php
apt-get install mysql-server mysql-client php5-mysql
mysql_secure_installation
service apache2 restart
RESET ROOT PASSWORD
apt-get install phpmyadmin
/etc/init.d/apache2 restart
vi /etc/mysql/my.cnfbind-address = 127.0.0.1diganti menjadibind-address = 0.0.0.0
service mysql restartVSFTPDapt-get install vsftpduseradd bowongs0 passwd bowongs0 vi /etc/passwddont forget to remove samba apt-get remove samba
wget -N http://files.webuzo.com/install.sh
chmod 0755 install.sh
./install.sh // This will install the LAMP Stack, DNS Server and FTP server along with Webuzo
./install.sh --install=lamp,bind // This will install the LAMP Stack(softname -> lamp) and DNS Server
(softname -> bind) along with Webuzo.
Note : softname for Apps should be comma separated.
Get list of softnames for the Apps here : http://api.webuzo.com/apps.php
./install.sh --install=none // This will install only Webuzo without any LAMP Stack.
You can later install apps from the Apps Category in the Enduser Panel.
src http://www.webuzo.com/wiki/Install mysql root pasword are saved in /var/webuzo/my.confif WEBUZO STOP AFTER RESTART you can try this step
service webuzo restartor in centos, execute this command
setenforce 0 >> /dev/null 2>&1
iptables -F >> /dev/null 2>&1
iptables -P INPUT ACCEPT >> /dev/null 2>&1
Tambahan Catatan Untuk mysqlSolution 1: Remove ONLY_FULL_GROUP_BY from mysql console
mysql -u pastuoke -p
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
you can read more here
Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin