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

Comments

Post a Comment

Popular posts from this blog

Portlet Edit Mode (Portlet preference) to replace Portlet configuration

Within the  EDIT  portlet mode, a portlet should provide content and logic that lets a user customize the behavior of the portlet Typically, portlets in  EDIT  portlet mode will set or update portlet preferences. Add the following properties to the MVCPortlet component annotation. "javax.portlet.portlet-mode=text/html;edit" "javax.portlet.init-param.edit-template=/edit.jsp" And then If you go into the grid button on the portlet, 'Preference' option will appear which redirects you to edit.jsp
Read more

GoGo Shell & What can be deleted in Liferay Instance

In Liferay Instance, remove 'state' in osgi & 'work' in tomcat to remove all histories. GoGoShell is for checking the current state of each jar files in modules. pen cmd as admin and type 'telnet localhost 11311' lb : list all the jar files with state stop 70 (jar file numner) / start 70 (uninstall 70 but for deletion, it would be better to delete jar file from module folder physically) )
Read more