Cannot create database

[faint pivot]

Anyone have an idea for why that does not work ?

[pearl yarrow]

What is host set to?

[faint pivot]

My fqdn ( sql.mydomain.com)

[opaque jetty]

read up on mysql docs, you need to match the HOST part of the permission with the correct HOST or use a wildcard

[pearl yarrow]

But in this screenshot, you set the host for that account to 127.0.0.1. You'd have to drop the user and make one with the right host (What your panel machine will appear to be from your wings machine's perspective).

[faint pivot]

So if i'm right, when i do ip addr, it show my eth connection wich is the IP of my VPS, a network called pterodactyl0 and docker0.
Wich IP i've to take.

And there is a second question, if i want to setup a minecraft server using bungeecord, i've to take the pterodactyl or docker0 IP too ?

Thanks you for your help

Sorry for my english btw

[pearl yarrow]

Depends what your database will see it as. It's all about the database's perspective. If it's on the same machine and no containers or extra networks are involved it would be 127.0.0.1, if it's two different machines on the same network it might be 192.168.something, etc.

As for BungeeCord, you only need to open the port for that server. All the client servers can stay closed. See #wings-help message

[faint pivot]

I'm not sure I understand correctly.
I have a dedicated server, my panel as well as wings are executed on this same server. My node will also be on this server, what should I understand?

And I edited the file /etc/mysql/mariadb.conf.d/50-server.cnf
I changed bind-address: 127.0.0.1 to 0.0.0.0. Do you consider this operation necessary or does it make my system vulnerable?

[pearl yarrow]

Necessary if you plan to use it as a database host for servers. Just leave the port closed.

[pearl yarrow]

127.0.0.1 was the correct host to use then.

[faint pivot]

Yes, but what i've to put in the host for creating the database, pterodactyl0 IP or docker0 ip ?

And for the mysql, i'll replace with 127.0.0.1

[pearl yarrow]

Neither, 127.0.0.1.