mysql step of webatrice setup

[lean olive]

Hey all, I apologize, because I know this is likely a simple fix, but I've never setup a server or anything like that

It seems when I get to this point (img 1) A syntax error pops up

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 'mysql -u servatrice -pBUG servatrice < servatrice.sql
use servatrice' at line 1

I'm not entirely sure why this would happen. I copied the code directly, only replacing the necessary parts.
Is there something that I'm missing here?

[grizzled radish]

Sounds like you're running it as a single command

First run mysql -u servatrice -pfoobar servatrice < servatrice.sql in the console

Once you're in the MySQL command line interface, run the other two commands

Make sure you're in the directory that contains servatrice.sql

[lean olive]

I realized now that I wasn't running the command you said from the command line, and that's one issue down. However, now there seems to be another issue. When running the command, I made sure that it was in the correct directory, but it only spat back that "mysql is not a command"

[grizzled radish]

Then you need to install MySQL. That's its own program. You can get it at https://www.mysql.com/. But if I may ask, why are you trying to set up your own server rather than using one of the public ones?

[lean olive]

The only thing I’d really use it for is for doing a draft of a custom set I made with 8-10 or so of my friends at some point. I realized after I started working on this that there were public servers, but I’m fairly invested in doing this now if not to just say I did it lol. I do already have MySQL downloaded (version 8.0.35) ran the first few lines on the setup through MySQL command line client then tried to run the line that populates the tables in the cmd line (not MySQL cmd line client) and you saw the error above

I appreciate the help through this so far by the way!

[grizzled radish]

Looks like the command isn't set up in Windows installations. Check this guide: https://dev.mysql.com/doc/mysql-windows-excerpt/8.0/en/mysql-installation-windows-path.html

Full disclaimer: I haven't tried it myself. But it looks like it should work

Nevertheless, be careful when editing the PATH variable. Make sure you're not deleting anything form it

Alternatively, install the server on a Linux virtual machine instead. It should make the process a lot smoother

[molten fable]

in that case a database is completely unneeded, you can set up a server with the default settings of servatrice, simply open up a command prompt and run servatrice and it will start the server, people on your local network will be able to connect to your server using your local ip address and port 4748 using any username and without passwords

[lean olive]

I should mention that most of my friends are very far away, so unfortunately a local solution wouldn’t work for me. As long as I’m understanding what you’re saying here

[lean olive]

Editing PATH so that it would execute the MySQL as a command worked great! I ran out of time yesterday to work on it more, but the rest of the steps seem pretty simple from my understanding

If I come across more issues, I’ll just do what you recommended and try a vm for the server before bugging y’all again

[grizzled radish]

In that case you should first make sure that your router and ISP support port forwarding. And second, if it's a good idea to open a port in your home network in the first place. I don't mean to scare you because in the end it's a fairly normal thing to do, but it's in the realm of "do it only if you know what you're doing"

[lean olive]

Ahh, yes I had set up port forwarding for a past project! Seemed to work fine there : ) (Multiworld OoT randomizer was a blast)

[molten fable]

a database isn't going to do port forwarding, you will have to do this regardless if you want to have them join the server