NOC: 1-843-410-8486

extDB2: Database Exception Error: Connection attempt failed: Access denied for user Print

  • 4

This issue stems from bad permissions, or no permissions for the set user account on the specified database.

Here's an example to create a database and grant all permissions to your user.

create database exile;
CREATE USER 'exileuser'@'localhost' IDENTIFIED BY 'YOURPASSWORD';
GRANT ALL PRIVILEGES ON exile.* TO 'exileuser'@'%' IDENTIFIED BY 'YOURPASSWORD';

Note: Change the % on the grant command to localhost if you only want your database to be accessed locally.

Was this answer helpful?

« Back