跳到主要內容

Installing phpMyAdmin on Mac OSX 10.9 Mavericks 10.8, 10.7, 10.6




from:http://coolestguidesontheplanet.com/installing-phpmyadmin-on-mac-osx-10-7-lion/

To interact with MySQL by instead of using the  command line, phpMyAdmin comes to the rescue, to get it running as part of your local development set up on OS X, a couple of steps need to be done. phpMyAdmin is a browser application that interacts with the underlying mysql data.
These steps will work on Mac OS X 10.9 Mavericks, OSX 10.8  Mountain Lion, 10.7 and 10.6 Snow Leopard.

Preparing for phpMyAdmin

Download the latest version now at version 4.something phpMyAdmin, the english.zip should be sufficient, after the file is downloaded unzip it and move it to your personal web sharing folder, this will either be “/Users/username/Sites” directory or other web root folder such as “/Library/WebServer/Documents/“.
Rename the folder from “phpMyAdmin-4.0.0-english” to “phpmyadmin“.
The rest of the tutorial assumes that you have already mysql set up with a mysql root user and password enabled if not then please follow that process first.
The login address for phpMyAdmin is going to be http://localhost/~username/phpmyadmin/or http://localhost/phpmyadmin/ depending on your web root directory, but  before this will work correctly a few steps need to be done namely addressing the MySQL socket error and configuration file set up:
a) Launch /Applications/Utilities/Terminal to fix the mysql 2002 socket error by entering the following commands:
sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
Basically this is making an alias to where phpmyadmin thinks the mysql.sock is and where it actually is.
b) In the phpmyadmin folder in your web root make a new directory named “config”.
 mkdir ~/Sites/phpmyadmin/config
c) Give Others “write“permissions to the “/phpmyadmin/config” folder either through Get Info or a ‘chmod o+w‘ in Terminal.
 chmod o+w ~/Sites/phpmyadmin/config

Installing phpMyAdmin

Older Safari browser currently has issues with the installation, blank screens?? Upgrade to Safari 6 or use either Chrome or Firefox.
Now we are ready to run the set up in the browser by going to:
http://localhost/~username/phpmyadmin/setup/
or
http://localhost/phpmyadmin/setup/
phpmyadmin-set-new-server
The new server to be configured is the localhost, click new server and then the only other configurations are the local mysql root user and the password in the Authentication tab.

phpmyadmin-set-new-server-mysql-password
Add in the username, by default “root” is assumed, add in the mysql root password (this is the password for mysql not for the OSX admin account) , click on save and you are returned to the previous screen.


phpmyadmin-save-config
Make sure you click on save, then a config.inc.php is now in the /config directory, move this fileto the root level of /phpmyadmin and then remove the now empty /config directory.

Now going to http://localhost/~username/phpmyadmin/ or  http://localhost/phpmyadmin/will now allow you to interact with your MySQL databases.
phpmyadmin-4-no-frames
Mcrypt missing extension – If your applications don’t require the mcrypt  extension there is no need to worry about it missing as reported in phpMyAdmin, if you do need to install it follow the guide here on mcrypt extension in Mavericks.
Upgrading phpMyAdmin is an easy task just grab the latest version from the phpmyadmin website and replace your older phpMyAdmin directory in your web shared folder apart from the “config.inc.php” file – make sure the config.inc.php is kept and put it back in the new directory.

這個網誌中的熱門文章

正確設置404頁面及其他.505,500....

正確設置404頁面 404頁面的設置是否正確直接關係到網站粘性,而現在很多網站的錯誤頁面返回碼都是200和302,只要蜘蛛爬行錯誤頁面不是404,那麼你的404頁 面設置就是錯誤的了,這裡跟大家介紹如何正確設置404頁面。 怎麼正確設置404頁面?很多人看到這個話題可能覺得下文不屑一顧,其實你是否知道自己的404頁面有沒有設置正確呢?很多開源的cms系統和博客 系統都會帶有404頁面,你是不是覺得這樣已經ok了?不用設置了?這些想法是錯誤的,我們做優化的時候,應該測試404頁面時候生效,設置是否正 確等。下面我們詳細說明怎麼設置404頁面。 這先說一下怎麼樣的404頁面才是有效的404頁面。大家應該都知道搜索引擎是通過http狀態碼來識別網頁狀態的,那麼當蜘蛛檢索到一個錯誤鏈 接時,就需要返回404狀態碼來告訴搜索引擎,這個頁面是錯誤頁面,以後不用索取了。而如果返回200,則告訴搜索引擎這個頁面是正常頁面。 所以我們要查看網站錯誤頁面的返回碼是200還是404,而現在很多網站的404頁面返回碼是200而不是404.    那怎麼正確設置404頁面?

Mac mini server(2012 年末和 2011 年中):如何將 OS X Server 安裝到軟體 RAID

重要事項 這些步驟會清除 Mac mini Server 中兩個磁碟機上的所有資料。雖然您可以重新安裝 OS X Server,但是請務必確認這些磁碟機上的任何其他資料都已完成備份,然後再繼續。 您無法在 RAID 卷宗上建立恢復分割區。如果沒有恢復分割區, 將無法支援 OS X 的某些功能 ,因此您應該考慮使用 恢復磁碟輔助程式 建立外接恢復磁碟,然後才建立 RAID 卷宗。 本文所提供的步驟需要使用透過 WiFi 或乙太網路的寬頻 Internet 連線。您的網路連線必須符合 這篇連結文章 的「重新安裝 OS X 的需求」一節中,針對 Internet 回復功能所述的需求。 安裝步驟 按住 Command、Option 和 R 鍵的同時啟動 Mac mini Server,以便啟動進入 Internet 回復模式。這可能要花數分鐘的時間。看到旋轉地球和“正在從網路啟動回復程序”訊息時,放開這些按鍵。

Mac OS X Server 架設兩個網站、兩個郵件伺服器

from:http://www.bnw.com.tw/conference/viewtopic.php?t=208 我的需求要更簡單。  朋友的工作室就兩三人而已,另外一個工作室也是兩三人。  希望有屬於自己的網站及網域名稱郵件  www.123.com   abc@123.com