2012年6月20日 星期三

4. Install the phpMyadmin 3.x

Install the phpMyadmin 3.x

=====================================================================

(v3.5.1 tested)

STEP1: Apache, PHP and MySQL must be installed first...

STEP2: download and unzip the phpMyAdmin-3.x-all-languages.zip to

       your  Apache web doc folder like [Apache-folder]\htdocs

STEP3: copy config.sample.inc.php and rename it to config.inc.php

STEP4: edit config.inc.php to use http authentication

       $cfg['Servers'][$i]['auth_type'] = 'http';

STEP5: open url http://127.0.0.1/[phpMyAdmin-folder]/index.php

       enter user name 'root' and password set in MySQL




FAQ

=====================================================================

After open url http://127.0.0.1/[phpMyAdmin-folder]/index.php

Q1: met "#1045 - Access denied for user 'root'@'localhost'

   (using password: NO)"

A: make sure the auth configure was set correctly

   default in libraries/config.default.php was set as 'config'

   it means you need to specify the user/password in config

   rename the config.sample.inc.php to config.inc.php

   And check your config.inc.php file to see what type of

   authentication is used.

   look for $cfg['Servers'][$i]['auth_type'] you have three to choose

   from, HTTP, cookie or config.

   Because if you use HTTP or cookie authentication you don't need to

   put your user/password in the config.inc.php file. you enter it

   when you start up phpMyadmin.

   If you use the config method you only need to enter your user/pass

   into the following two fields

    $cfg['Servers'][$i]['user']= '';

    $cfg['Servers'][$i]['password'] = '';

---------------------------------------------------------------------

Q2: met "Wrong permissions on configuration file, should not be world

   writable!"

A: make sure the config.inc.php must not be writable

   use:

    chmod a-w config.inc.php

沒有留言:

張貼留言