jan@jan-laptop-asus:~/jpl$ /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" --basedir=/usr/local/mysql --plugin-load-add=file_key_management --file-key-management-filename=/home/jan/mysql/10.1//mysql-test/std_data/keys.txt --innodb-encrypt-tables --innodb-encrypt-log --innodb-file-per-table=0 --innodb-checksum-algorithm=strict_none
|
Installing MariaDB/MySQL system tables in './data' ...
|
2017-05-18 14:28:36 139979512808960 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 18558 ...
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Using Linux native AIO
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0.
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
|
2017-05-18 14:28:37 139979512808960 [Warning] InnoDB: New log files created, LSN=45883
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Doublewrite buffer not found: creating new
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Doublewrite buffer created
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-18 14:28:37 139979512808960 [Warning] InnoDB: Creating foreign key constraint system tables.
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Foreign key constraint system tables created
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Creating tablespace and datafile system tables.
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Tablespace and datafile system tables created.
|
2017-05-18 14:28:37 139979512808960 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 0
|
2017-05-18 14:28:37 139978768119552 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Filling help tables...
|
2017-05-18 14:28:40 139702222960128 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 18622 ...
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Using Linux native AIO
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-18 14:28:40 139702222960128 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-18 14:28:41 139702222960128 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-18 14:28:41 139702222960128 [Note] InnoDB: Waiting for purge to start
|
2017-05-18 14:28:41 139702222960128 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1612482
|
2017-05-18 14:28:41 139701465904896 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Creating OpenGIS required SP-s...
|
2017-05-18 14:28:44 139719321855488 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 18678 ...
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Using Linux native AIO
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0.
|
2017-05-18 14:28:44 139719321855488 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-18 14:28:46 139719321855488 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-18 14:28:46 139719321855488 [Note] InnoDB: Waiting for purge to start
|
2017-05-18 14:28:46 139719321855488 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1612492
|
2017-05-18 14:28:46 139718566082304 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
|
To start mysqld at boot time you have to copy
|
support-files/mysql.server to the right place for your system
|
|
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
|
To do so, start the server, then issue the following commands:
|
|
'/usr/local/mysql/bin/mysqladmin' -u root password 'new-password'
|
'/usr/local/mysql/bin/mysqladmin' -u root -h jan-laptop-asus password 'new-password'
|
|
Alternatively you can run:
|
'/usr/local/mysql/bin/mysql_secure_installation'
|
|
which will also give you the option of removing the test
|
databases and anonymous user created by default. This is
|
strongly recommended for production servers.
|
|
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
|
MySQL manual for more instructions.
|
|
You can start the MariaDB daemon with:
|
cd '/usr/local/mysql' ; /usr/local/mysql/bin/mysqld_safe --datadir='./data'
|
|
You can test the MariaDB daemon with mysql-test-run.pl
|
cd '/usr/local/mysql/mysql-test' ; perl mysql-test-run.pl
|
|
Please report any problems at http://mariadb.org/jira
|
|
The latest information about MariaDB is available at http://mariadb.org/.
|
You can find additional information about the MySQL part at:
|
http://dev.mysql.com
|
Consider joining MariaDB's strong and vibrant community:
|
https://mariadb.org/get-involved/
|
|
jan@jan-laptop-asus:~/jpl$ rm -rf data
|
jan@jan-laptop-asus:~/jpl$ /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path="ibdata1:3M;ibdata2:10M:autoextend" --basedir=/usr/local/mysql --plugin-load-add=file_key_management --file-key-management-filename=/home/jan/mysql/10.1//mysql-test/std_data/keys.txt --innodb-encrypt-tables --innodb-encrypt-log --innodb-file-per-table=0 --innodb-checksum-algorithm=strict_none --ignore-builtin-innodb --plugin-load-add=ha_innodb
|
Installing MariaDB/MySQL system tables in './data' ...
|
2017-05-18 14:28:59 140041713952256 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 18866 ...
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Using Linux native AIO
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0.
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
|
2017-05-18 14:28:59 140041713952256 [Warning] InnoDB: New log files created, LSN=45883
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Doublewrite buffer not found: creating new
|
2017-05-18 14:28:59 140041713952256 [Note] InnoDB: Doublewrite buffer created
|
2017-05-18 14:29:00 140041713952256 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-18 14:29:00 140041713952256 [Warning] InnoDB: Creating foreign key constraint system tables.
|
2017-05-18 14:29:00 140041713952256 [Note] InnoDB: Foreign key constraint system tables created
|
2017-05-18 14:29:00 140041713952256 [Note] InnoDB: Creating tablespace and datafile system tables.
|
2017-05-18 14:29:00 140041713952256 [Note] InnoDB: Tablespace and datafile system tables created.
|
2017-05-18 14:29:00 140041713952256 [Note] InnoDB: Waiting for purge to start
|
2017-05-18 14:29:00 140041713952256 [Note] InnoDB: 5.6.35 started; log sequence number 0
|
2017-05-18 14:29:00 140040982230784 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Filling help tables...
|
2017-05-18 14:29:02 140323780761088 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 18920 ...
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Using Linux native AIO
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-18 14:29:02 140323780761088 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-18 14:29:03 140323780761088 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-18 14:29:03 140323780761088 [Note] InnoDB: Waiting for purge to start
|
2017-05-18 14:29:03 140323780761088 [Note] InnoDB: 5.6.35 started; log sequence number 1612482
|
2017-05-18 14:29:03 140323040786176 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|
Creating OpenGIS required SP-s...
|
2017-05-18 14:29:05 140488685151744 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 18975 ...
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: The InnoDB memory heap is disabled
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Using Linux native AIO
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Using SSE crc32 instructions
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Initializing buffer pool, size = 128.0M
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Completed initialization of buffer pool
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0.
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0.
|
2017-05-18 14:29:05 140488685151744 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-05-18 14:29:06 140488685151744 [Note] InnoDB: 128 rollback segment(s) are active.
|
2017-05-18 14:29:06 140488685151744 [Note] InnoDB: Waiting for purge to start
|
2017-05-18 14:29:06 140488685151744 [Note] InnoDB: 5.6.35 started; log sequence number 1612492
|
2017-05-18 14:29:06 140487944042240 [Note] InnoDB: Dumping buffer pool(s) not yet started
|
OK
|