After upgrading MySQL to MariaDB 10.0.23, i got following error
root@server48 [/usr/local]# mysql jscsocce_jsc Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11515 Server version: 10.0.23-MariaDB MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [jscsocce_jsc]> select * from school; ERROR 1286 (42000): Unknown storage engine 'InnoDB' MariaDB [jscsocce_jsc]>
This was because InnoDB was not enabled in /etc/my.cnf
To enable InooDB, edit
vi /etc/my.cnf
add
innodb_buffer_pool_size=16M innodb_additional_mem_pool_size=500K innodb_log_buffer_size=500K innodb_thread_concurrency=2 innodb_file_per_table=1
Now restart MariaDB, on CentOS 7 server, run
systemctl stop mariadb systemctl start mariadb