I have just set up a Minecraft and MySQL server, both are on the same server and everything works. I was able to connect to HeidiSQL and phpmyadmin from the outside, but when I did a plugin on the server that made this connection also needed, said the MySQL connector Access denied for% user% @ localhost (Using Password: YES), I've already set everything up like this. At the beginning the encryption procedure was out of date, which I had solved by setting the mysql_native_password plugin. Here is some information:
-------------------------------------------------- -------------------------------------------------- -----------------------------
jdbc uri: "new Connection (" jdbc: mysql: // localhost: 3306 /% database% ",% username%,% password%);"
MySQL version 8.0.20-0ubuntu.20.04.1 || php7.4.7
On Ubuntu 04/20
Minecraft server: PaperSpigot 1.8.8
Have you entered all the necessary data in the plugin, such as DB name, username and password? Aso the data that you assigned when creating the DB.
Jdbc uri: "new Connection (" jdbc: mysql: // localhost: 3306 /% database% ",% username%,% password%);"
You entered half the Java code. Of course, that doesn't work.
Only this part is the jdbc-uri:
jdbc: mysql: // localhost: 3306 /% database%
Yes, I checked it several times and it still didn't work, I even tried to change the plugin, but that was also unsuccessful,
PS. Stay healthy too.
