02/22/2017 Update:
Made a video on how to setup an ACEmu server from scratch.
Disclaimer: This is how I did things. There are other ways I’m sure and this is not the end all be all guide.
How to install ACEmu/Server
1: Install mysql-installer-community-5.7.17.0 ( https://dev.mysql.com/downloads/mysql/5.1.html ) as a Server only remember the root password you chose
2: Install both vcredist_x64 ( https://www.microsoft.com/en-us/download/details.aspx?id=14632 ) and vcredist_x86 ( https://www.microsoft.com/en-us/download/details.aspx?id=5555 )
3: Install both mysql-connector-odbc-5.1.13-win32 ( https://dev.mysql.com/downloads/connector/odbc/5.1.html ) and mysql-connector-odbc-5.1.13-winx64 ( https://dev.mysql.com/downloads/connector/odbc/5.1.html ) use all defaults
4: Open command prompt
5: Change directory to the MySQL bin folder (default c:\Program Files\MySQL\MySQL Server 5.7\bin)
6: Type in MySQL –u root –p (you will be prompted for the root password you chose during install of MySQL Server)
7: Type in CREATE DATABASE ace_auth;
8: Type in CREATE DATABASE ace_character;
9: Type in CREATE DATABASE ace_world;
Below is in case you want to run the server on a different computer than the one your Asheron’s Call is installed on.
10: Type in these next commands (these allow for use of IP address on server instead of localhost or 127.0.0.1)
CREATE USER ‘acemu’@’localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘acemu’@’localhost’ WITH GRANT OPTION;
CREATE USER ‘acemu’@’%’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘acemu’@’%’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
Below is a more beginner way to view and edit the database.
11: Install the latest version of XAMMP (Apache) to use phpmyadmin ( https://www.apachefriends.org/xampp-files/5.6.30/xampp-win32-5.6.30-0-VC11-installer.exe )
Extra Information:
Keep in mind the ACEmu is still under construction and constantly going through changes. This video is merely a how to during the build of 02/22/2017.