Could not open JDBC Connection for transaction. Access denied for user 'root'@'localhost' on Linux VPS

Asked Aug 17 '20 at 03:36

Active Aug 17 '20 at 03:36

Viewed 166 times

I'm setting up my Spring MVC project on a Linux VPS. My project works fine on my home PC, but on the VPS it cannot connect to database. This is my datasource config file inside the project:

# DataSource 
ds.database-driver=com.mysql.jdbc.Driver
ds.url=jdbc:mysql://localhost:3306/myData?useUnicode=yes&characterEncoding=UTF-8
ds.username=root
ds.password=password

Everything is the same as the MySQL infomation on the VPS. I only deployed the war file and run, didn't do anything else.

asked Aug 17 '20 at 03:36

Quân Đặng

Have you tried to connect to mysql in command line on your vps? – spike 王建 Aug 17 '20 at 04:52
Wrong username or password, but you shouldn't be using the root login for anything except DB administration/ – user207421 Aug 17 '20 at 06:44
i found the solution here of user Ashu: https://stackoverflow.com/questions/11922323/java-sql-sqlexception-access-denied-for-user-rootlocalhost-using-password – Quân Đặng Aug 17 '20 at 06:44

Could not open JDBC Connection for transaction. Access denied for user 'root'@'localhost' on Linux VPS

0 Answers0