Ark Shop MySql Database 1114 Error on setup

[KatKilmowski]

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.
View attachment 1377

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!

 

[KatKilmowski]

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.

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

 

[Yetisteven]

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.

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

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]

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:

   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:

   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. 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)