how can i create a right user in xampp's mysql to communicate with my program on the VPS

Question

recently i create school project which was web app that has tomcat as server and use mysql database, it work properly in my local system but when i want to run it on my vps, i get this error:

the err

i had the same problem when i try to clone my project to my friend's computer, and we solve it by create the user (admin@localhost) by phpmyadmin in his computer, but i cant solve this problem when i create user in my vps's phpmyadmin.

this is my app's property to connect to DB:

jdbc.driverClassName = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/normalizedDB
jdbc.username = admin
jdbc.password = admin
hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.show_sql = false
hibernate.format_sql = false

and this is my db on xampp and the open ports at my vps:

info

plz tell me how can i create that 'admin' user

I added this lines separately to my.cnf to handle all ipv6 things and give all priviledge to admin@localhost but still tomcat says 'HTTP Status 500 Could not open connection' and i have to say that my db has data too ...

bind-address="127.0.0.1"
bind-address = ::1
bind-address = ::
bind-address = 'localhost'

Answer 1

Doube colons " :: " are for tcp6 , that is IPv6. For a IPv4 there will be only one colon before port " : ".