w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Permission granted mysql user cannot access the particular database Caused by: java.sql.SQLException: Access denied for user

Unless the password is also "user1", you are using the grant syntax incorrectly: The identified by parameter is for the password (not the username).

Try this:

grant all on mydb.* TO 'user1'@'localhost' identified by
'mypassword'




© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.