Ark Shop MySql Database 1114 Error on setup

KatKilmowski

Member
Donators
Messages
80
Likes
8
Points
8
I downloaded the ArkShop a few days ago and installed it and the MySQL database. I am using the config file provided with the ArkShop as is, and also the Permissions as is, except for a change to the MySql sections:

Permissions:

{
"Database":"mysql",
"MysqlHost":"localhost",
"MysqlUser":"root",
"MysqlPass":"xxxxx",
"MysqlDB":"ArkShop",
"MysqlPort":3306,
"DbPathOverride":""
}

Arkshop:
"Mysql":{
"UseMysql":true,
"MysqlHost":"localhost",
"MysqlUser":"root",
"MysqlPass":"xxxxx",
"MysqlDB":"ArkShop"
}

I installed MySQL with Legacy authentication.
I have used Add user in the MySQL Workbench and added the root user and password to the ArkShop schema, as well as the other user I had created.
I tried with the root user and password in the config.
I tried with the MySQL user I also setup on installation in the config.
I have tried it with the DbPathOverride set to a directory path. But then saw a post where that seems to only apply for a non-mysql database, so blanked both of those out in the Permissions config and the Arkshop config.

In the workbench I had created an Arkshop model. It has no tables or anything. But I did add a root user and the other user and tried it both ways.
Capture.PNG

Again, the rest of the config file is exactly unchanged. But I can include it if desired.

On mysql installation:
I selected custom install. C++ connector MySQL Server 64 bit.
Workbench x64 (someone said in a post x86, but that option didn't exist, so maybe it was a typo).
Legacy authentication.

Any ideas?

thanks!
 
Advertisement

Official Game Server Partner

KatKilmowski

Member
Donators
Messages
80
Likes
8
Points
8
I apparently installed the schema incorrectly.

After watching this, I followed how they connected to the database and created a schema and now it loads fine.

So for anyone reading this, ignore the image above on my arkshop, and follow these instructions in the video if you are new to mysql.

 

Yetisteven

New member
Messages
29
Likes
2
Points
3
I apparently installed the schema incorrectly.

After watching this, I followed how they connected to the database and created a schema and now it loads fine.

So for anyone reading this, ignore the image above on my arkshop, and follow these instructions in the video if you are new to mysql.

I'm still so lost lol. Someone made the last database for me and I watched them do it, yeah still 100% lost on this lmao
It would be so helpful if there was a simple step by step instruction for how to create an arkshop database for points.
 

Foppa

Moderator
Staff member
Messages
756
Likes
70
Points
28
Website
foppasgaming.com
Well, basically what you need to do use the MySQL feature in any plugin is to do following.


  1. Install Mysql (Windows or Linux doesn't matter)
  2. Set a secured account password on root, never use the root account. Also, ensure so the root account can only connect from "127.0.0.1". Or from the IP of the binding address that MySQL uses.
  3. Setup a database (Schema) called for example "ark_permissions" Example:
    SQL:
    CREATE DATABASE ark_permissions
  4. Create an account called for example "permissions_user" And give the rights to that account to use only the database you created and also allow login from your IP range. Example:
    SQL:
    CREATE USER 'permissions_user'@'10.1.1.%' IDENTIFIED BY 'password';
    Note: 10.1.1.% is just an example range, and your password should be unique.
  5. Now you need to grant that user the database so it has the rights to use. Example:
  6. SQL:
    GRANT ALL PRIVILEGES ON ark_permissions.* TO 'permissions_user'@'10.1.1.%';
  7. And now you should be able to put in your information that you have created to the permission plugin. For the Ark shop, you can just repeat the steps. (i recommend to have separate users for each plugin to have control of what is doing what in your database)
 
Last edited:
Top