Jump to content
AC Tool Forums
Sign in to follow this  

Step 2a: Setup & Import ACE Database


Setup & Import ACE Database

Importing the database for ACEmulator –
1: Open MySQL x.x Command Line Client.

import-db-1.png

2: Type in the password you created during the install.

import-db-2-1.png
import-db-3.png
3: Type in "CREATE DATABASE ace_auth;" without quotes and press enter.
import-db-4.png
4: Type in "CREATE DATABASE ace_shard;" without quotes and press enter.
create-database-shard.png
5: Type in "CREATE DATABASE ace_world;" without quotes and press enter.
create-database-world.png

IT’S HIGHLY RECOMMENDED YOU DO NOT USE THE ROOT ACCOUNT

6: 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';
CHANGE acemu and password WITH A USERNAME AND PASSWORD OF YOUR CHOICE

GRANT ALL PRIVILEGES ON *.* TO 'acemu'@'localhost' WITH GRANT OPTION;
CHANGE acemu WITH A USERNAME OF YOUR CHOICE

CREATE USER 'acemu'@'%' IDENTIFIED BY 'password';
CHANGE acemu and password WITH A USERNAME AND PASSWORD OF YOUR CHOICE

GRANT ALL PRIVILEGES ON *.* TO 'acemu'@'%' WITH GRANT OPTION; CHANGE acemu WITH A USERNAME YOUR CHOICE

FLUSH PRIVILEGES;
import-db-6.png

7: Time to import the databases –

8: Type in "use ace_auth" without the quotes and press Enter.

9: Extract the latest ACE-Master
https://github.com/ACEmulator/ACE

download-ace-2.png

and the latest World Database https://github.com/ACEmulator/ACE-World-16PY-Patches/releases/latest place them on the root of C:\ for ease of use.

download-world-db.png
10: Type in "source c:\ACE-master\Database\Base\AuthenticationBase.sql" without the quotes and press Enter.
import-db-7.png

11: Type in "use ace_shard" without the quotes and press Enter.

12: Type in "source c:\ACE-master\Database\Base\ShardBase.sql" without the quotes and press Enter.

13: Type in "use ace_world" without the quotes and press Enter.

14: Type in "source c:\ACE-master\Database\Base\WorldBase.sql" without the quotes and press Enter.

15: Be sure to follow the same steps above for importing any updates that reside in the

16: Type in "use ace_auth" without quotes and press Enter and import anything found in c:\ACE-master\Database\Updates\Authentication

17: Type in "use ace_shard" without quotes and press Enter and import anything found in c:\ACE-master\Database\Updates\Shard

18: Type in "use ace_world" without quotes and press Enter and import anything found in c:\ACE-master\Database\Updates\World

19: Type in "source c:\ACE-World-Database-vx.x.xxx.sql" without quotes and press Enter. NOTE – This one will take a bit to finish.


Install Visual Studio

Tutorial Videos

Optionally you can add videos from Youtube or Vimeo to your tutorial



Recommended Comments

There are no comments to display.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Add a Comment

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and to our Privacy Policy.