head	1.2;
access;
symbols
	pkgsrc-2026Q1:1.2.0.38
	pkgsrc-2026Q1-base:1.2
	pkgsrc-2025Q4:1.2.0.36
	pkgsrc-2025Q4-base:1.2
	pkgsrc-2025Q3:1.2.0.34
	pkgsrc-2025Q3-base:1.2
	pkgsrc-2025Q2:1.2.0.32
	pkgsrc-2025Q2-base:1.2
	pkgsrc-2025Q1:1.2.0.30
	pkgsrc-2025Q1-base:1.2
	pkgsrc-2024Q4:1.2.0.28
	pkgsrc-2024Q4-base:1.2
	pkgsrc-2024Q3:1.2.0.26
	pkgsrc-2024Q3-base:1.2
	pkgsrc-2024Q2:1.2.0.24
	pkgsrc-2024Q2-base:1.2
	pkgsrc-2024Q1:1.2.0.22
	pkgsrc-2024Q1-base:1.2
	pkgsrc-2023Q4:1.2.0.20
	pkgsrc-2023Q4-base:1.2
	pkgsrc-2023Q3:1.2.0.18
	pkgsrc-2023Q3-base:1.2
	pkgsrc-2023Q2:1.2.0.16
	pkgsrc-2023Q2-base:1.2
	pkgsrc-2023Q1:1.2.0.14
	pkgsrc-2023Q1-base:1.2
	pkgsrc-2022Q4:1.2.0.12
	pkgsrc-2022Q4-base:1.2
	pkgsrc-2022Q3:1.2.0.10
	pkgsrc-2022Q3-base:1.2
	pkgsrc-2022Q2:1.2.0.8
	pkgsrc-2022Q2-base:1.2
	pkgsrc-2022Q1:1.2.0.6
	pkgsrc-2022Q1-base:1.2
	pkgsrc-2021Q4:1.2.0.4
	pkgsrc-2021Q4-base:1.2
	pkgsrc-2021Q3:1.2.0.2
	pkgsrc-2021Q3-base:1.2
	pkgsrc-2021Q2:1.1.0.2
	pkgsrc-2021Q2-base:1.1;
locks; strict;
comment	@# @;


1.2
date	2021.09.12.20.32.27;	author gutteridge;	state Exp;
branches;
next	1.1;
commitid	9JugGEm72X6HSH8D;

1.1
date	2021.05.13.15.25.20;	author jdolecek;	state Exp;
branches;
next	;
commitid	VM2QlICeU94R20TC;


desc
@@


1.2
log
@mysql57-server & mysql80-server: correct MESSAGE

As of MySQL 5.7, installations created using --initialize no longer
have an empty root password; one is generated as part of the process
and marked expired. (This message is in part simply advice to read the
documentation. However, it's possible other downstream packagers use
--initialize-insecure instead, which retains the old empty password
approach, so this could be a pkgsrc-specific detail to consider.)
@
text
@===========================================================================
$NetBSD: MESSAGE,v 1.1 2021/05/13 15:25:20 jdolecek Exp $

After the tables are set up and the MySQL server is running, a root
password will be automatically generated; details can be found in the
server logs. On creation, it is marked as expired, and must be changed
immediately.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  ${PREFIX}/bin/mysql_secure_installation.

For both these topics, please see the manual and the MySQL web site for
further instructions.

===========================================================================
@


1.1
log
@import mysql80-client and mysql80-server packages from pkgsrc wip

package is experimental right now - it was confirmed working on NetBSD
and compile on macOS only for now

8.0 brings many improvements over 5.7, following is shortened list, more details
are available on https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

- transactional data dictionary
- atomic DDL
- integrated upgrade procedure
- security and account management improvements
- resource groups and threads (thread affinity needs some work for NetBSD)
- table encryption management
- loads of innodb enhancements
- default character set utf8mb4
- JSON enhancements
- CTE, Window functions
- lateral derived tables
- reworked regular experssion support
- internal temporary tables
- HASH JOIN optimization
- EXPLAIN ANALYZE
- time zone support for TIMESTAMP and DATETIME
- optimizer hints for FORCE INDEX, IGNORE INDEX
- XML enhancements
- single preparation of statements
- single RIGHT JOIN as LEFT JOIN handling
- derived condition pushdown optimization

Number of features were also deprecated, check the release notes for that
@
text
@d2 1
a2 1
$NetBSD: MESSAGE,v 1.1 2016/09/16 06:49:12 adam Exp $
d4 4
a7 9
After the tables are set up and the MySQL server is running,
please remember to set a password for the MySQL root user!
This is done by running both:

  ${PREFIX}/bin/mysqladmin -u root -p password 'new-password'
  ${PREFIX}/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.
d14 2
a15 1
Please see the manual and the MySQL web site for more instructions.
@