MySQL Data Directory Initialization

MySQL Tutorials - Herong's Tutorial Examples

∟MySQL Data Directory Initialization

Tutorial example on how to initialize the MySQL server data directory with the 'mysqld --initialize-insecure' command, which will create a root user without password.

If you are installing MySQL Server using the Non-Install ZIP package, you need to initialize MySQL server data directory manually. Here is how I did it:

1. Make sure MySQL Server is installed in \local\mysql directory and there is no \local\mysql\data directory.

2. Run the MySQL data initialization command:

herong> \local\mysql\bin\mysqld --initialize-insecure

3. Check log file:

herong> type \local\mysql\data\localhost.err

[System] [MY-013169] [Server] \local\mysql\bin\mysqld
   (mysqld 8.0.16) initializing of server in progress as process 8052

[Warning] [MY-010453] [Server] root@localhost is created with
   an empty password ! Please consider switching off the
   --initialize-insecure option.

[System] [MY-013170] [Server] \local\mysql\bin\mysqld
   (mysqld 8.0.16) initializing of server has completed

Warning message tells us that server data directory was created without a root password. This is because I used the "--initialize-insecure" option. No root password is fine for running a MySQL server on my local computer.