Java 17 Recipes

Listing 12-1. Log of Database Initialization
2021-10-31T19:30:01.391296Z 0 [System] [MY-013169] [Server] C:\mysql\
bin\mysqld.exe (mysqld 8.0.27) initializing of server in progress as 
process 3816
2021-10-31T19:30:01.599643Z 1 [System] [MY-013576] [InnoDB] InnoDB 
initialization has started.
2021-10-31T19:30:19.281112Z 1 [System] [MY-013577] [InnoDB] InnoDB 
initialization has ended.
2021-10-31T19:30:49.726138Z 6 [Note] [MY-010454] [Server] A temporary 
password is generated for root@localhost: )r%Crfs1reOS
The string highlighted in bold is the generated password for the root user (the default 
administrative account in the MySQL grant system) displayed in the stream during the 
initialization. Now, you are ready to work with your database.
Chapter 12 Working With Databases

---

425
Open two console windows. In the first, start the database with the following 
command.
C:\mysql\bin>mysqld.exe --console
Listing 
12-2
 shows the starting up of the server. The --console command lets you 
see the start-up logs being printed.
Listing 12-2. Log of Database Starting Up
C:\mysql\bin>mysqld.exe --console
2021-10-31T19:39:25.558678Z 0 [System] [MY-010116] [Server]
C:\mysql\bin\mysqld.exe (mysqld 8.0.27) starting as process 5500
2021-10-31T19:39:25.597447Z 1 [System] [MY-013576] [InnoDB] InnoDB 
initialization has started.
2021-10-31T19:39:29.188084Z 1 [System] [MY-013577] [InnoDB] InnoDB 
initialization has ended.
2021-10-31T19:39:31.625112Z 0 [Warning] [MY-010068] [Server] CA certificate 
ca.pem is self signed.
2021-10-31T19:39:31.842513Z 0 [System] [MY-011323] [Server] X Plugin ready 
for connections. Bind-address: '::' port: 33060
2021-10-31T19:39:31.842945Z 0 [System] [MY-010931] [Server] C:\mysql\bin\
mysqld.exe: ready for connections. Version: '8.0.27' socket: '' port: 
3306 MySQL Community Server - GPL.
In the second console window, connect to the database with user and password and 
start the MySQL console with the following command.
C:\mysql\bin>mysql -u root -p
After typing the password when prompted (Enter password: ************), you see the 
welcome message on the console, as you can see in Listing 
12-3
.