MySQL-GUI
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
#contents
*データベースhoge上でクエリを実行する [#h45227b2]
ＤＢの操作したいテーブルを選び、「編集」をクリックして出...
update community_member
set is_receive_mail_pc=1
where community_id=5;
&ref(phpmyadmin_query.png);
*phpMyAdmin [#lfd3cd67]
http://www.nw.is.kyusan-u.ac.jp/xoops/modules/bwiki/index...
MySQLを操作するのに、デファクトスタンダード？の風味のphpM...
piano:root {107} % portinstall databases/phpmyadmin
デフォルトでは、/usr/local/www/phpMyAdmin に作成されるの...
ln -s /usr/local/www/phpMyAdmin /usr/local/www/apache22/...
してみる
**phpMyAdmin を apache から実行可能に [#zf9a91c4]
まずは認証用のファイルを作る。
% sudo mkdir /usr/local/www/htpasswds
% sudo htpasswd -c /usr/local/www/htpasswds/.htpasswd1
phpadminDocumentRoot
以下に置きたくないので別のディレクトリを作ってそこにファ...
/usr/local/etc/www/apache22/httpd.conf に以下を追加
Alias /phpmyadmin/ /usr/local/www/phpMyAdmin/
<Directory "/usr/local/www/phpMyAdmin">
Options none
SSLRequireSSL
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from .smb.net
AuthUserFile /usr/local/www/htpasswds/.htpasswd1
AuthName "Please Enter phpMyAdmin Username and Password"
AuthType Basic
Require valid-user
</Directory>
Alias 元のパス名は適当に変更したほうが良いかも。これで、h...
**落ち穂拾い [#se3e58d7]
portsで入れたんだからバッチリかと思ったけど、本家からスケ...
まぁでも、portinstallしておいた方がVersionUPやauditで便利...
&ref(error.png);
嘆いていても仕方ないので修正しる
***Warning: Cannot modify header information - headers al...
【解決策】
/usr/local/etc/php.iniにて
;output_buffering = Off
output_buffering = On
として、apachectl restart
***Cannot load or save configuration [#n93f68fd]
piano:root {123} % cd /usr/local/www/phpMyAdmin
piano:root {124} % mkdir config
piano:root {125} % chmod o+rw config
piano:root {126} % cp config.inc.php config/
piano:root {127} % chmod o+w config/config.inc.php
piano:root {128} % chown -R www:www /usr/local/www/phpMy...
***Runtime Notice in ./libraries/common.inc.php#281 [#x81...
【解決策】
/usr/local/etc/php.iniにて
;date.timezone =
date.timezone = Asia/Tokyo
として、apachectl restart
***Zipのサポート [#h9de8d68]
piano:root {137} % cd /usr/ports/lang/php5-extensions
piano:root {137} % make showconfig
XML=on "XML support"
XMLREADER=on "XMLReader support"
XMLRPC=off "XMLRPC-EPI support"
XMLWRITER=on "XMLWriter support"
XSL=off "XSL support (Implies DOM)"
YAZ=off "YAZ support (ANSI/NISO Z39.50)"
ZIP=off "ZIP support"
ZLIB=off "ZLIB support"
===> Use 'make config' to modify these settings
という事なので、vi /usr/ports/lang/php5-extensions/Maikef...
ZIP "ZIP support" on \
ZLIB "ZLIB support" on
として、
piano:root {138} % cp Makefile Makefile-Zip_ON
piano:root {139} % make deinstall
piano:root {140} % portinstall lang/php5-extensions
フルオプションで再インストールして、apachectl restart
&ref(OK.png);
*MySQL Admin [#k4383be2]
**WindowsマシンからリモートサーバのMySQLを操作 [#vf16d4a7]
http://www.mysql.com/ から mysql-gui-tools-5.0-r17-win32...
サーバpiano側で
mysql> SELECT host, user FROM mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| localhost | PNE |
| localhost | bb3 |
| localhost | pne |
| localhost | root |
| localhost | tfc |
+-----------+------+
5 rows in set (0.00 sec)
と、リモートからのアクセスを受け付ける設定がないので、
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'219.117.246....
Query OK, 0 rows affected (0.05 sec)
mysql> SELECT host, user FROM mysql.user;
+-----------------+------+
| host | user |
+-----------------+------+
| 219.117.246.xxx | root |
| localhost | PNE |
| localhost | bb3 |
| localhost | pne |
| localhost | root |
| localhost | tfc |
+-----------------+------+
6 rows in set (0.00 sec)
などとする。xxxは伏せ字。
#ref(MySQL_Admin.png)
http://honana.com/mysql/admin/mysqlguitools.html
*MySQL-gui-tools for Windows [#x13462c8]
Windows端末からリモートでMySQLを操作する
http://honana.com/mysql/admin/mysqlguitools.html
mysql-gui-tools-5.0-r14-win32.msi
% mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'210.255.XXX....
% cat /var/log/auth.log
% ps aux | grep inetd
kill -HUP 1140
*MySQL-GUI-Tools [#u8dcb9ac]
#ref(MySQL-GUI.gif)
===> mysql-client-5.0.67_1 conflicts with installed pac...
mysql-client-5.1.28_1
They install files into the same place.
Please remove them first with pkg_delete(1).
*** Error code 1 [#cd0e39f3]
Stop in /usr/ports/databases/mysql50-client.
*** Error code 1 [#s6acf2e9]
Stop in /usr/ports/databases/mysql50-client.
*** Error code 1 [#kc312967]
Stop in /usr/ports/databases/mysql-gui-tools.
*** Error code 1 [#c913e670]
Stop in /usr/ports/databases/mysql-gui-tools.
*** Error code 1 [#f085ff2e]
Stop in /usr/ports/databases/mysql-gui-tools.
===> Cleaning for mysql-client-5.0.67_1
===> Cleaning for mysql-gui-tools-5.0r12
---> Installation of databases/mysql-gui-tools ended at...
---> Saving the log as '/var/log/ports/databases::mysql...
---> Fresh installation of databases/mysql-gui-tools en...
---> ** Install tasks 1: 1 done, 0 ignored, 0 skipped a...
/usr/local/etc/pkgtools.conf:513: warning: already initi...
/usr/local/etc/pkgtools.conf:517: warning: already initi...
---> Listing the results (+:done / -:ignored / *:skippe...
+ databases/mysql-gui-tools
---> Packages processed: 1 done, 0 ignored, 0 skipped a...
---> Session ended at: Tue, 28 Oct 2008 17:06:41 +0900 ...
終了行:
#contents
*データベースhoge上でクエリを実行する [#h45227b2]
ＤＢの操作したいテーブルを選び、「編集」をクリックして出...
update community_member
set is_receive_mail_pc=1
where community_id=5;
&ref(phpmyadmin_query.png);
*phpMyAdmin [#lfd3cd67]
http://www.nw.is.kyusan-u.ac.jp/xoops/modules/bwiki/index...
MySQLを操作するのに、デファクトスタンダード？の風味のphpM...
piano:root {107} % portinstall databases/phpmyadmin
デフォルトでは、/usr/local/www/phpMyAdmin に作成されるの...
ln -s /usr/local/www/phpMyAdmin /usr/local/www/apache22/...
してみる
**phpMyAdmin を apache から実行可能に [#zf9a91c4]
まずは認証用のファイルを作る。
% sudo mkdir /usr/local/www/htpasswds
% sudo htpasswd -c /usr/local/www/htpasswds/.htpasswd1
phpadminDocumentRoot
以下に置きたくないので別のディレクトリを作ってそこにファ...
/usr/local/etc/www/apache22/httpd.conf に以下を追加
Alias /phpmyadmin/ /usr/local/www/phpMyAdmin/
<Directory "/usr/local/www/phpMyAdmin">
Options none
SSLRequireSSL
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from .smb.net
AuthUserFile /usr/local/www/htpasswds/.htpasswd1
AuthName "Please Enter phpMyAdmin Username and Password"
AuthType Basic
Require valid-user
</Directory>
Alias 元のパス名は適当に変更したほうが良いかも。これで、h...
**落ち穂拾い [#se3e58d7]
portsで入れたんだからバッチリかと思ったけど、本家からスケ...
まぁでも、portinstallしておいた方がVersionUPやauditで便利...
&ref(error.png);
嘆いていても仕方ないので修正しる
***Warning: Cannot modify header information - headers al...
【解決策】
/usr/local/etc/php.iniにて
;output_buffering = Off
output_buffering = On
として、apachectl restart
***Cannot load or save configuration [#n93f68fd]
piano:root {123} % cd /usr/local/www/phpMyAdmin
piano:root {124} % mkdir config
piano:root {125} % chmod o+rw config
piano:root {126} % cp config.inc.php config/
piano:root {127} % chmod o+w config/config.inc.php
piano:root {128} % chown -R www:www /usr/local/www/phpMy...
***Runtime Notice in ./libraries/common.inc.php#281 [#x81...
【解決策】
/usr/local/etc/php.iniにて
;date.timezone =
date.timezone = Asia/Tokyo
として、apachectl restart
***Zipのサポート [#h9de8d68]
piano:root {137} % cd /usr/ports/lang/php5-extensions
piano:root {137} % make showconfig
XML=on "XML support"
XMLREADER=on "XMLReader support"
XMLRPC=off "XMLRPC-EPI support"
XMLWRITER=on "XMLWriter support"
XSL=off "XSL support (Implies DOM)"
YAZ=off "YAZ support (ANSI/NISO Z39.50)"
ZIP=off "ZIP support"
ZLIB=off "ZLIB support"
===> Use 'make config' to modify these settings
という事なので、vi /usr/ports/lang/php5-extensions/Maikef...
ZIP "ZIP support" on \
ZLIB "ZLIB support" on
として、
piano:root {138} % cp Makefile Makefile-Zip_ON
piano:root {139} % make deinstall
piano:root {140} % portinstall lang/php5-extensions
フルオプションで再インストールして、apachectl restart
&ref(OK.png);
*MySQL Admin [#k4383be2]
**WindowsマシンからリモートサーバのMySQLを操作 [#vf16d4a7]
http://www.mysql.com/ から mysql-gui-tools-5.0-r17-win32...
サーバpiano側で
mysql> SELECT host, user FROM mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| localhost | PNE |
| localhost | bb3 |
| localhost | pne |
| localhost | root |
| localhost | tfc |
+-----------+------+
5 rows in set (0.00 sec)
と、リモートからのアクセスを受け付ける設定がないので、
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'219.117.246....
Query OK, 0 rows affected (0.05 sec)
mysql> SELECT host, user FROM mysql.user;
+-----------------+------+
| host | user |
+-----------------+------+
| 219.117.246.xxx | root |
| localhost | PNE |
| localhost | bb3 |
| localhost | pne |
| localhost | root |
| localhost | tfc |
+-----------------+------+
6 rows in set (0.00 sec)
などとする。xxxは伏せ字。
#ref(MySQL_Admin.png)
http://honana.com/mysql/admin/mysqlguitools.html
*MySQL-gui-tools for Windows [#x13462c8]
Windows端末からリモートでMySQLを操作する
http://honana.com/mysql/admin/mysqlguitools.html
mysql-gui-tools-5.0-r14-win32.msi
% mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'210.255.XXX....
% cat /var/log/auth.log
% ps aux | grep inetd
kill -HUP 1140
*MySQL-GUI-Tools [#u8dcb9ac]
#ref(MySQL-GUI.gif)
===> mysql-client-5.0.67_1 conflicts with installed pac...
mysql-client-5.1.28_1
They install files into the same place.
Please remove them first with pkg_delete(1).
*** Error code 1 [#cd0e39f3]
Stop in /usr/ports/databases/mysql50-client.
*** Error code 1 [#s6acf2e9]
Stop in /usr/ports/databases/mysql50-client.
*** Error code 1 [#kc312967]
Stop in /usr/ports/databases/mysql-gui-tools.
*** Error code 1 [#c913e670]
Stop in /usr/ports/databases/mysql-gui-tools.
*** Error code 1 [#f085ff2e]
Stop in /usr/ports/databases/mysql-gui-tools.
===> Cleaning for mysql-client-5.0.67_1
===> Cleaning for mysql-gui-tools-5.0r12
---> Installation of databases/mysql-gui-tools ended at...
---> Saving the log as '/var/log/ports/databases::mysql...
---> Fresh installation of databases/mysql-gui-tools en...
---> ** Install tasks 1: 1 done, 0 ignored, 0 skipped a...
/usr/local/etc/pkgtools.conf:513: warning: already initi...
/usr/local/etc/pkgtools.conf:517: warning: already initi...
---> Listing the results (+:done / -:ignored / *:skippe...
+ databases/mysql-gui-tools
---> Packages processed: 1 done, 0 ignored, 0 skipped a...
---> Session ended at: Tue, 28 Oct 2008 17:06:41 +0900 ...
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
