MySQL database for Minecraft servers?
Hi,
I recently set up a MySQL database on a computer at home. Now I'm running a Minecraft server on another computer. Both computers are on the same network. I installed Luckperms on the Minecraft server. I wanted to link it to the MySQL database. I entered all the information correctly, but I keep getting the same error:
xxxxxxxxxxxxx = The computer on which the Mc Server is running.
Host 'xxxxxxxxxxxx.fritz.box' is not allowed to connect to this MySQL server
(1 votes)
Loading...
should already tell you that you have only given local permissions that are not valid when accessing another device when you assign rights to the SQL server.
So check the access rights of the user account used (in the MySQL database) again and supplement that that not only@localhost is permitted there.
It is regulated in the database by which connections a user may log in, you must set the user accordingly so that the Minecraft server can connect to the database via the network.
https://stackoverflow.com/questions/14779104/mysql-how-to-allow-remote-connection-to-mysql
However, you should only assign the rights that are required and limit the connections to IPs that are controlled by you.