Error 1064 (42000) with create_mysql.sql script

Hi, im in the process of building the Mysql DB for the server ( Master Branch ) on Linux Ubuntu 17.10

i am using ssh to manage the server and so i use CLI to mange the Database. I pulled the " create_mysql.sql" script from the github page by using


i launched my mysql CLI client with
“:mysql -uroot -p” and attempted to run the script with “@create_mysql.sql” and it returned :


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘@create_mysql.sql’ at line 1

is it possible the script is broken ? or did i miss something ?..again. Thanks for your help and input.

also once i get it working, where am i suppossed to execute this script and unpack the TDB_FULL datbase. ?
in ~/TrinityCore/sql/base
or ~/server/bin

Not sure where you found this way of executing a file by using “@create_mysql.sql”, but it is not how the manual seems to say it works.

As you may see you should be using “mysql -uroot -p < create_mysql.sql”

its the Oracle way of calling scripts…Thanks for the correction.

where shoudl i run this script tho, does it matter ? i dont think it does, but i wanna be sure


Thanks, i got it working and finalised my installl.

now i have to set up the client on my Windows machine. I was wondering if there was a way to only compile the connection patcher for the client since it seems to be the only thing i need to get it running.

isnt there a command in the makefile like : Make connectionPatcher or something, because it seems like a hassle to build the whole core and tools if im only going to use the connection patcher. 

or is there somewhere i can simply download the tool ?

you can compile only tools, witch includes connection patcher.