# MySQL installation guide

# Installation

<table border="1" id="bkmrk-accept-license-agree"><colgroup><col></col><col></col></colgroup><tbody><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/ZLsC8mI2xIdN2M7d-embedded-image-ernpbrqj.png)  
</td><td>Accept license agreement</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/X1FN5nFRymLLRjjn-embedded-image-iui8ybhe.png)  
</td><td>Select custom</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/JX7F9zO1hmHMAZf9-embedded-image-kb8isi8d.png)  
</td><td>Add MySQL Server (x64)</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/wLv17uq6i1AvmH1r-embedded-image-ranehgca.png)  
</td><td>Add MySQL Workbench X64</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/ZNXKsFKLpQeu8Fqd-embedded-image-5whoncke.png)  
</td><td>Expand out MySQL server and select Advanced Options</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/RKa2OeZwGED4Eopd-embedded-image-je6ucgc5.png)  
</td><td>Specify your data directory. A separate drive or partition is HIGHLY recommended.</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/7PtiuWJkQGkerx4R-embedded-image-owwpu6mb.png)  
</td><td>MySQL will now process any requirements.</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/jtdl4qCRfd0Qrlsm-embedded-image-27tufdgu.png)  
</td><td>Click Execute to start MySQL product installation</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/27v97Q5dzYEk7A1B-embedded-image-1iucvcli.png)  
</td><td>Click next to configure MySQL</td></tr></tbody></table>

# Configuration

<table border="1" id="bkmrk-select-standalone-co" style="width: 100%;"><colgroup><col style="width: 76.2756%;"></col><col style="width: 23.7244%;"></col></colgroup><tbody><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/XVuxAfn9XdQeQUMY-embedded-image-7isdgmsu.png)  
</td><td>Select standalone</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/K1hqmqZExVLeUYTf-embedded-image-gr5ahsjn.png)  
</td><td>Config Type: Server Machine

Check Advanced Options

</td></tr><tr><td>[![image.png](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/scaled-1680-/GkI16iXLSfwvCJK0-image.png)](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/GkI16iXLSfwvCJK0-image.png)

</td><td>Most ABit Systems application are configure to work with strong password encryption however check the requirements.

Even with strong encryption enabled it is possible to create a user with legacy.

</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/JHHSSaS3ZfRqSnuE-embedded-image-s3jou4dc.png)

</td><td>Configure a root password</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/3GSQQyrqktYPUC6I-embedded-image-fkcuygqf.png)

</td><td>Add an additional abit user. An additional admin user could also be created to provide to 3rd party IT.

</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/JaboBJTiqeDAvYh2-embedded-image-gbss5kz6.png)

</td><td></td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/2nO0qfQ0b4la07QN-embedded-image-jjigntti.png)

</td><td>Disable slow query log

</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/mSAtyvDZj3uux0eT-embedded-image-uehjj4wk.png)

</td><td>Click execute

</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/zN33iK8KZnXScyxf-embedded-image-iyw0jcyz.png)

</td><td>Click next

</td></tr><tr><td>![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/aqvXNjV7eLJ2D6Bu-embedded-image-ilmonowv.png)

</td><td>Launch MySQL workbench and follow MySQL tuning guide.

</td></tr></tbody></table>