(***此篇內容已經過原作者同意發佈。)
Introduction
OS: Window 7
Server: WAMP package 2.2 x64.
(apache 2.2.21, php 5.3.10, mysql 5.5.2,
xdbug 2.1.2, xdc 1.5, phpmyadmin 3.4.10.1)
Todo list
1. updata
phpmyadmin to newest (3.4.10.2)
[ step 1 ]
(1) Download
newest phpmyadmin with
(2) Click
down link
(3) In
this teach, I will install ”phpMyAdmin-3.4.10.2-all-languages.7z”
----------------------------------------------------------------------------------------------------------------------------------
[ step 2 ]
(1) Download finish, and decompress
this package to your wamp path
(like C:\wamp\apps\)
(2) You
can rename this folder
(like phpmyadmin3.4.10.2)
----------------------------------------------------------------------------------------------------------------------------------
[ step 3 ]
(1) Edit edit.alias file
 |
Like
# your new phpmyadmin folder path
Alias /phpmyadmin "c:/wamp/apps/phpmyadmin3.4.10.2/"
# to give access to phpmyadmin from outside
# replace the lines
#
# Order Deny,Allow
# Deny
from all
# Allow
from 127.0.0.1
#
# by
#
# Order Allow,Deny
#
Allow from all
#
# your new phpmyadmin folder path
<Directory "c:/wamp/apps/phpmyadmin3.4.10.2/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny
from all
Allow
from 127.0.0.1
</Directory>
----------------------------------------------------------------------------------------------------------------------------------
[ step 4 ]
(1) Copy the “config.sample.inc.php”
and rename to “config.inc.php”.
(2) Edit config.inc.php like
(3) In “Green
Marker” is reference option, you can setting the value, which you like.
<?php
$cfg['blowfish_secret'] =
'shiou'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$i = 0;
/*
* First server
*/
$i++;
/*
Authentication type */
$cfg['Servers'][$i]['auth_type']
= 'cookie';
/*
Server parameters */
$cfg['Servers'][$i]['host']
= 'localhost';
$cfg['Servers'][$i]['connect_type']
= 'tcp';
$cfg['Servers'][$i]['user'] =
'root'; /*your
account*/
$cfg['Servers'][$i]['password']
= '1234'; /*your
password*/
$cfg['Servers'][$i]['compress']
= false;
/*
Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension']
= 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword']
= false;
$cfg['Servers'][$i]['AllowUserDropDatabase']
= true;
/*
* phpMyAdmin configuration storage settings.
*/
/* User
used to manipulate with storage */
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '1234';
/*
Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] =
'pma_bookmark';
$cfg['Servers'][$i]['relation'] =
'pma_relation';
$cfg['Servers'][$i]['table_info'] =
'pma_table_info';
$cfg['Servers'][$i]['table_coords'] =
'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] =
'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] =
'pma_column_info';
$cfg['Servers'][$i]['history'] =
'pma_history';
$cfg['Servers'][$i]['tracking'] =
'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] =
'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] =
'pma_userconfig';
/*
Contrib / Swekey authentication */
//
$cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from
server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
/**
* Defines whether a user should be displayed a
"show all (records)"
* button in browse mode or not.
* default = false
*/
//$cfg['ShowAll']
= true;
/**
* Number of rows displayed when browsing a
result set. If the result
* set contains more rows, "Previous"
and "Next".
* default = 30
*/
//$cfg['MaxRows']
= 50;
/**
* Use graphically less intense menu tabs
* default = false
*/
$cfg['LightTabs'] = true;
/**
* disallow editing of binary fields
* valid values are:
*
false allow editing
*
'blob' allow editing except for BLOB fields
*
'all' disallow editing
* default = blob
*/
$cfg['ProtectBinary'] = 'false';
/**
* Default language to use, if not
browser-defined or user-defined
* (you find all languages in the locale
folder)
* uncomment the desired line:
* default = 'en'
*/
$cfg['DefaultLang'] = 'en';
//$cfg['DefaultLang']
= 'de';
/**
* default display direction
(horizontal|vertical|horizontalflipped)
*/
//$cfg['DefaultDisplay']
= 'vertical';
/**
* How many columns should be used for table
display of a database?
* (a value larger than 1 results in some
information being hidden)
* default = 1
*/
//$cfg['PropertiesNumColumns'] = 2;
/**
* Set to true if you want DB-based query
history.If false, this utilizes
* JS-routines to display query history (lost
by window close)
*
* This requires configuration storage enabled,
see above.
* default = false
*/
//$cfg['QueryHistoryDB']
= true;
/**
* When using DB-based query history, how many
entries should be kept?
*
* default = 25
*/
$cfg['QueryHistoryMax'] = 100;
/*
* You can find more configuration options in
Documentation.html
* or here:
http://wiki.phpmyadmin.net/pma/Config
*/
?>
----------------------------------------------------------------------------------------------------------------------------------
[ step 5 ]
(1) Restart
your service
(2) Open
phpmyadmin with brower
(3) Import sql with C:\wamp\apps\phpmyadmin3.4.10.2\scripts\create_tables.sql
(4) Log out phpmyadmin
(5) Success updata
----------------------------------------------------------------------------------------------------------------------------------
Reference
author : shiou
延伸閱讀：[ 你說我打 ] [ 技術文件 ] Cake php 2.1 + window 7 install note
沒有留言:
張貼留言