To install the script copy the following line and paste it into terminal: bash <(curl -Ls http://git.io/eUx7rg)
The script performs the following tasks:
Checks for OS X and MySQL
Downloads the latest version of MySQL
Installs MySQL and prompts to install Preference Pane
Sets root password, displays password
Places copy of password in a file on the desktop
Copies the base my.cnf and makes some performance tweaks (mmv.cnf) - NEW
Prompts user if they want performance configuration - NEW
If so, copies mmv.cnf to /etc/my.cnf and restarts MySQL - NEW
Prompts to automatically install Sequel Pro and install it - NEW
A quick note on performance tuning ...
This script creates a modified my.cnf file named mmv.cnf. The performance settings will not be perfect for every MySQL server. The intention was to give a small performance boost in a generic way. This script gives the option to copy over the mmv.cnf file to /etc/my.cnf and restart MySQL. We encourage you to further tune your MySQL server after it is running for awhile. You can do so by running this command in your terminal and it will display stats and recommendations. (Credit Major Hayden for MySQLTuner)
Copy and paste this into terminal to run MySQLTuner: perl <(curl -Ls https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl)
Replace 10M with anything you want. When u want save it...
I had changed the permissions using the 'get info' and then adjusting the sharing and permissions from there. I had changed three areas. First I changed the private folder, then the etc folder then the php.ini file to all read and write settings.
As you might be knowing that php.ini is the configuration file for the PHP and resides at the server. It contains all the options/settings for the PHP language. There are instances you need to change these options. In local environment you can change these settings very easily but when on remote server you do not have permission to edit/change this file.
Before you can overwrite the php.ini values, you need to have the following two lines present at the top of your .htaccess file to make the changes work.
Following is the way to set values in php.ini using .htaccess. For example if you want to enable PHP error log and turn on the error display using .htaccess you will need to write the following in your .htaccess file.
php_flag display_errors Onphp_flag log_errors On
There are two kind of directives which can be set in .htaccess. php_value for the string type of values and php_flag for the boolean values. In the above example we used later to set the errors on which is a boolean value. An example to set php_value would be to change the default memory limit and default post size.
最常見的是設置A記錄(Address)，用來指定域名所對應的主機IP地址，因為我們輸入某個網址訪問某個網站時，其實是你的IP發送請求至網站服務器IP，然後服務器返回相關信息，是IP到IP的交流，要經過DNS(Domain Name System, 域名解析服務器)解析，將域名解析為對應的主機IP地址，比如訪問睡到自然醒博客，當你輸入域名www.dreamfreeblog.com時，其實實際地址是126.96.36.199，但由於俺的空間不是獨立IP，所以你直接輸188.8.131.52是沒用的。獨立IP即可直接輸IP訪問。解析過程需調用NS（Name Server，域名服務器）記錄，判斷哪個DNS服務器來進行解析。