MySQL を導入します。
先人の導入例を参考にしております。
root@meckk:~# aptitude -y install mysql-server-5.1
The following NEW packages will be installed:
libdbd-mysql-perl{a} libdbi-perl{a} libhtml-template-perl{a} libmysqlclient16{a} libnet-daemon-perl{a}
libplrpc-perl{a} mysql-client-5.1{a} mysql-common{a} mysql-server-5.1 mysql-server-core-5.1{a}
0 packages upgraded, 10 newly installed, 0 to remove and 0 not upgraded.
Need to get 22.7 MB of archives. After unpacking 53.1 MB will be used.
Get:1 http://ftp.jp.debian.org/debian/ squeeze/main mysql-common all 5.1.49-3 [70.9 kB]
Get:2 http://ftp.jp.debian.org/debian/ squeeze/main libnet-daemon-perl all 0.43-1 [46.6 kB]
Get:3 http://ftp.jp.debian.org/debian/ squeeze/main libplrpc-perl all 0.2020-2 [36.0 kB]
Get:4 http://ftp.jp.debian.org/debian/ squeeze/main libdbi-perl armel 1.612-1 [882 kB]
Get:5 http://ftp.jp.debian.org/debian/ squeeze/main libmysqlclient16 armel 5.1.49-3 [1839 kB]
Get:6 http://ftp.jp.debian.org/debian/ squeeze/main libdbd-mysql-perl armel 4.016-1 [139 kB]
Get:7 http://ftp.jp.debian.org/debian/ squeeze/main mysql-client-5.1 armel 5.1.49-3 [9429 kB]
Get:8 http://ftp.jp.debian.org/debian/ squeeze/main mysql-server-core-5.1 armel 5.1.49-3 [3882 kB]
Get:9 http://ftp.jp.debian.org/debian/ squeeze/main mysql-server-5.1 armel 5.1.49-3 [6310 kB]
Get:10 http://ftp.jp.debian.org/debian/ squeeze/main libhtml-template-perl all 2.9-2 [65.9 kB]
Fetched 22.7 MB in 4min 8s (91.5 kB/s)
Preconfiguring packages ...
Package configuration
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu Configuring mysql-server-5.1 tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
x While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user. x
x x
x If this field is left blank, the password will not be changed. x
x x
x New password for the MySQL "root" user: x
x x
x ****____________________________________________________________________________________________________________ x
x x
x <Ok> x
x x
mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
Package configuration
lqqqqqqu Configuring mysql-server-5.1 tqqqqqqqk
x x
x x
x Repeat password for the MySQL "root" user: x
x x
x ****_______________________________________ x
x x
x <Ok> x
x x
mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
Selecting previously deselected package mysql-common.
(Reading database ... 12019 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.1.49-3_all.deb) ...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.612-1_armel.deb) ...
Selecting previously deselected package libmysqlclient16.
Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.49-3_armel.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_armel.deb) ...
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.49-3_armel.deb) ...
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.49-3_armel.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.49-3) ...
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 12397 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.49-3_armel.deb) ...
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-2_all.deb) ...
Processing triggers for man-db ...
Setting up libnet-daemon-perl (0.43-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.612-1) ...
Setting up libmysqlclient16 (5.1.49-3) ...
Setting up libdbd-mysql-perl (4.016-1) ...
Setting up mysql-client-5.1 (5.1.49-3) ...
Setting up mysql-server-core-5.1 (5.1.49-3) ...
Setting up mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
120619 20:53:28 [Note] Plugin 'FEDERATED' is disabled.
120619 20:53:28 InnoDB: Started; log sequence number 0 44233
120619 20:53:28 InnoDB: Starting shutdown...
120619 20:53:34 InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Setting up libhtml-template-perl (2.9-2) ...
root@meckk:~#
root@meckk:~# vi /etc/mysql/my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1 コメントアウト
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
root@meckk:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root@meckk:~#
root@meckk:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.1.49-3 (Debian)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select user,host,password from mysql.user;
+------------------+-----------+-------------------------------------------+
| user | host | password |
+------------------+-----------+-------------------------------------------+
| root | localhost | *6E3840AED336DFDA67F71DBFEAAE3F94A7624A28 |
| root | meckk | *6E3840AED336DFDA67F71DBFEAAE3F94A7624A28 |
| root | 127.0.0.1 | *6E3840AED336DFDA67F71DBFEAAE3F94A7624A28 |
| debian-sys-maint | localhost | *637598C037F4CF1FE1ED7C93F435F6A1B072D539 |
+------------------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql> grant all privileges on *.* to fedora@"192.168.1.%" identified by '1234';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
root@meckk:~#
| |
途中で root のパスワードを求められましたが、全く問題なくインストールできました。
その後に、Windows パソコンから ODBC での接続も可能な事を確認しました。
データベースの作成は、 create database test;
データベースの作成確認は、 show databases;
データベースへの接続は、 use test
テーブルの作成は、 create table test(num int, name varchar(50));
テーブルの作成確認は、 show tables;
テーブルの削除は、 drop table test;
データベースの削除は、 drop database test;
【Tips】
MySQL の5.3以降には、persistent と言う機能があるようです。
この persistent という項目は接続の永続化をするかどうかを決めるのですが、平たく言うと既に開いている接続があればそれを使いまわして、接続、切断するコストを抑える設定だということらしいです。
オブジェクトの永続化とは違うらしいです。