mariadb/README.install

23 lines
674 B
Plaintext
Raw Permalink Normal View History

Accepting request 717132 from home:kstreitova:branches:server:database - update to 10.3.16 [bsc#1108088] * notable changes: * MDEV-19490: show tables fails when selecting the information_schema database * MDEV-19491: multi-update with triggers and stored routines * MDEV-19541: InnoDB crashes when trying to recover a corrupted page * MDEV-19725: Incorrect error handling in ALTER TABLE * MDEV-19445: FULLTEXT INDEX fix * MDEV-19486: System Versioning fix * MDEV-19509: InnoDB skips the tablespace in rotation list * MDEV-19614: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables * MDEV-17458: Unable to start galera node * MDEV-17456: Malicious SUPER user can possibly change audit log configuration without leaving traces * MDEV-19588: Wrong results from query, using left join * MDEV-19258: RIGHT JOIN hangs in MariaDB * Virtual columns fixes: MDEV-19027, MDEV-19602 * Crash recovery fixes: MDEV-13080, MDEV-19587, MDEV-19435 * MDEV-11094: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled * MDEV-19076: Fixed slave_parallel_mode=optimistic did not always properly order replication events on temporary tables in some case to attempt execution before a parent event has been already processed * MDEV-19158: Fixed duplicated entries in binlog occurred in combination of LOCK TABLES and binlog_format=MIXED when a being locked table was under replication unsafe operation OBS-URL: https://build.opensuse.org/request/show/717132 OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=231
2019-07-19 19:38:09 +02:00
You have just installed MariaDB server for the first time.
Accepting request 717132 from home:kstreitova:branches:server:database - update to 10.3.16 [bsc#1108088] * notable changes: * MDEV-19490: show tables fails when selecting the information_schema database * MDEV-19491: multi-update with triggers and stored routines * MDEV-19541: InnoDB crashes when trying to recover a corrupted page * MDEV-19725: Incorrect error handling in ALTER TABLE * MDEV-19445: FULLTEXT INDEX fix * MDEV-19486: System Versioning fix * MDEV-19509: InnoDB skips the tablespace in rotation list * MDEV-19614: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables * MDEV-17458: Unable to start galera node * MDEV-17456: Malicious SUPER user can possibly change audit log configuration without leaving traces * MDEV-19588: Wrong results from query, using left join * MDEV-19258: RIGHT JOIN hangs in MariaDB * Virtual columns fixes: MDEV-19027, MDEV-19602 * Crash recovery fixes: MDEV-13080, MDEV-19587, MDEV-19435 * MDEV-11094: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled * MDEV-19076: Fixed slave_parallel_mode=optimistic did not always properly order replication events on temporary tables in some case to attempt execution before a parent event has been already processed * MDEV-19158: Fixed duplicated entries in binlog occurred in combination of LOCK TABLES and binlog_format=MIXED when a being locked table was under replication unsafe operation OBS-URL: https://build.opensuse.org/request/show/717132 OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=231
2019-07-19 19:38:09 +02:00
You can start it via:
systemctl start mariadb
or
rcmysql start
Accepting request 717132 from home:kstreitova:branches:server:database - update to 10.3.16 [bsc#1108088] * notable changes: * MDEV-19490: show tables fails when selecting the information_schema database * MDEV-19491: multi-update with triggers and stored routines * MDEV-19541: InnoDB crashes when trying to recover a corrupted page * MDEV-19725: Incorrect error handling in ALTER TABLE * MDEV-19445: FULLTEXT INDEX fix * MDEV-19486: System Versioning fix * MDEV-19509: InnoDB skips the tablespace in rotation list * MDEV-19614: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables * MDEV-17458: Unable to start galera node * MDEV-17456: Malicious SUPER user can possibly change audit log configuration without leaving traces * MDEV-19588: Wrong results from query, using left join * MDEV-19258: RIGHT JOIN hangs in MariaDB * Virtual columns fixes: MDEV-19027, MDEV-19602 * Crash recovery fixes: MDEV-13080, MDEV-19587, MDEV-19435 * MDEV-11094: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled * MDEV-19076: Fixed slave_parallel_mode=optimistic did not always properly order replication events on temporary tables in some case to attempt execution before a parent event has been already processed * MDEV-19158: Fixed duplicated entries in binlog occurred in combination of LOCK TABLES and binlog_format=MIXED when a being locked table was under replication unsafe operation OBS-URL: https://build.opensuse.org/request/show/717132 OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=231
2019-07-19 19:38:09 +02:00
During the first start, empty database will be created for you automatically.
Accepting request 717132 from home:kstreitova:branches:server:database - update to 10.3.16 [bsc#1108088] * notable changes: * MDEV-19490: show tables fails when selecting the information_schema database * MDEV-19491: multi-update with triggers and stored routines * MDEV-19541: InnoDB crashes when trying to recover a corrupted page * MDEV-19725: Incorrect error handling in ALTER TABLE * MDEV-19445: FULLTEXT INDEX fix * MDEV-19486: System Versioning fix * MDEV-19509: InnoDB skips the tablespace in rotation list * MDEV-19614: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables * MDEV-17458: Unable to start galera node * MDEV-17456: Malicious SUPER user can possibly change audit log configuration without leaving traces * MDEV-19588: Wrong results from query, using left join * MDEV-19258: RIGHT JOIN hangs in MariaDB * Virtual columns fixes: MDEV-19027, MDEV-19602 * Crash recovery fixes: MDEV-13080, MDEV-19587, MDEV-19435 * MDEV-11094: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled * MDEV-19076: Fixed slave_parallel_mode=optimistic did not always properly order replication events on temporary tables in some case to attempt execution before a parent event has been already processed * MDEV-19158: Fixed duplicated entries in binlog occurred in combination of LOCK TABLES and binlog_format=MIXED when a being locked table was under replication unsafe operation OBS-URL: https://build.opensuse.org/request/show/717132 OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=231
2019-07-19 19:38:09 +02:00
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER!
To do so, start the server and run the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h <hostname> password 'new-password'
Alternatively you can run:
'/usr/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.