Post-installation setup for MySQL 8

Post-installation is a process that describes the basic steps or configuration that the user has to perform after MySQL 8 installation.

Data directory initialization

In previous sections, we have seen different methods of MySQL 8 installation. Some of the methods will automatically create a data directory for MySQL 8. For generic binary distribution and source distribution, data directory creation is a must. Data directory initialization is performed by either of the following two commands:

E:\> bin\mysqld –-initialize 
E:\> bin\mysqld --initialize-insecure

Either of these commands can be chosen based on the user's requirements to generate a random initial password or not. These two commands can be used by the user, regardless of the platform for the data directory initialization. Initializing is a way in which random initial root passwords will be generated. In the case of initialize-insecure, no password will be generated.

Another option is to specify...