[root@localhost docker]#
[root@localhost docker]# uname -a
Linux localhost.localdomain 3.10.0-514.el7.x86_64 #1 SMP Wed
Oct 19 11:24:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost docker]#
[root@localhost docker]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.3 (Maipo)
[root@localhost docker]#
zabbix-mysql 容器:
---------------------------------------
docker run --name mysql-server -t \
-e
MYSQL_DATABASE="zabbix" \
-e
MYSQL_USER="zabbix" \
-e
MYSQL_PASSWORD="ywwd.net" \
-e
MYSQL_ROOT_PASSWORD="ywwd.net" \
-v
/data/container/mysql/zabbix:/var/lib/mysql \
-v
/etc/localtime:/etc/localtime:ro \
--restart=always \
-d
mysql:5.7 \
--character-set-server=utf8 --collation-server=utf8_general_ci
--sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]# docker run --name mysql-server -t
\
> -e MYSQL_DATABASE="zabbix" \
> -e MYSQL_USER="zabbix" \
> -e MYSQL_PASSWORD="ywwd.net" \
> -e MYSQL_ROOT_PASSWORD="ywwd.net" \
> -v /data/container/mysql/zabbix:/var/lib/mysql \
> -v /etc/localtime:/etc/localtime:ro \
> --restart=always \
> -d mysql:5.7 \
> --character-set-server=utf8 --collation-server=utf8_general_ci
--sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Unable to find image 'mysql:5.7' locally
5.7: Pulling from library/mysql
Digest:
sha256:2f4b1900c0ee53f344564db8d85733bd8d70b0a78cd00e6d92dc107224fc84a5
Status: Downloaded newer image for mysql:5.7
5dc91cba6dac1b33b1298d270d873646e1887e1fabe0bb57cee7699e1beda828
[root@localhost docker]# docker images
REPOSITORY TAG
IMAGE ID CREATED SIZE
ubuntu latest ebcd9d4fca80 11 days ago
118MB
mysql 5.7 e799c7f9ae9c 2 weeks ago 407MB
mysql latest e799c7f9ae9c
2 weeks ago 407MB
[root@localhost docker]# docker ps
CONTAINER ID IMAGE COMMAND
CREATED
STATUS
PORTS NAMES
5dc91cba6dac mysql:5.7 "docker-entrypoint..." 34
seconds ago Up 33 seconds 3306/tcp mysql-server
[root@localhost docker]#
[root@localhost docker]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/rhel-root 9754624 1957200
7797424 21% /
devtmpfs 1929936
0
1929936 0% /dev
tmpfs 1940860
0
1940860 0% /dev/shm
tmpfs 1940860
8752 1932108 1% /run
tmpfs 1940860
0
1940860 0%
/sys/fs/cgroup
/dev/sda1 484004
132984 351020 28% /boot
/dev/mapper/rhel-app 2086912 32944
2053968 2% /app
tmpfs 388176 0 388176
0% /run/user/0
/dev/sr0 3704296
3704296 0 100% /mnt/cdrom
overlay 9754624
1957200 7797424 21%
/var/lib/docker/overlay/26ad0f32be23508e52b647d575643e2f2245d3ff6ca50afb49eb22bb5dd3d7b3/merged
shm 65536 0 65536 0%
/var/lib/docker/containers/5dc91cba6dac1b33b1298d270d873646e1887e1fabe0bb57cee7699e1beda828/shm
[root@localhost docker]#
[root@localhost docker]# docker images
REPOSITORY TAG
IMAGE ID CREATED SIZE
zabbix/zabbix-web-nginx-mysql latest
bd6c53828812 18 hours
ago 175MB
zabbix/zabbix-server-mysql latest c07e103ee5c1 18 hours
ago 104MB
ubuntu latest ebcd9d4fca80 11 days ago
118MB
mysql 5.7 e799c7f9ae9c 2 weeks ago 407MB
mysql latest e799c7f9ae9c
2 weeks ago 407MB
[root@localhost docker]#
[root@localhost docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." 17
seconds ago Up 16 seconds 0.0.0.0:80->80/tcp,
443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." 8 minutes ago Up 8 minutes
162/udp, 0.0.0.0:10051->10051/tcp
zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
20 minutes ago Up 20 minutes
3306/tcp
mysql-server
[root@localhost docker]#
[root@localhost ~]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/rhel-root 9754624 2296292
7458332 24% /
devtmpfs 1929936
0
1929936 0% /dev
tmpfs 1940860
0
1940860 0% /dev/shm
tmpfs 1940860
8908 1931952 1% /run
tmpfs 1940860
0
1940860 0%
/sys/fs/cgroup
/dev/sda1 484004
132984 351020 28% /boot
/dev/mapper/rhel-app 2086912 32944
2053968 2% /app
tmpfs 388176 0 388176
0% /run/user/0
/dev/sr0 3704296
3704296 0 100% /mnt/cdrom
overlay 9754624
2296292 7458332 24%
/var/lib/docker/overlay/26ad0f32be23508e52b647d575643e2f2245d3ff6ca50afb49eb22bb5dd3d7b3/merged
shm 65536 0 65536 0%
/var/lib/docker/containers/5dc91cba6dac1b33b1298d270d873646e1887e1fabe0bb57cee7699e1beda828/shm
overlay 9754624
2296292 7458332 24%
/var/lib/docker/overlay/223b236a228f356a3739ecdbe24cfbdb6b3c19825f76fb899b4d1dabaa277244/merged
shm 65536 0 65536 0%
/var/lib/docker/containers/ae2d23d71b942c4987602c917628946369e5c7ba82714e06057373cac25a4245/shm
overlay 9754624
2296292 7458332 24%
/var/lib/docker/overlay/6e804ee7744204f663d56ae337fc7621115a562eac8913d3882d53395e7954c5/merged
shm 65536 0 65536 0%
/var/lib/docker/containers/f8e688a5bb66a73722659d420de4622dcf8c1e8ebcc84f4b3ebd17762efc1a50/shm
[root@localhost ~]#
进入容器
---------------------------------------
[root@localhost ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." 42
minutes ago Up 34 minutes 0.0.0.0:80->80/tcp,
443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." About an hour ago Up About an hour 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
About an hour ago Up About an
hour 3306/tcp
mysql-server
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker attach mysql-server
^C
[root@localhost ~]# docker exec -it 5dc91cba6dac
/bin/bash
root@5dc91cba6dac:/#
root@5dc91cba6dac:/#
root@5dc91cba6dac:/#
root@5dc91cba6dac:/# ps -ef
UID PID PPID C
STIME TTY TIME CMD
mysql 1 0
0 11:13 ? 00:00:17 mysqld
--character-set-server=utf8 --collation-server=utf8_general_ci
--sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUT
root 194 0 0
12:17 ? 00:00:00 /bin/bash
root 200 194 0 12:17 ?
00:00:00 ps -ef
root@5dc91cba6dac:/# mysql -u root -pywwd.net
mysql: [Warning] Using a password on the command line
interface can be insecure.
Welcome to the MySQL monitor. Commands end
with ; or \g.
Your MySQL connection id is 440
Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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>
mysql> select database();
+------------+
| database() |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)
mysql> show database;
ERROR 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near 'database' at line 1
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+
5 rows in set (0.01 sec)
mysql> use zabbix
Reading table information for completion of table and column
names
You can turn off this feature to get a quicker startup with
-A
Database changed
mysql> show variables like '%inno%';
+------------------------------------------+------------------------+
| Variable_name | Value
|
+------------------------------------------+------------------------+
| ignore_builtin_innodb | OFF |
| innodb_adaptive_flushing | ON |
| innodb_adaptive_flushing_lwm | 10 |
| innodb_adaptive_hash_index | ON
|
| innodb_adaptive_hash_index_parts | 8
|
| innodb_adaptive_max_sleep_delay | 150000 |
| innodb_api_bk_commit_interval | 5 |
| innodb_api_disable_rowlock | OFF
|
| innodb_api_enable_binlog | OFF |
| innodb_api_enable_mdl | OFF |
| innodb_api_trx_level | 0 |
| innodb_autoextend_increment | 64
|
| innodb_autoinc_lock_mode | 1 |
| innodb_buffer_pool_chunk_size | 134217728 |
| innodb_buffer_pool_dump_at_shutdown | ON |
| innodb_buffer_pool_dump_now | OFF
|
| innodb_buffer_pool_dump_pct | 25
|
| innodb_buffer_pool_filename |
ib_buffer_pool |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_buffer_pool_load_now | OFF
|
| innodb_buffer_pool_size | 134217728 |
| innodb_change_buffer_max_size | 25 |
| innodb_change_buffering | all |
| innodb_checksum_algorithm | crc32 |
| innodb_checksums | ON |
| innodb_cmp_per_index_enabled | OFF |
| innodb_commit_concurrency | 0 |
| innodb_compression_failure_threshold_pct | 5
|
| innodb_compression_level | 6 |
| innodb_compression_pad_pct_max | 50 |
| innodb_concurrency_tickets | 5000
|
| innodb_data_file_path | ibdata1:12M:autoextend
|
| innodb_data_home_dir | |
| innodb_deadlock_detect | ON |
| innodb_default_row_format | dynamic |
| innodb_disable_sort_file_cache | OFF |
| innodb_doublewrite | ON
|
| innodb_fast_shutdown | 1 |
| innodb_file_format |
Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Barracuda |
| innodb_file_per_table | ON |
| innodb_fill_factor | 100
|
| innodb_flush_log_at_timeout | 1
|
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method |
|
| innodb_flush_neighbors | 1 |
| innodb_flush_sync | ON |
| innodb_flushing_avg_loops | 30 |
| innodb_force_load_corrupted | OFF
|
| innodb_force_recovery | 0 |
| innodb_ft_aux_table |
|
| innodb_ft_cache_size | 8000000 |
| innodb_ft_enable_diag_print | OFF
|
| innodb_ft_enable_stopword | ON |
| innodb_ft_max_token_size | 84 |
| innodb_ft_min_token_size | 3 |
| innodb_ft_num_word_optimize | 2000
|
| innodb_ft_result_cache_limit | 2000000000
|
| innodb_ft_server_stopword_table | |
| innodb_ft_sort_pll_degree | 2 |
| innodb_ft_total_cache_size |
640000000 |
| innodb_ft_user_stopword_table | |
| innodb_io_capacity | 200
|
| innodb_io_capacity_max | 2000 |
| innodb_large_prefix | ON
|
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_buffer_size | 16777216 |
| innodb_log_checksums | ON |
| innodb_log_compressed_pages | ON
|
| innodb_log_file_size | 50331648 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_log_write_ahead_size | 8192
|
| innodb_lru_scan_depth | 1024 |
| innodb_max_dirty_pages_pct |
75.000000 |
| innodb_max_dirty_pages_pct_lwm | 0.000000 |
| innodb_max_purge_lag | 0 |
| innodb_max_purge_lag_delay | 0
|
| innodb_max_undo_log_size | 1073741824 |
| innodb_monitor_disable | |
| innodb_monitor_enable | |
| innodb_monitor_reset | |
| innodb_monitor_reset_all | |
| innodb_numa_interleave | OFF |
| innodb_old_blocks_pct | 37 |
| innodb_old_blocks_time | 1000 |
| innodb_online_alter_log_max_size |
134217728 |
| innodb_open_files | 2000 |
| innodb_optimize_fulltext_only | OFF |
| innodb_page_cleaners | 1 |
| innodb_page_size | 16384 |
| innodb_print_all_deadlocks | OFF
|
| innodb_purge_batch_size | 300 |
| innodb_purge_rseg_truncate_frequency | 128 |
| innodb_purge_threads | 4 |
| innodb_random_read_ahead | OFF |
| innodb_read_ahead_threshold | 56
|
| innodb_read_io_threads | 4 |
| innodb_read_only | OFF |
| innodb_replication_delay | 0 |
| innodb_rollback_on_timeout | OFF
|
| innodb_rollback_segments | 128 |
| innodb_sort_buffer_size | 1048576 |
| innodb_spin_wait_delay | 6 |
| innodb_stats_auto_recalc | ON |
| innodb_stats_include_delete_marked | OFF |
| innodb_stats_method |
nulls_equal |
| innodb_stats_on_metadata | OFF |
| innodb_stats_persistent | ON |
| innodb_stats_persistent_sample_pages | 20 |
| innodb_stats_sample_pages | 8 |
| innodb_stats_transient_sample_pages | 8 |
| innodb_status_output | OFF |
| innodb_status_output_locks | OFF
|
| innodb_strict_mode | ON
|
| innodb_support_xa | ON |
| innodb_sync_array_size | 1 |
| innodb_sync_spin_loops | 30 |
| innodb_table_locks | ON
|
| innodb_temp_data_file_path |
ibtmp1:12M:autoextend |
| innodb_thread_concurrency | 0 |
| innodb_thread_sleep_delay | 10000 |
| innodb_tmpdir |
|
| innodb_undo_directory | ./ |
| innodb_undo_log_truncate | OFF |
| innodb_undo_logs | 128 |
| innodb_undo_tablespaces | 0 |
| innodb_use_native_aio | ON |
| innodb_version | 5.7.18 |
| innodb_write_io_threads | 4 |
+------------------------------------------+------------------------+
134 rows in set (0.00 sec)
mysql>
mysql>
mysql> show variables like '%log%';
+-----------------------------------------+---------------------------------------------+
| Variable_name | Value |
+-----------------------------------------+---------------------------------------------+
| back_log | 80 |
| binlog_cache_size | 32768
|
| binlog_checksum | CRC32 |
| binlog_direct_non_transactional_updates | OFF
|
| binlog_error_action | ABORT_SERVER
|
| binlog_format | ROW |
| binlog_group_commit_sync_delay | 0 |
| binlog_group_commit_sync_no_delay_count | 0
|
| binlog_gtid_simple_recovery | ON |
| binlog_max_flush_queue_time | 0 |
| binlog_order_commits | ON |
| binlog_row_image | FULL |
| binlog_rows_query_log_events | OFF |
| binlog_stmt_cache_size | 32768 |
| expire_logs_days | 0 |
| general_log | OFF
|
| general_log_file | /var/lib/mysql/5dc91cba6dac.log
|
| innodb_api_enable_binlog | OFF |
| innodb_flush_log_at_timeout | 1 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_buffer_size | 16777216 |
| innodb_log_checksums | ON |
| innodb_log_compressed_pages | ON |
| innodb_log_file_size | 50331648 |
| innodb_log_files_in_group | 2
|
| innodb_log_group_home_dir | ./
|
| innodb_log_write_ahead_size | 8192 |
| innodb_max_undo_log_size | 1073741824 |
| innodb_online_alter_log_max_size | 134217728
|
| innodb_undo_log_truncate | OFF |
| innodb_undo_logs | 128 |
| log_bin | OFF |
| log_bin_basename | |
| log_bin_index | |
| log_bin_trust_function_creators | OFF
|
| log_bin_use_v1_row_events | OFF
|
| log_builtin_as_identified_by_password |
OFF |
| log_error | stderr |
| log_error_verbosity | 3 |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF
|
| log_slow_admin_statements | OFF
|
| log_slow_slave_statements | OFF
|
| log_statements_unsafe_for_binlog | ON
|
| log_syslog | OFF |
| log_syslog_facility | daemon |
| log_syslog_include_pid | ON |
| log_syslog_tag | |
| log_throttle_queries_not_using_indexes | 0
|
| log_timestamps | UTC |
| log_warnings | 2
|
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| max_binlog_stmt_cache_size |
18446744073709547520 |
| max_relay_log_size | 0
|
| relay_log | |
| relay_log_basename |
/var/lib/mysql/5dc91cba6dac-relay-bin |
| relay_log_index | /var/lib/mysql/5dc91cba6dac-relay-bin.index
|
| relay_log_info_file | relay-log.info
|
| relay_log_info_repository | FILE
|
| relay_log_purge | ON |
| relay_log_recovery | OFF
|
| relay_log_space_limit | 0 |
| slow_query_log | OFF |
| slow_query_log_file |
/var/lib/mysql/5dc91cba6dac-slow.log |
| sql_log_bin | ON
|
| sql_log_off | OFF
|
| sync_binlog | 1
|
| sync_relay_log | 10000 |
| sync_relay_log_info | 10000 |
+-----------------------------------------+---------------------------------------------+
72 rows in set (0.01 sec)
mysql>
mysql> show variables like '%table%';
+----------------------------------------+----------+
| Variable_name | Value |
+----------------------------------------+----------+
| big_tables | OFF
|
| innodb_file_per_table | ON |
| innodb_ft_aux_table | |
| innodb_ft_server_stopword_table |
|
| innodb_ft_user_stopword_table | |
| innodb_table_locks | ON |
| innodb_undo_tablespaces | 0 |
| lower_case_table_names | 0
|
| max_heap_table_size | 16777216 |
| max_tmp_tables | 32 |
| old_alter_table | OFF |
| performance_schema_max_table_handles | -1
|
| performance_schema_max_table_instances | -1
|
| performance_schema_max_table_lock_stat | -1
|
| table_definition_cache | 1400
|
| table_open_cache | 2000
|
| table_open_cache_instances | 16 |
| tmp_table_size | 16777216 |
| updatable_views_with_limit | YES |
+----------------------------------------+----------+
19 rows in set (0.01 sec)
mysql>
mysql> select user()
-> ;
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
mysql> select @@version
-> ;
+-----------+
| @@version |
+-----------+
| 5.7.18 |
+-----------+
1 row in set (0.00 sec)
mysql> show variables like '%char%;
'> ;
'> ^C
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client |
latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8
|
| character_set_filesystem | binary |
| character_set_results |
latin1 |
| character_set_server |
utf8 |
| character_set_system |
utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment |
Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO
| NO | NO
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
| NO | NO
| NO |
| CSV | YES | CSV storage engine | NO
| NO | NO
|
| BLACKHOLE | YES
| /dev/null storage engine
(anything you write to it disappears) | NO | NO | NO |
| MyISAM | YES |
MyISAM storage engine | NO | NO
| NO |
| InnoDB | DEFAULT | Supports transactions, row-level
locking, and foreign keys |
YES | YES | YES
|
| ARCHIVE | YES |
Archive storage engine | NO
| NO | NO
|
| MEMORY | YES |
Hash based, stored in memory, useful for temporary tables
| NO
| NO | NO
|
| FEDERATED | NO
| Federated
MySQL storage engine | NULL | NULL |
NULL |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
mysql>
查看容器日志
---------------------------------------
[root@localhost ~]#
[root@localhost ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up About an hour 0.0.0.0:80->80/tcp, 443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." About an hour ago Up About an hour 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
About an hour ago Up About an
hour 3306/tcp
mysql-server
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker logs -f 5dc91cba6dac
Initializing database
2017-05-27T03:13:34.410920Z 0 [Warning] TIMESTAMP with
implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation
for more details).
2017-05-27T03:13:38.069309Z 0 [Warning] InnoDB: New log files
created, LSN=45790
2017-05-27T03:13:38.445535Z 0 [Warning] InnoDB: Creating
foreign key constraint system tables.
2017-05-27T03:13:38.571308Z 0 [Warning] No existing UUID has
been found, so we assume that this is the first time that this
server has been started. Generating a new UUID:
7a78493b-428a-11e7-863e-0242ac110002.
2017-05-27T03:13:38.572894Z 0 [Warning] Gtid table is not
ready to be used. Table 'mysql.gtid_executed' cannot be
opened.
2017-05-27T03:13:38.573624Z 1 [Warning] root@localhost is
created with an empty password ! Please consider switching off the
--initialize-insecure option.
2017-05-27T03:13:39.536836Z 1 [Warning] 'user' entry
'root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:39.536879Z 1 [Warning] 'user' entry
'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:39.536903Z 1 [Warning] 'db' entry 'sys
mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:39.536920Z 1 [Warning] 'proxies_priv' entry
'@ root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:39.536963Z 1 [Warning] 'tables_priv' entry
'sys_config mysql.sys@localhost' ignored in --skip-name-resolve
mode.
Database initialized
Initializing certificates
Generating a 2048 bit RSA private key
..+++
.................................+++
unable to write 'random state'
writing new private key to 'ca-key.pem'
-----
Generating a 2048 bit RSA private key
........+++
......................................................................+++
unable to write 'random state'
writing new private key to 'server-key.pem'
-----
Generating a 2048 bit RSA private key
...................................................................+++
..+++
unable to write 'random state'
writing new private key to 'client-key.pem'
-----
Certificates initialized
MySQL init process in progress...
2017-05-27T03:13:43.047372Z 0 [Warning] TIMESTAMP with
implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation
for more details).
2017-05-27T03:13:43.050204Z 0 [Note] mysqld (mysqld 5.7.18)
starting as process 92 ...
2017-05-27T03:13:43.057969Z 0 [Note] InnoDB: PUNCH HOLE
support available
2017-05-27T03:13:43.058022Z 0 [Note] InnoDB: Mutexes and
rw_locks use GCC atomic builtins
2017-05-27T03:13:43.058045Z 0 [Note] InnoDB: Uses event
mutexes
2017-05-27T03:13:43.058056Z 0 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2017-05-27T03:13:43.058064Z 0 [Note] InnoDB: Compressed tables
use zlib 1.2.3
2017-05-27T03:13:43.058072Z 0 [Note] InnoDB: Using Linux
native AIO
2017-05-27T03:13:43.058960Z 0 [Note] InnoDB: Number of pools:
1
2017-05-27T03:13:43.059347Z 0 [Note] InnoDB: Using CPU crc32
instructions
2017-05-27T03:13:43.064036Z 0 [Note] InnoDB: Initializing
buffer pool, total size = 128M, instances = 1, chunk size =
128M
2017-05-27T03:13:43.082407Z 0 [Note] InnoDB: Completed
initialization of buffer pool
2017-05-27T03:13:43.086048Z 0 [Note] InnoDB: If the mysqld
execution user is authorized, page cleaner thread priority can be
changed. See the man page of setpriority().
2017-05-27T03:13:43.099095Z 0 [Note] InnoDB: Highest supported
file format is Barracuda.
2017-05-27T03:13:43.116083Z 0 [Note] InnoDB: Creating shared
tablespace for temporary tables
2017-05-27T03:13:43.116269Z 0 [Note] InnoDB: Setting file
'./ibtmp1' size to 12 MB. Physically writing the file full; Please
wait ...
2017-05-27T03:13:43.195748Z 0 [Note] InnoDB: File './ibtmp1'
size is now 12 MB.
2017-05-27T03:13:43.197237Z 0 [Note] InnoDB: 96 redo rollback
segment(s) found. 96 redo rollback segment(s) are active.
2017-05-27T03:13:43.197256Z 0 [Note] InnoDB: 32 non-redo
rollback segment(s) are active.
2017-05-27T03:13:43.198657Z 0 [Note] InnoDB: Waiting for purge
to start
2017-05-27T03:13:43.248873Z 0 [Note] InnoDB: 5.7.18 started;
log sequence number 2535558
2017-05-27T03:13:43.249469Z 0 [Note] InnoDB: Loading buffer
pool(s) from /var/lib/mysql/ib_buffer_pool
2017-05-27T03:13:43.249628Z 0 [Note] Plugin 'FEDERATED' is
disabled.
2017-05-27T03:13:43.254829Z 0 [Note] InnoDB: Buffer pool(s)
load completed at 170527 11:13:43
2017-05-27T03:13:43.258935Z 0 [Note] Found ca.pem,
server-cert.pem and server-key.pem in data directory. Trying to
enable SSL support using them.
2017-05-27T03:13:43.259371Z 0 [Warning] CA certificate ca.pem
is self signed.
2017-05-27T03:13:43.265738Z 0 [Warning] 'user' entry
'root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:43.265797Z 0 [Warning] 'user' entry
'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:43.265844Z 0 [Warning] 'db' entry 'sys
mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:43.265866Z 0 [Warning] 'proxies_priv' entry
'@ root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:43.268319Z 0 [Warning] 'tables_priv' entry
'sys_config mysql.sys@localhost' ignored in --skip-name-resolve
mode.
2017-05-27T03:13:43.279920Z 0 [Note] Event Scheduler: Loaded 0
events
2017-05-27T03:13:43.280362Z 0 [Note] mysqld: ready for
connections.
Version: '5.7.18' socket:
'/var/run/mysqld/mysqld.sock' port: 0
MySQL Community Server (GPL)
2017-05-27T03:13:43.280404Z 0 [Note] Executing 'SELECT * FROM
INFORMATION_SCHEMA.TABLES;' to get a list of tables using the
deprecated partition engine. You may use the startup option
'--disable-partition-engine-check' to skip this
check.
2017-05-27T03:13:43.280414Z 0 [Note] Beginning of list of
non-natively partitioned tables
2017-05-27T03:13:43.303045Z 0 [Note] End of list of
non-natively partitioned tables
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as
time zone. Skipping it.
Warning: Unable to load
'/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping
it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time
zone. Skipping it.
2017-05-27T03:13:49.862604Z 5 [Warning] 'user' entry
'root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.862650Z 5 [Warning] 'user' entry
'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.862689Z 5 [Warning] 'db' entry 'sys
mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.862708Z 5 [Warning] 'proxies_priv' entry
'@ root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.862757Z 5 [Warning] 'tables_priv' entry
'sys_config mysql.sys@localhost' ignored in --skip-name-resolve
mode.
mysql: [Warning] Using a password on the command line
interface can be insecure.
mysql: [Warning] Using a password on the command line
interface can be insecure.
mysql: [Warning] Using a password on the command line
interface can be insecure.
mysql: [Warning] Using a password on the command line
interface can be insecure.
2017-05-27T03:13:49.893680Z 9 [Warning] 'user' entry
'root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.893728Z 9 [Warning] 'user' entry
'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.893784Z 9 [Warning] 'db' entry 'sys
mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.893806Z 9 [Warning] 'proxies_priv' entry
'@ root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:49.894023Z 9 [Warning] 'tables_priv' entry
'sys_config mysql.sys@localhost' ignored in --skip-name-resolve
mode.
2017-05-27T03:13:49.895633Z 0 [Note] Giving 0 client threads a
chance to die gracefully
2017-05-27T03:13:49.895663Z 0 [Note] Shutting down slave
threads
2017-05-27T03:13:49.895676Z 0 [Note] Forcefully disconnecting
0 remaining clients
2017-05-27T03:13:49.895689Z 0 [Note] Event Scheduler: Purging
the queue. 0 events
2017-05-27T03:13:49.895782Z 0 [Note] Binlog end
2017-05-27T03:13:49.896833Z 0 [Note] Shutting down plugin
'ngram'
2017-05-27T03:13:49.896852Z 0 [Note] Shutting down plugin
'BLACKHOLE'
2017-05-27T03:13:49.896860Z 0 [Note] Shutting down plugin
'partition'
2017-05-27T03:13:49.896866Z 0 [Note] Shutting down plugin
'ARCHIVE'
2017-05-27T03:13:49.896872Z 0 [Note] Shutting down plugin
'INNODB_SYS_VIRTUAL'
2017-05-27T03:13:49.896878Z 0 [Note] Shutting down plugin
'INNODB_SYS_DATAFILES'
2017-05-27T03:13:49.896884Z 0 [Note] Shutting down plugin
'INNODB_SYS_TABLESPACES'
2017-05-27T03:13:49.896889Z 0 [Note] Shutting down plugin
'INNODB_SYS_FOREIGN_COLS'
2017-05-27T03:13:49.896895Z 0 [Note] Shutting down plugin
'INNODB_SYS_FOREIGN'
2017-05-27T03:13:49.896900Z 0 [Note] Shutting down plugin
'INNODB_SYS_FIELDS'
2017-05-27T03:13:49.896905Z 0 [Note] Shutting down plugin
'INNODB_SYS_COLUMNS'
2017-05-27T03:13:49.896911Z 0 [Note] Shutting down plugin
'INNODB_SYS_INDEXES'
2017-05-27T03:13:49.896916Z 0 [Note] Shutting down plugin
'INNODB_SYS_TABLESTATS'
2017-05-27T03:13:49.896921Z 0 [Note] Shutting down plugin
'INNODB_SYS_TABLES'
2017-05-27T03:13:49.896926Z 0 [Note] Shutting down plugin
'INNODB_FT_INDEX_TABLE'
2017-05-27T03:13:49.896932Z 0 [Note] Shutting down plugin
'INNODB_FT_INDEX_CACHE'
2017-05-27T03:13:49.896937Z 0 [Note] Shutting down plugin
'INNODB_FT_CONFIG'
2017-05-27T03:13:49.896943Z 0 [Note] Shutting down plugin
'INNODB_FT_BEING_DELETED'
2017-05-27T03:13:49.896948Z 0 [Note] Shutting down plugin
'INNODB_FT_DELETED'
2017-05-27T03:13:49.896954Z 0 [Note] Shutting down plugin
'INNODB_FT_DEFAULT_STOPWORD'
2017-05-27T03:13:49.896959Z 0 [Note] Shutting down plugin
'INNODB_METRICS'
2017-05-27T03:13:49.896966Z 0 [Note] Shutting down plugin
'INNODB_TEMP_TABLE_INFO'
2017-05-27T03:13:49.896975Z 0 [Note] Shutting down plugin
'INNODB_BUFFER_POOL_STATS'
2017-05-27T03:13:49.896985Z 0 [Note] Shutting down plugin
'INNODB_BUFFER_PAGE_LRU'
2017-05-27T03:13:49.896995Z 0 [Note] Shutting down plugin
'INNODB_BUFFER_PAGE'
2017-05-27T03:13:49.897004Z 0 [Note] Shutting down plugin
'INNODB_CMP_PER_INDEX_RESET'
2017-05-27T03:13:49.897014Z 0 [Note] Shutting down plugin
'INNODB_CMP_PER_INDEX'
2017-05-27T03:13:49.897024Z 0 [Note] Shutting down plugin
'INNODB_CMPMEM_RESET'
2017-05-27T03:13:49.897032Z 0 [Note] Shutting down plugin
'INNODB_CMPMEM'
2017-05-27T03:13:49.897042Z 0 [Note] Shutting down plugin
'INNODB_CMP_RESET'
2017-05-27T03:13:49.897051Z 0 [Note] Shutting down plugin
'INNODB_CMP'
2017-05-27T03:13:49.897061Z 0 [Note] Shutting down plugin
'INNODB_LOCK_WAITS'
2017-05-27T03:13:49.897068Z 0 [Note] Shutting down plugin
'INNODB_LOCKS'
2017-05-27T03:13:49.897073Z 0 [Note] Shutting down plugin
'INNODB_TRX'
2017-05-27T03:13:49.897078Z 0 [Note] Shutting down plugin
'InnoDB'
2017-05-27T03:13:49.897243Z 0 [Note] InnoDB: FTS optimize
thread exiting.
2017-05-27T03:13:49.897525Z 0 [Note] InnoDB: Starting
shutdown...
2017-05-27T03:13:49.997852Z 0 [Note] InnoDB: Dumping buffer
pool(s) to /var/lib/mysql/ib_buffer_pool
2017-05-27T03:13:49.998472Z 0 [Note] InnoDB: Buffer pool(s)
dump completed at 170527 11:13:49
2017-05-27T03:13:51.209218Z 0 [Note] InnoDB: Shutdown
completed; log sequence number 12141033
2017-05-27T03:13:51.213088Z 0 [Note] InnoDB: Removed temporary
tablespace data file: "ibtmp1"
2017-05-27T03:13:51.213158Z 0 [Note] Shutting down plugin
'MRG_MYISAM'
2017-05-27T03:13:51.213175Z 0 [Note] Shutting down plugin
'MyISAM'
2017-05-27T03:13:51.213190Z 0 [Note] Shutting down plugin
'CSV'
2017-05-27T03:13:51.213198Z 0 [Note] Shutting down plugin
'MEMORY'
2017-05-27T03:13:51.213205Z 0 [Note] Shutting down plugin
'PERFORMANCE_SCHEMA'
2017-05-27T03:13:51.213244Z 0 [Note] Shutting down plugin
'sha256_password'
2017-05-27T03:13:51.213250Z 0 [Note] Shutting down plugin
'mysql_native_password'
2017-05-27T03:13:51.213459Z 0 [Note] Shutting down plugin
'binlog'
2017-05-27T03:13:51.214241Z 0 [Note] mysqld: Shutdown
complete
MySQL init process done. Ready for start up.
2017-05-27T03:13:51.493513Z 0 [Warning] TIMESTAMP with
implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server option (see documentation
for more details).
2017-05-27T03:13:51.496673Z 0 [Note] mysqld (mysqld 5.7.18)
starting as process 1 ...
2017-05-27T03:13:51.504563Z 0 [Note] InnoDB: PUNCH HOLE
support available
2017-05-27T03:13:51.504596Z 0 [Note] InnoDB: Mutexes and
rw_locks use GCC atomic builtins
2017-05-27T03:13:51.504609Z 0 [Note] InnoDB: Uses event
mutexes
2017-05-27T03:13:51.504618Z 0 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier
2017-05-27T03:13:51.504626Z 0 [Note] InnoDB: Compressed tables
use zlib 1.2.3
2017-05-27T03:13:51.504634Z 0 [Note] InnoDB: Using Linux
native AIO
2017-05-27T03:13:51.505027Z 0 [Note] InnoDB: Number of pools:
1
2017-05-27T03:13:51.505216Z 0 [Note] InnoDB: Using CPU crc32
instructions
2017-05-27T03:13:51.507557Z 0 [Note] InnoDB: Initializing
buffer pool, total size = 128M, instances = 1, chunk size =
128M
2017-05-27T03:13:51.521833Z 0 [Note] InnoDB: Completed
initialization of buffer pool
2017-05-27T03:13:51.525050Z 0 [Note] InnoDB: If the mysqld
execution user is authorized, page cleaner thread priority can be
changed. See the man page of setpriority().
2017-05-27T03:13:51.537671Z 0 [Note] InnoDB: Highest supported
file format is Barracuda.
2017-05-27T03:13:51.549815Z 0 [Note] InnoDB: Creating shared
tablespace for temporary tables
2017-05-27T03:13:51.549983Z 0 [Note] InnoDB: Setting file
'./ibtmp1' size to 12 MB. Physically writing the file full; Please
wait ...
2017-05-27T03:13:51.676231Z 0 [Note] InnoDB: File './ibtmp1'
size is now 12 MB.
2017-05-27T03:13:51.677704Z 0 [Note] InnoDB: 96 redo rollback
segment(s) found. 96 redo rollback segment(s) are active.
2017-05-27T03:13:51.677722Z 0 [Note] InnoDB: 32 non-redo
rollback segment(s) are active.
2017-05-27T03:13:51.678909Z 0 [Note] InnoDB: Waiting for purge
to start
2017-05-27T03:13:51.729170Z 0 [Note] InnoDB: 5.7.18 started;
log sequence number 12141033
2017-05-27T03:13:51.729428Z 0 [Note] InnoDB: Loading buffer
pool(s) from /var/lib/mysql/ib_buffer_pool
2017-05-27T03:13:51.730268Z 0 [Note] Plugin 'FEDERATED' is
disabled.
2017-05-27T03:13:51.735259Z 0 [Note] InnoDB: Buffer pool(s)
load completed at 170527 11:13:51
2017-05-27T03:13:51.736988Z 0 [Note] Found ca.pem,
server-cert.pem and server-key.pem in data directory. Trying to
enable SSL support using them.
2017-05-27T03:13:51.737397Z 0 [Warning] CA certificate ca.pem
is self signed.
2017-05-27T03:13:51.741209Z 0 [Note] Server hostname
(bind-address): '*'; port: 3306
2017-05-27T03:13:51.741303Z 0 [Note] IPv6 is available.
2017-05-27T03:13:51.741325Z 0 [Note] - '::'
resolves to '::';
2017-05-27T03:13:51.741363Z 0 [Note] Server socket created on
IP: '::'.
2017-05-27T03:13:51.751935Z 0 [Warning] 'user' entry
'root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:51.751999Z 0 [Warning] 'user' entry
'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:51.752059Z 0 [Warning] 'db' entry 'sys
mysql.sys@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:51.752084Z 0 [Warning] 'proxies_priv' entry
'@ root@localhost' ignored in --skip-name-resolve mode.
2017-05-27T03:13:51.756087Z 0 [Warning] 'tables_priv' entry
'sys_config mysql.sys@localhost' ignored in --skip-name-resolve
mode.
2017-05-27T03:13:51.766889Z 0 [Note] Event Scheduler: Loaded 0
events
2017-05-27T03:13:51.767249Z 0 [Note] mysqld: ready for
connections.
Version: '5.7.18' socket:
'/var/run/mysqld/mysqld.sock' port: 3306
MySQL Community Server (GPL)
2017-05-27T03:13:51.767281Z 0 [Note] Executing 'SELECT * FROM
INFORMATION_SCHEMA.TABLES;' to get a list of tables using the
deprecated partition engine. You may use the startup option
'--disable-partition-engine-check' to skip this
check.
2017-05-27T03:13:51.767290Z 0 [Note] Beginning of list of
non-natively partitioned tables
2017-05-27T03:13:51.788305Z 0 [Note] End of list of
non-natively partitioned tables
删除容器
---------------------------------------
[root@localhost docker]# docker run --name mysql-server2 -t
\
> -e MYSQL_DATABASE="zabbix" \
> -e MYSQL_USER="zabbix" \
> -e MYSQL_PASSWORD="ywwd.net" \
> -e MYSQL_ROOT_PASSWORD="ywwd.net" \
> -v /data/container/mysql/zabbix:/var/lib/mysql \
> -v /etc/localtime:/etc/localtime:ro \
> --restart=always \
> -d mysql:5.7 \
> --character-set-server=utf8 --collation-server=utf8_general_ci
--sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
f97f04dc030ef94f58d745a6e7489345d58ee3479bb4d95848d9accdc6cebb21
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f97f04dc030e mysql:5.7 "docker-entrypoint..."
20 seconds ago Up 18 seconds
3306/tcp
mysql-server2
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up About an hour 0.0.0.0:80->80/tcp, 443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." About an hour ago Up About an hour 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
2 hours ago Up 2 hours
3306/tcp mysql-server
[root@localhost docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS
NAMES
f97f04dc030e mysql:5.7 "docker-entrypoint..."
About a minute ago Up About a
minute 3306/tcp mysql-server2
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up About an hour
0.0.0.0:80->80/tcp, 443/tcp
zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." About an hour ago Up About an hour 162/udp, 0.0.0.0:10051->10051/tcp
zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
2 hours ago Up 2 hours 3306/tcp
mysql-server
[root@localhost docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS
NAMES
f97f04dc030e mysql:5.7 "docker-entrypoint..."
About a minute ago Up About a
minute 3306/tcp mysql-server2
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up About an hour
0.0.0.0:80->80/tcp, 443/tcp
zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." About an hour ago Up About an hour 162/udp, 0.0.0.0:10051->10051/tcp
zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
2 hours ago Up 2 hours 3306/tcp
mysql-server
[root@localhost docker]# docker run --name mysql-server3 -t
\
> -e MYSQL_DATABASE="zabbix" \
> -e MYSQL_USER="zabbix" \
> -e MYSQL_PASSWORD="ywwd.net" \
> -e MYSQL_ROOT_PASSWORD="ywwd.net" \
> -v /data/container/mysql3/zabbix:/var/lib/mysql \
> -v /etc/localtime:/etc/localtime:ro \
> --restart=always \
> -d mysql:5.7 \
> --character-set-server=utf8 --collation-server=utf8_general_ci
--sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
e471a355af7f3e28548b34add366cd5c090b6fe79a207652715b14ff23bb3a35
[root@localhost docker]#
[root@localhost docker]#
[root@localhost docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e471a355af7f mysql:5.7 "docker-entrypoint..."
10 seconds ago Up 10 seconds
3306/tcp mysql-server3
f97f04dc030e mysql:5.7 "docker-entrypoint..."
3 minutes ago Up Less than a second
3306/tcp mysql-server2
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up About an hour 0.0.0.0:80->80/tcp, 443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." About an hour ago Up About an hour 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
2 hours ago Up 2 hours
3306/tcp mysql-server
[root@localhost docker]#
[root@localhost docker]# docker rm -f f97f04dc030e
f97f04dc030e
[root@localhost docker]# docker rm -f e471a355af7f
e471a355af7f
[root@localhost docker]#
[root@localhost docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up About an hour 0.0.0.0:80->80/tcp, 443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." 2 hours ago Up 2 hours
162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
2 hours ago Up 2 hours
3306/tcp mysql-server
[root@localhost docker]#
停止&开启容器
---------------------------------------
[root@localhost ~]#
[root@localhost ~]# docker stop f8e688a5bb66
f8e688a5bb66
[root@localhost ~]# docker stop ae2d23d71b94
ae2d23d71b94
[root@localhost ~]# docker stop 5dc91cba6dac
5dc91cba6dac
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker start 5dc91cba6dac
5dc91cba6dac
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker start ae2d23d71b94
ae2d23d71b94
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker start f8e688a5bb66
f8e688a5bb66
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." About
an hour ago Up 6 seconds 0.0.0.0:80->80/tcp, 443/tcp zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." 2 hours ago Up 15
seconds 162/udp, 0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
2 hours ago Up 24
seconds 3306/tcp mysql-server
[root@localhost ~]#
-------------------------------------------------------------------------2nd
wordpress
[root@localhost ~]# docker images
REPOSITORY TAG
IMAGE ID CREATED SIZE
nginx latest 958a7ae9e569
13 hours ago 109MB
eboraas/apache-php latest edc7b2f6a8d7 22 hours
ago 298MB
eboraas/apache latest 080379071fd9
22 hours ago 264MB
zabbix/zabbix-web-nginx-mysql latest
bd6c53828812 4 days ago
175MB
zabbix/zabbix-server-mysql latest c07e103ee5c1 4 days ago
104MB
tomcat latest 3695a0fe8320 7 days ago
334MB
wordpress latest
ca96afcfa242 13 days ago
406MB
miguelbrunello/tomcat7-7 latest cf6034508102 2 weeks ago
705MB
ubuntu latest ebcd9d4fca80 2 weeks ago
118MB
mysql 5.7 e799c7f9ae9c 3 weeks ago 407MB
mysql latest e799c7f9ae9c
3 weeks ago 407MB
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
a4ec3e2d2fa7 wordpress "docker-entrypoint..."
39 minutes ago Up 39 minutes
0.0.0.0:32778->80/tcp wordpress_kylix
bf7a861d241f eboraas/apache-php
"/usr/sbin/apache2..." About
an hour ago Up About an hour 0.0.0.0:32777->80/tcp,
0.0.0.0:32776->443/tcp apache_2
d33870a54669 eboraas/apache
"/usr/sbin/apache2..." About an hour ago
Up About an hour 0.0.0.0:32775->80/tcp,
0.0.0.0:32774->443/tcp apache_1
9caf85c043fb nginx "nginx -g 'daemon ..." About
an hour ago Up About an hour 0.0.0.0:32773->80/tcp nginx_tmp2017
5c20f43a16b8 miguelbrunello/tomcat7-7
"/start.sh" 2 hours ago
Up 2 hours 0.0.0.0:32770->22/tcp,
0.0.0.0:32769->8080/tcp dev_tomcat7-7
fe2d2687e105 tomcat "catalina.sh run" 2 hours ago Up 2 hours
0.0.0.0:32768->8080/tcp
dev_tomcat8
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." 4 days
ago Up 4 days 0.0.0.0:80->80/tcp, 443/tcp
zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." 4 days ago Up 4 days 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
4 days ago Up 4 days
3306/tcp mysql-server
[root@localhost ~]#
docker run --name mysql_wordpress -e
MYSQL_ROOT_PASSWORD=root#123 -p 3308:3306 -d mysql:latest
docker run -d --name wordpress_kylix2 --link
mysql_wordpress:mysql -p 8081:80 wordpress
[root@localhost ~]# docker run --name mysql_wordpress -e
MYSQL_ROOT_PASSWORD=root#123 -p 3308:3306 -d mysql:latest
ccfccef2a7ce7b1540449a2ebef8164d02c61f21c2255f1547d3fd9e0ebed316
[root@localhost ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ccfccef2a7ce mysql:latest
"docker-entrypoint..." 5
seconds ago Up 4 seconds 0.0.0.0:3308->3306/tcp mysql_wordpress
a4ec3e2d2fa7 wordpress "docker-entrypoint..."
44 minutes ago Up 44 minutes
0.0.0.0:32778->80/tcp wordpress_kylix
bf7a861d241f eboraas/apache-php
"/usr/sbin/apache2..." About
an hour ago Up About an hour 0.0.0.0:32777->80/tcp,
0.0.0.0:32776->443/tcp apache_2
d33870a54669 eboraas/apache
"/usr/sbin/apache2..." About an hour ago
Up About an hour 0.0.0.0:32775->80/tcp,
0.0.0.0:32774->443/tcp apache_1
9caf85c043fb nginx "nginx -g 'daemon ..." 2 hours
ago Up 2 hours 0.0.0.0:32773->80/tcp nginx_tmp2017
5c20f43a16b8 miguelbrunello/tomcat7-7
"/start.sh" 2 hours ago
Up 2 hours 0.0.0.0:32770->22/tcp,
0.0.0.0:32769->8080/tcp dev_tomcat7-7
fe2d2687e105 tomcat "catalina.sh run" 2 hours ago Up 2 hours
0.0.0.0:32768->8080/tcp
dev_tomcat8
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." 4 days
ago Up 4 days 0.0.0.0:80->80/tcp, 443/tcp
zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." 4 days ago Up 4 days 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
4 days ago Up 4 days
3306/tcp mysql-server
[root@localhost ~]# docker run -d --name wordpress_kylix2
--link mysql_wordpress:mysql -p 8081:80 wordpress
ebbb221c2fbe2831cbe2b600b3b03a7e8fa78decad521f71c57672b1737a7474
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ebbb221c2fbe wordpress "docker-entrypoint..."
4 seconds ago Up 3 seconds
0.0.0.0:8081->80/tcp wordpress_kylix2
ccfccef2a7ce mysql:latest
"docker-entrypoint..." 42
seconds ago Up 42 seconds 0.0.0.0:3308->3306/tcp
mysql_wordpress
a4ec3e2d2fa7 wordpress "docker-entrypoint..."
45 minutes ago Up 45 minutes
0.0.0.0:32778->80/tcp wordpress_kylix
bf7a861d241f eboraas/apache-php
"/usr/sbin/apache2..." About
an hour ago Up About an hour 0.0.0.0:32777->80/tcp,
0.0.0.0:32776->443/tcp apache_2
d33870a54669 eboraas/apache
"/usr/sbin/apache2..." About an hour ago
Up About an hour 0.0.0.0:32775->80/tcp,
0.0.0.0:32774->443/tcp apache_1
9caf85c043fb nginx "nginx -g 'daemon ..." 2 hours
ago Up 2 hours 0.0.0.0:32773->80/tcp nginx_tmp2017
5c20f43a16b8 miguelbrunello/tomcat7-7
"/start.sh" 2 hours ago
Up 2 hours 0.0.0.0:32770->22/tcp,
0.0.0.0:32769->8080/tcp dev_tomcat7-7
fe2d2687e105 tomcat "catalina.sh run" 2 hours ago Up 2 hours
0.0.0.0:32768->8080/tcp
dev_tomcat8
f8e688a5bb66 zabbix/zabbix-web-nginx-mysql:latest
"/bin/bash /run_za..." 4 days
ago Up 4 days 0.0.0.0:80->80/tcp, 443/tcp
zabbix-web-nginx-mysql
ae2d23d71b94 zabbix/zabbix-server-mysql:latest
"/bin/bash
/run_za..." 4 days ago Up 4 days 162/udp,
0.0.0.0:10051->10051/tcp zabbix-server-mysql
5dc91cba6dac mysql:5.7 "docker-entrypoint..."
4 days ago Up 4 days
3306/tcp mysql-server
[root@localhost ~]#
http://192.168.120.127:8081/wp-admin/install.php
[root@localhost ~]# docker exec -it ccfccef2a7ce
/bin/bash
root@ccfccef2a7ce:/#
root@ccfccef2a7ce:/#
root@ccfccef2a7ce:/# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using password: NO)
root@ccfccef2a7ce:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end
with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| wordpress |
+--------------------+
5 rows in set (0.00 sec)
mysql>