FFXI (Final Fantasy 11) Private Server Setup MySQL Server and Workbench 8.0 install and settings.
MySQL Community installer 5.7 server with 8.0 Workbench



VISUAL STUDIO 2022
[ Ссылка ]
Visual Studio 2022 (Community is fine, make sure you select C++ development and windows SDK during install)

[ Ссылка ]
This can be a bit confusing, so please follow the steps correctly to ensure you don't run into any errors.

Make sure you write down your IP address, username, and password.
The default settings are
username: root
password: *your choice
Make sure you the same one for Navicat and Mysql Workbench along with the FFXI files.

** INSTALL SETTINGS BELOW **

MySQL 5.7 (New)
​
Note: Server is x86, but will install 32-bit and 64-bit binaries.



Accept License Terms



Choosing setup type: Keep defaults. Note, you can select "Server only", but Developer Default will allow you to skip the MySQL Workbench below, and it will require more diskspace.



Check Requirements: Click next. You should not need anything that shows "Manual", but you can download the modules separately if you do need them later for some reason. *Note, if you are missing some of the elements (Status = manual), it will pop up with a message stating "One or more product requirements have not been satisfied". Click yes to continue.



Installation: It will show a list of those things that you will install (it will not list those that had "Manual" in previous step). Click Execute.

Product Configuration: This screen will just tell you that there is still some stuff to configure. Click Next.



Group Replication: Leave default setting (Standalone MySQL Server / Classic MySQL Replication) and click Next



Type and Networking: Leave default settings and click Next (Only reason you would need to change is if you are planning to run a dedicated online server, in which case, I hope you know what these options already mean...)



Accounts and Roles: Enter MySQL Root Password, twice. Remember it! - Click Next



Windows Service: Leave default settings and click Next.



Plugins and Extensions: Leave default settings and click Next.



Apply Configuration: Click Execute. It will show you the progress as it configures your MySQL installation. Once complete, click Finish



Product Configuration: Click Next, (This will set up some samples and examples databases)



Connect to Server: Enter the password you entered for the MySQL (Under Accounts and Roles section) at the bottom where it asks for password, then click Check. As long as the password is correct, it will ungrey the Next button and allow you to continue. Click Next.



Apply Configuration: Just like the Apply configuration above. Click Execute, it will configure, then click Finish once complete.

Product Configuration: Click Next.

Installation Complete: As per the title, you are done. Click Finish and enjoy your new MySQL database.

свернуть