Abit MYSQL 8 Operator's manual

MySQL 8 Installation Guide
Version 1
Page 1 of 15
Copyright ABit Systems 2019
MYSQL 8
Installation and configuration guide for MySQL 8

MySQL 8 Installation Guide
Version 1
Page 2 of 15
Copyright ABit Systems 2019
TABLE OF CONTENTS
Document Revisions ....................................................................................................................................... 3
Installation...................................................................................................................................................... 4
Configuration................................................................................................................................................ 10

MySQL 8 Installation Guide
Version 1
Page 3 of 15
Copyright ABit Systems 2019
DOCUMENT REVISIONS
Revision
Changes
Reviewer
1
Original Version
TM

MySQL 8 Installation Guide
Version 1
Page 4 of 15
Copyright ABit Systems 2019
INSTALLATION
Downloaded the latest version of MySQL from ABit Systems or Official
Accept license agreement
Select Custom

MySQL 8 Installation Guide
Version 1
Page 5 of 15
Copyright ABit Systems 2019
Add MySQL Server (x64)
Add MySQL Workbench X64

MySQL 8 Installation Guide
Version 1
Page 6 of 15
Copyright ABit Systems 2019
Select MySQL Notifier
Select MySQL Utilities X64

MySQL 8 Installation Guide
Version 1
Page 7 of 15
Copyright ABit Systems 2019
Select MySQL Shell X64
Expand out MySQL server and
select Advanced Options

MySQL 8 Installation Guide
Version 1
Page 8 of 15
Copyright ABit Systems 2019
Specify your data directory. A
separate drive or partition is
HIGHLY recommended.
MySQL will now process any
requirements.

MySQL 8 Installation Guide
Version 1
Page 9 of 15
Copyright ABit Systems 2019
Click Execute to start MySQL
product installation
Click next to configure MySQL

MySQL 8 Installation Guide
Version 1
Page 10 of 15
Copyright ABit Systems 2019
CONFIGURATION
Select standalone
Config Type: Server Machine
Check Advanced Options

MySQL 8 Installation Guide
Version 1
Page 11 of 15
Copyright ABit Systems 2019
Set Authentication Method.
Selected “Legacy”
Configure a root password

MySQL 8 Installation Guide
Version 1
Page 12 of 15
Copyright ABit Systems 2019
Recommend adding an additional DB
admin user with access from All Hosts.

MySQL 8 Installation Guide
Version 1
Page 13 of 15
Copyright ABit Systems 2019
X protocol is not required
Disable slow query log

MySQL 8 Installation Guide
Version 1
Page 14 of 15
Copyright ABit Systems 2019
Click execute
Click Next

MySQL 8 Installation Guide
Version 1
Page 15 of 15
Copyright ABit Systems 2019
Launch MySQL workbench and follow
MySQL tuning guide.