I created phpmyadmin on my vServer. I also come in normally via the browser, but when I enter the database into a minecraft plugin, it can't connect. I have googled everywhere but can't find anything helpful
User created? Login for this released? Is the Minecraft server local?
The mc server is on a Vserver
By default, MySQL can only be reached via localhost. I.e. The connection to the database is not possible via the network. So you have to configure that accordingly. This is e.g. Described here:
https://www.sysadminslife.com/linux/quicktipp-mysql-externer-zugriff-erlauben-bind-address/
I just created another user and then specified the name as a user in the config in the case of the database but it is still there can't connect to the database
Okay i will test
Cnf file, when I double-click on it, I come to another directory but I can't set the IP there
Does the user also have the right to log in?
CREATE USER 'user' @ 'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON myDB. * TO 'user' @ 'localhost';
FLUSH PRIVILEGES;
To view the permissions
SHOW GRANTS FOR 'user' @ 'localhost';
Oh yes, of course this relates to the MySQL shell:
mysql -u root -p
I did it like this but I have the problem that the mysql server no longer starts now it says: Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
I can't look it up right now because mysql doesn't start mher it now says:
Job for mysql service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
The error doesn't come back now but i still can't register online
Then you have a syntax error inside. Don't write the [bash] and [/ bash] by the way. This is a display error on the page
Should I send you files?
As you can see, the user I mentioned is for 'localhost', which should be enough for a service that runs on the computer. Instead of localhost you can of course also share other 'servers' or IPs / domains… Or, really bad, for everything / world with *
