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:
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:
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'