MySQL Server Setup

* MySQL Server Setup

https://dev.mysql.com/downloads/windows/installer/8.0.html

Download the bottom one (mysql-installer-community-8.0.12.0.msi)


1. Installation
Open Installer, and install MySQL Server and MySQL Workbench through the Installer
(If requirement is not fulfilled in 'Check Requirements' step, click 'Execute' below to resolve it, and move to next

2. Configuration
Leave the default setup and finish configuration.
(You can uncheck "Start the MySQL Server at System Startup".)

* In case you choose "Use Strong Password Encrytion for Authentication" over "Use Legacy Authentication Method", the following entry should be added to MySQL configuration file (ex. my.ini)

2	[mysqld] default-authentication-plugin=mysql_native_password

3. Initializtion

MySQL configuration file is required to run the server, and this file is auto-created in C:\ProgramData\MySQL\MySQL Server 8.0 during the installation in the name of "my.ini"

Copy "my.ini" to C:\Program Files\MySQL\MySQL Server 8.0

(Note the subtle differerence between "ProgramData" and "Program Files"; easy to gloss over)

To modify my.ini, open 'Notepad' as an administrator and open the file there. Changes will be applied when restarting the server.

4. Start MySQL Server

In Command Prompt window, go to C:\Program Files\MySQL\MySQL Server 8.0\bin 

and type 'mysqld --console' (you can create a batch file for shot cut)

(Accessing to DB : mysql -u root -p)

show databases;

* Sample configuration file (custom one)

* References

https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/

https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded