PEQ Source schema.sql and expansions.sql Solution
 

This is for any others that run into this issue and the solution isn't in google or found on the forums.

From an absolute clean install of EQEmu on a clean server the mysql commands in MariaDB console may fail for you.

I solved it by
Open HeidiSQL and open your peq database
Now Open/Import the sql file by going to
File > Load SQL file > "your_path_to_schema.sql"
it will load the sql contents, then Execute the SQL by pressing the blue 'play' button.

Do the same for expansions.sql

That solved it for me and PeQ is working like a charm. Hope somebody else may find this useful.

Just curious, I've been doing fresh installs for several years, but I have never seen those file names:

your_path_to_schema.sql and expansions.sql

Where did you get those from ? The current PEQ does not come with them.

http://db.projecteq.net/latest

The DB Editor

Sorry Huppy, it's the db editor.

Ya, I guess everyone has their own preferences for utilities/apps for editing the database. I've never used the common db editors, so it makes communication a pita sometimes, lol