php.ini

php.ini的位置：

寫一個php網頁秀出php的相關設定：
<?php
phpinfo();
?>
就可以看到php.ini的位置在哪了。
unbuntu 14的位置在 /etc/php5/apache2/php.ini


上傳檔案限制：

修改php.ini裡的
upload_max_filesize = 2M
改成32M或3200M什麼的就可以了

然後要重啓apache
$ sudo /etc/init.d/apache2 restart

安裝 prestashop 1.6 時出現的問題

沒有Mcrypt外掛：

找出php.ini ，在/etc/php5/apache2 裡； 加入
extension=mcrypt.so 一行
/etc/init.d/apache2 restart
就OK了。


出現：

• Permissions on files and folders
• Recursive write permissions for www-data user on ~/config/
• Recursive write permissions for www-data user on ~/cache/
• Recursive write permissions for www-data user on ~/log/
• Recursive write permissions for www-data user on ~/img/
• Recursive write permissions for www-data user on ~/mails/
• Recursive write permissions for www-data user on ~/modules/
• Recursive write permissions for www-data user on ~/themes/default-bootstrap/lang/
• Recursive write permissions for www-data user on ~/themes/default-bootstrap/pdf/lang/
• Recursive write permissions for www-data user on ~/themes/default-bootstrap/cache/
• Recursive write permissions for www-data user on ~/translations/
• Recursive write permissions for www-data user on ~/upload/

解決方法：
cd /var/www/prestashop

chown -R www-data *

chgrp -R www-data *

MySQL指令

在網路上找MySQL指令，很多都從 show databases; 開始講。
靠我直接在終端機上面輸入 show databases; ，啊就是不行啊幹。

為什麼都沒人提醒要先登入MySQL呢？還說 show databases; 是實用指令，最實用的不是 mysql -u user -p 嗎？


mysql -u user -p  //用user帳號登入mysql

show databases;

drop database databasename;   //刪除資料庫，mysql不會問你yes/no就直接刪除，要小心使用

create user 'username'@'localhost' identified by 'password';  //引號也要打

select Host, User from mysql.user;  //顯示所有使用者，root登入才給用

create database database_name;    //建立資料庫

grant all on database_1.* to user_name@'localhost' identified by 'password';

//把database_1的資料庫授權給 user_name


匯入資料不能在mysql裡面，要跳出來到命令列（幹好奇怪，害我一直在mysql>裡面弄超久）：

$ mysql -u root -p database_name < database_file.sql

mount CD/DVD.iso

sudo mount -t iso9660 -o loop /full/path/to_your_.iso /mnt

ls /mnt

The CD/DVD won't show on the desktop.

If you want it to appear on the desktop, then 

sudo mkdir /media/fakecd

sudo mount -t iso9660 -o loop /path/to/your.iso /media/fakecd

sudo umount /media/fakecd 

from:http://ubuntuforums.org/showthread.php?t=1728520

開samba檔案共享

sudo apt-get install samba

vi /etc/samba/smb.conf

[資料夾的名稱]

path = 資料夾的路徑

writable = yes

guest account = root

force user = root

public = yes

force group = root

sudo /etc/init.d/samba restart
Debian:
sudo service smbd restart

2019/6/26 更新
上面那個太權限太危險了，訪客都可以讀寫資料夾，下面這個比較安全

[folder name]
path=/home/superppp/abc
browseable = yes
read only = no
writable = yes
valid users = bill

重啟samba之後，新增samba使用者：

sudo smbpasswd -a bill

輸入兩次密碼後，就可以安全使用了。

Installing HTTrack on a Mac (Mac OS X)

http://forum.httrack.com/readmsg/15816/15608/index.html?q=httrack+mac

To compile httrack on your Mac, you first of all need to install Apple developer Tools (X-Code). Either download it from <http://developer.apple.com/tools/download/> or perhaps the Developer Tools are on your Mac OS X install DVD. Then download the newest souce code of HTTrack from <http://debian.httrack.com/dists/unstable/main/source> (if you want the newest beta-version). Currently the archive name of the newest version is httrack_3.41.20.orig.tar.gz. Unpack it using Finder (dobble click the downloaded file). Now start the application Terminal (found in /Applications/Utilities/ or by searching for it with Spotlight). Terminal provides a command line interface. (1) Type cd <path to httrack folder> (replacing <path...> with the actual path e.g. Desktop/httrack-3.41.20). (2) Type ./configure (plus optionally --prefix=<path you where you want to install HTTrack> if you for example do not have administrator priviledges to your Mac). (3) Type make (compiles the source to executable commands) (4) Type make install (the installer puts the files where you told it to by using --prefix=... of per default in the folder /usr/local/) Now you can archive with HTTrack by typing /usr/local/bin/httrack <url to archive> -O ~/<name of local archive folder> -n -j The above options (i.e. -n -j) are just a couple of the most usefull options to use. For more options I advice you to read the HTTrack documentation. It is also often very usefull to add web adresses that the crawler should not archive and some that it should. This is done simply by adding to the URLs with a leading - or + (e.g. httrack <http://www.httrack.com/> -O ~/070208_httrack_com -n -j -http://www.httrack.com/page/* +http://www.httrack.com/page/7/*). Please report how the instructions above has helped you or how they did not. :-) Kind regards,

Mac ssh

ssh user@ip