![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
root:my@mail.address
ssh-keygen -b 1024 -t dsa
portinstall mail/pflogsumm
portinstall security/clamav
portinstall japanese/mailman
portinstall www/apache22
mysqlオプションにチェックすると、 mysql-5.5.30.tar.gz が依存関係で入る
portinstall japanese/p5-Mail-SpamAssassin
http://nhh.mo-blog.jp/ttt/2010/05/freebsd_portupg.html
portinstall databases/mysql55-server
portinstall databases/phpmyadmin
portinstall japanese/trac
portinstall devel/subversion
portinstall devel/p5-SVN-Hooks
root@g7:/root # trac-admin /usr/local/www/apache22/data/trac/RS_Base_2010 upgrade root@g7:/root # root@g7:/root # trac-admin /usr/local/www/apache22/data/trac/RS_Base upgrade Database is up to date, no upgrade necessary. root@g7:/root # root@g7:/root # trac-admin /usr/local/www/apache22/data/trac/RS_Base wiki upgrade
portinstall www/trac-webadmin
2013-03-08
984 11:53 portinstall databases/mysql56-client 985 11:55 rehash 986 11:55 portinstall databases/mysql56-server
/etc/rc.conf
mysql_enable="YES" mysql_dbdir="/home/mysql"
/usr/local/etc/my.conf
[mysqld] datadir=/home/mysql
top
1399 mysql 21 52 0 536M 119M sigwai 0 0:00 0.00% mysqld
MySQL起動
root@g7:/root # /usr/local/etc/rc.d/mysql-server start
http://freebsd.server-manual.com/freebsd8_mysql5.html
root@g7:/root # mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.10-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET PASSWORD FOR root@localhost=password('********');
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT user,host FROM mysql.user;
+------+--------------------+
| user | host |
+------+--------------------+
| root | 127.0.0.1 |
| root | ::1 |
| | g7.kuji-clinic.net |
| root | g7.kuji-clinic.net |
| | localhost |
| root | localhost |
+------+--------------------+
6 rows in set (0.00 sec)
mysql> DELETE FROM mysql.user WHERE user='';
Query OK, 2 rows affected (0.00 sec)
mysql> SELECT user,host FROM mysql.user;
+------+--------------------+
| user | host |
+------+--------------------+
| root | 127.0.0.1 |
| root | ::1 |
| root | g7.kuji-clinic.net |
| root | localhost |
+------+--------------------+
4 rows in set (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> DROP DATABASE test;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
2013-03-08
http://9jp.info/archives/12024
root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 35 Server version: 5.6.10-log Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> source /usr/local/www/phpMyAdmin/examples/create_tables.sql Query OK, 1 row affected (0.00 sec) Database changed Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.02 sec) mysql> grant all privileges on phpmyadmin.* to pma@localhost identified by 'pmapass'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 #
portinstall textproc/php5-xsl
