+ rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:2M;ibdata2:10M:autoextend --innodb-page-size=4K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:19 140057632695808 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11094 ... 2017-05-28 13:53:19 140057632695808 [ERROR] InnoDB: first datafile is too small current=2M it should be at least 3M. 2017-05-28 13:53:19 140057632695808 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:53:19 140057632695808 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:53:19 140057632695808 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:53:19 140057632695808 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=4K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:20 139830526256640 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11132 ... 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 4096 . 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:53:20 139830526256640 [Warning] InnoDB: New log files created, LSN=39318 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:53:20 139830526256640 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:53:21 139830526256640 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:21 139830526256640 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:53:21 139830526256640 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:53:21 139830526256640 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:53:21 139830526256640 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:53:21 139830526256640 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:21 139830526256640 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0 2017-05-28 13:53:21 139829740304128 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:53:21 139830525860608 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:21 139830525860608 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:21 139830525860608 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:53:23 139997545641472 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11197 ... 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 4096 . 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:24 139997545641472 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:25 139997545641472 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:25 139997545641472 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:25 139997545641472 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 702298 2017-05-28 13:53:25 139996753295104 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:53:28 139912980719104 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11253 ... 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 4096 . 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:28 139912980719104 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:29 139912980719104 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:29 139912980719104 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:29 139912980719104 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 702308 2017-05-28 13:53:29 139912187737856 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:2M;ibdata2:10M:autoextend --innodb-page-size=8K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:32 139945686803968 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11342 ... 2017-05-28 13:53:32 139945686803968 [ERROR] InnoDB: first datafile is too small current=2M it should be at least 3M. 2017-05-28 13:53:32 139945686803968 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:53:32 139945686803968 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:53:32 139945686803968 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:53:32 139945686803968 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=8K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:33 139711992378880 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11380 ... 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192 . 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:53:33 139711992378880 [Warning] InnoDB: New log files created, LSN=36365 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:33 139711992378880 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:33 139711992378880 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0 2017-05-28 13:53:33 139711226050304 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:53:34 139711991982848 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:34 139711991982848 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:34 139711991982848 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:53:36 140213602252288 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11444 ... 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192 . 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:36 140213602252288 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:37 140213602252288 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:38 140213602252288 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:38 140213602252288 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:38 140213602252288 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 918787 2017-05-28 13:53:38 140212835448576 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:53:40 140203027785216 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11500 ... 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192 . 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:41 140203027785216 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:42 140203027785216 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:42 140203027785216 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:42 140203027785216 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 918797 2017-05-28 13:53:42 140202261608192 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:2M;ibdata2:10M:autoextend --innodb-page-size=16K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:45 140252419249664 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11589 ... 2017-05-28 13:53:45 140252419249664 [ERROR] InnoDB: first datafile is too small current=2M it should be at least 3M. 2017-05-28 13:53:45 140252419249664 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:53:45 140252419249664 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:53:45 140252419249664 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:53:45 140252419249664 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=16K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:45 139816903632384 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11627 ... 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:53:46 139816903632384 [Warning] InnoDB: New log files created, LSN=45883 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:46 139816903632384 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:46 139816903632384 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0 2017-05-28 13:53:46 139816154953472 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:53:46 139816903236352 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:46 139816903236352 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:46 139816903236352 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:53:49 139922494100992 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11682 ... 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:49 139922494100992 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:50 139922494100992 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:50 139922494100992 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:50 139922494100992 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616799 2017-05-28 13:53:50 139921742362368 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:53:53 140577212786176 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11748 ... 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:53 140577212786176 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:53:54 140577212786176 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:53:55 140577212786176 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:55 140577212786176 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:55 140577212786176 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616809 2017-05-28 13:53:55 140576456439552 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=32K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:58 140175673693696 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11829 ... 2017-05-28 13:53:58 140175673693696 [ERROR] InnoDB: first datafile is too small current=3M it should be at least 6M. 2017-05-28 13:53:58 140175673693696 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:53:58 140175673693696 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:53:58 140175673693696 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:53:58 140175673693696 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:6M;ibdata2:10M:autoextend --innodb-page-size=32K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:53:58 140453266339328 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11858 ... 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768 . 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Setting file ./ibdata1 size to 6 MB 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:53:58 140453266339328 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:53:59 140453266339328 [Warning] InnoDB: New log files created, LSN=74254 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:53:59 140453266339328 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:53:59 140453266339328 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0 2017-05-28 13:53:59 140452514756352 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:54:00 140453265943296 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:00 140453265943296 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:00 140453265943296 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:54:02 140117008168448 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11922 ... 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768 . 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:54:02 140117008168448 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:03 140117008168448 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:03 140117008168448 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:03 140117008168448 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:04 140117008168448 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:04 140117008168448 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:04 140117008168448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 3099257 2017-05-28 13:54:04 140116257404672 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:54:07 140706209363456 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 11978 ... 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768 . 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:07 140706209363456 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:08 140706209363456 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:08 140706209363456 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:08 140706209363456 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 3099267 2017-05-28 13:54:08 140705456453376 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:6M;ibdata2:10M:autoextend --innodb-page-size=64K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:11 140210699961856 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12068 ... 2017-05-28 13:54:11 140210699961856 [ERROR] InnoDB: first datafile is too small current=6M it should be at least 12M. 2017-05-28 13:54:11 140210699961856 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:54:11 140210699961856 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:54:11 140210699961856 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:54:11 140210699961856 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:12M;ibdata2:10M:autoextend --innodb-page-size=64K --basedir=/usr/local/mysql Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:12 140099566347776 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12107 ... 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536 . 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:54:12 140099566347776 [Warning] InnoDB: New log files created, LSN=130979 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:54:12 140099566347776 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:54:13 140099566347776 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:13 140099566347776 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:54:13 140099566347776 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:54:13 140099566347776 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:54:13 140099566347776 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:54:13 140099566347776 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:13 140099566347776 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0 2017-05-28 13:54:13 140098821682944 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:54:13 140099565951744 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:13 140099565951744 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:13 140099565951744 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:54:16 139627633595904 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12171 ... 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536 . 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:16 139627633595904 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:17 139627633595904 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:17 139627633595904 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:17 139627633595904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 6074465 2017-05-28 13:54:17 139626882791168 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:54:20 139693183399424 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12233 ... 2017-05-28 13:54:20 139693183399424 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536 . 2017-05-28 13:54:20 139693183399424 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Created tablespace for space 4294967281 name arch_log_space key_id 0 encryption 0. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:21 139693183399424 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:22 139693183399424 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:22 139693183399424 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:22 139693183399424 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 6074475 2017-05-28 13:54:22 139692431374080 [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/ + echo innodb innodb + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:2M;ibdata2:10M:autoextend --innodb-page-size=4K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:25 140687764706816 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12328 ... 2017-05-28 13:54:25 140687764706816 [ERROR] InnoDB: first datafile is too small current=2M it should be at least 3M. 2017-05-28 13:54:25 140687764706816 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:54:25 140687764706816 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:54:25 140687764706816 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:54:25 140687764706816 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=4K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:26 139700948608512 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12366 ... 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 4096. 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:54:26 139700948608512 [Warning] InnoDB: New log files created, LSN=39318 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:26 139700948608512 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:26 139700948608512 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-05-28 13:54:27 139700165670656 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:54:27 139700948212480 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:27 139700948212480 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:27 139700948212480 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:54:29 140645874669056 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12417 ... 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 4096. 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:29 140645874669056 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:30 140645874669056 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:30 140645874669056 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:30 140645874669056 [Note] InnoDB: 5.6.36 started; log sequence number 702298 2017-05-28 13:54:30 140645083641600 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:54:32 139965814064640 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12463 ... 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 4096. 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:32 139965814064640 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:33 139965814064640 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:33 139965814064640 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:33 139965814064640 [Note] InnoDB: 5.6.36 started; log sequence number 702308 2017-05-28 13:54:33 139965023385344 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:2M;ibdata2:10M:autoextend --innodb-page-size=8K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:36 140019899786752 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12524 ... 2017-05-28 13:54:36 140019899786752 [ERROR] InnoDB: first datafile is too small current=2M it should be at least 3M. 2017-05-28 13:54:36 140019899786752 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:54:36 140019899786752 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:54:36 140019899786752 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:54:36 140019899786752 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=8K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:36 140559895524864 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12553 ... 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192. 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:54:36 140559895524864 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:54:37 140559895524864 [Warning] InnoDB: New log files created, LSN=36365 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:37 140559895524864 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:37 140559895524864 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-05-28 13:54:37 140559133964032 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:54:37 140559895128832 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:37 140559895128832 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:37 140559895128832 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:54:39 140595928024576 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12607 ... 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192. 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:39 140595928024576 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:40 140595928024576 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:40 140595928024576 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:40 140595928024576 [Note] InnoDB: 5.6.36 started; log sequence number 918787 2017-05-28 13:54:40 140595158841088 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:54:42 139936076797440 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12662 ... 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 8192. 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:43 139936076797440 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:44 139936076797440 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:44 139936076797440 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:44 139936076797440 [Note] InnoDB: 5.6.36 started; log sequence number 918797 2017-05-28 13:54:44 139935306741504 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:2M;ibdata2:10M:autoextend --innodb-page-size=16K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:46 139962135406080 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12741 ... 2017-05-28 13:54:46 139962135406080 [ERROR] InnoDB: first datafile is too small current=2M it should be at least 3M. 2017-05-28 13:54:46 139962135406080 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:54:46 139962135406080 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:54:46 139962135406080 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:54:46 139962135406080 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=16K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:47 140655936927232 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12770 ... 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Setting file ./ibdata1 size to 3 MB 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:54:47 140655936927232 [Warning] InnoDB: New log files created, LSN=45883 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:47 140655936927232 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:47 140655936927232 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-05-28 13:54:48 140655196108544 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:54:48 140655936531200 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:48 140655936531200 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:48 140655936531200 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:54:50 140021858125312 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12815 ... 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:50 140021858125312 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:51 140021858125312 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:51 140021858125312 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:51 140021858125312 [Note] InnoDB: 5.6.36 started; log sequence number 1616799 2017-05-28 13:54:51 140021105424128 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:54:53 139911961003520 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12863 ... 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:54:53 139911961003520 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:54:54 139911961003520 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:54:54 139911961003520 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:54 139911961003520 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:55 139911961003520 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:55 139911961003520 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:55 139911961003520 [Note] InnoDB: 5.6.36 started; log sequence number 1616809 2017-05-28 13:54:55 139911210465024 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:3M;ibdata2:10M:autoextend --innodb-page-size=32K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:57 140606005966336 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12941 ... 2017-05-28 13:54:57 140606005966336 [ERROR] InnoDB: first datafile is too small current=3M it should be at least 6M. 2017-05-28 13:54:57 140606005966336 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:54:57 140606005966336 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:54:57 140606005966336 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:54:57 140606005966336 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:6M;ibdata2:10M:autoextend --innodb-page-size=32K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:54:57 140610211718656 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 12969 ... 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768. 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Setting file ./ibdata1 size to 6 MB 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:54:58 140610211718656 [Warning] InnoDB: New log files created, LSN=74254 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:54:58 140610211718656 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:54:59 140610211718656 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:54:59 140610211718656 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:54:59 140610211718656 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:54:59 140610211718656 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:54:59 140610211718656 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:54:59 140610211718656 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:54:59 140610211718656 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-05-28 13:54:59 140609469806336 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:54:59 140610211322624 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:54:59 140610211322624 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:54:59 140610211322624 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:55:01 140631926859264 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 13027 ... 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768. 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:55:01 140631926859264 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:55:02 140631926859264 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:55:02 140631926859264 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:55:02 140631926859264 [Note] InnoDB: 5.6.36 started; log sequence number 3099257 2017-05-28 13:55:02 140631183718144 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:55:04 140549207172608 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 13084 ... 2017-05-28 13:55:04 140549207172608 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 32768. 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:55:05 140549207172608 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:55:06 140549207172608 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:55:06 140549207172608 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:55:06 140549207172608 [Note] InnoDB: 5.6.36 started; log sequence number 3099267 2017-05-28 13:55:06 140548463654656 [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/ + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:6M;ibdata2:10M:autoextend --innodb-page-size=64K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:55:08 140484790478336 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 13170 ... 2017-05-28 13:55:08 140484790478336 [ERROR] InnoDB: first datafile is too small current=6M it should be at least 12M. 2017-05-28 13:55:08 140484790478336 [ERROR] Plugin 'InnoDB' init function returned error. 2017-05-28 13:55:08 140484790478336 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-05-28 13:55:08 140484790478336 [ERROR] Unknown/unsupported storage engine: InnoDB 2017-05-28 13:55:08 140484790478336 [ERROR] Aborting Installation of system tables failed! Examine the logs in ./data for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/local/mysql/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/local/mysql/bin/mysqld --skip-grant --general-log & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in ./data that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before submitting a bug report at http://mariadb.org/jira + rm -rf data + /usr/local/mysql/scripts/mysql_install_db --no-defaults --innodb-data-file-path=ibdata1:12M;ibdata2:10M:autoextend --innodb-page-size=64K --basedir=/usr/local/mysql --ignore-builtin-innodb --plugin-load-add=ha_innodb Installing MariaDB/MySQL system tables in './data' ... 2017-05-28 13:55:09 140009089127936 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 13209 ... 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536. 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Setting file ./ibdata2 size to 10 MB 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2017-05-28 13:55:09 140009089127936 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile101 key_id 0 encryption 0. 2017-05-28 13:55:10 140009089127936 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2017-05-28 13:55:10 140009089127936 [Warning] InnoDB: New log files created, LSN=130979 2017-05-28 13:55:10 140009089127936 [Note] InnoDB: Doublewrite buffer not found: creating new 2017-05-28 13:55:10 140009089127936 [Note] InnoDB: Doublewrite buffer created 2017-05-28 13:55:11 140009089127936 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:55:11 140009089127936 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-05-28 13:55:11 140009089127936 [Note] InnoDB: Foreign key constraint system tables created 2017-05-28 13:55:11 140009089127936 [Note] InnoDB: Creating tablespace and datafile system tables. 2017-05-28 13:55:11 140009089127936 [Note] InnoDB: Tablespace and datafile system tables created. 2017-05-28 13:55:11 140009089127936 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:55:11 140009089127936 [Note] InnoDB: 5.6.36 started; log sequence number 0 2017-05-28 13:55:11 140008354739968 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-05-28 13:55:11 140009088731904 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:55:11 140009088731904 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:55:11 140009088731904 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. OK Filling help tables... 2017-05-28 13:55:13 140397939361280 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 13264 ... 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536. 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:55:13 140397939361280 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:55:14 140397939361280 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:55:14 140397939361280 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:55:14 140397939361280 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:55:15 140397939361280 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:55:15 140397939361280 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:55:15 140397939361280 [Note] InnoDB: 5.6.36 started; log sequence number 6074465 2017-05-28 13:55:15 140397187692288 [Note] InnoDB: Dumping buffer pool(s) not yet started OK Creating OpenGIS required SP-s... 2017-05-28 13:55:17 139952954754560 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.1.24-MariaDB-debug) starting as process 13328 ... 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536. 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: The InnoDB memory heap is disabled 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Using Linux native AIO 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Using SSE crc32 instructions 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Completed initialization of buffer pool 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Created tablespace for space 0 name ./ibdata1 key_id 1 encryption 0. 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Created tablespace for space 4294967280 name ./ib_logfile0 key_id 0 encryption 0. 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Highest supported file format is Barracuda. 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Created tablespace for space 3 name mysql/gtid_slave_pos key_id 0 encryption 0. 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Created tablespace for space 2 name mysql/innodb_index_stats key_id 0 encryption 0. 2017-05-28 13:55:17 139952954754560 [Note] InnoDB: Created tablespace for space 1 name mysql/innodb_table_stats key_id 0 encryption 0. 2017-05-28 13:55:18 139952954754560 [Note] InnoDB: 128 rollback segment(s) are active. 2017-05-28 13:55:18 139952954754560 [Note] InnoDB: Waiting for purge to start 2017-05-28 13:55:18 139952954754560 [Note] InnoDB: 5.6.36 started; log sequence number 6074475 2017-05-28 13:55:18 139952201398016 [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/