/var/www/html/
是我網站的目錄位址
apache mysql php的套件我都安裝設定好了
接下來我想再加個phpmyadmin來方便我管理資料庫
因為我這是第一次在linux下裝
(windos下裝太方便了...但穩定性....)
所以我想請教一下我該把phpmyadmin放在哪裡?
thx~^^|||:)

贊助商連結

/var/www/html/...下面都可以

It is recommended that you protect the directory in which you
installed phpMyAdmin (unless it's on a closed intranet, or you
wish to use advanced authentication), for example with HTTP-AUTH
(in a .htaccess file). See the [31]FAQ section for additional
information.

What's the preferred way of making phpMyAdmin secure against evil access?


This depends on your system

If you're running a server which cannot be accessed by other people

, it's sufficient to use the directory protection bundled with your webserver (with Apache you can use .htaccess files, for example).

If other people have telnet access to your server, you should use phpMyAdmin's advanced authentication feature

Suggestions:

1.Your config.inc.php3 file should be chmod 660.
2.All your phpMyAdmin files should be chown phpmy.apache, where phpmy is a user whose password is only known to you, and apache is the group under which Apache runs.
3.You should use PHP safe mode, to protect from other users that try to include your config.inc.php3 in their scripts.

If other people have telnet access to your server, you should use phpMyAdmin's advanced authentication feature.


Using Advanced Authentication:

1.phpMyAdmin needs a stduser that has only the SELECT privilege on the mysql.db (Db,user,Select_priv) & mysql.user (user,Select_priv) tables. You must specify the details for the stduser in the config.inc.php3 file under the $cfgServers[n]['stduser'] & $cfgServers[n]['stdpass'] settings. To create the control account:


GRANT USAGE ON mysql.* TO 'stduser'@localhost IDENTIFIED BY 'password';


GRANT SELECT ON mysql.user TO 'stduser'@localhost;


GRANT SELECT ON mysql.db TO 'stduser'@localhost;


2.Then each of the true users should be granted of a set of privileges on a set of perticular databases but shouldn't have any global privileges. For example, to grant the user real_user with all privileges on the database user_base:


GRANT ALL PRIVILEGES ON user_base TO 'real_user'@localhost IDENTIFIED BY 'real_password';


What the user may now do is controlled entirely by the MySQL user management system.

最初由 jollinman 發表
/var/www/html/
是我網站的目錄位址
apache mysql php的套件我都安裝設定好了
接下來我想再加個phpmyadmin來方便我管理資料庫
因為我這是第一次在linux下裝
(windos下裝太方便了...但穩定性....)
所以我想請教一下我該把phpmyadmin放在哪裡?
thx~^^|||:)

將 phpMyAdmin-2.2.3-php.tar.gz 或 phpMyAdmin-2.2.3-php.zip 直接解壓縮
至 apache\htdocs 資料夾下，會自動產生 phpMyAdmin資料夾。

在 phpMyAdmin 資料夾內修改 config.inc.php 檔，找到下列三行：

$cfgPmaAbsoluteUri = '';
$cfgServers[1]['stduser'] = 'root';
$cfgServers[1]['stdpass'] = '';

假設 MySQL的帳號:root
MySQL的密碼:kj6688
則原設定應改成：

$cfgPmaAbsoluteUri = 'http://xxx.xxx.xxx.edu.tw/phpMyAdmin/';
$cfgServers[1]['adv_auth'] = true;
$cfgServers[1]['stduser'] = 'root'; MySQL的帳號
$cfgServers[1]['stdpass'] = 'kj6688'; MySQL的密碼

開啟瀏覽器並在網址列鍵入 http://xxx.xxx.xxx.edu.tw/phpMyAdmin/index.php即可

最初由 Yueh 發表


將 phpMyAdmin-2.2.3-php.tar.gz 或 phpMyAdmin-2.2.3-php.zip 直接解壓縮
至 apache\htdocs 資料夾下，會自動產生 phpMyAdmin資料夾。
-----恕刪-----


這...這..是Win的做法吧-_-||
設定方面就如Yueh兄所說....
/var/www/html/放在這底下任意處都可...:)

$cfgServers[1]['adv_auth'] = true;
設成true是有什摸作用嗎？
煩請高手解說一下它的原理？