Database Configure in DBreaver

[Debasish_das]

Hi Team,

I want to attach my vici database with dbreaver application. I Already created a root user in the database, But when I enter these credentials it shows the below error.


(conn=37169) Access denied for user 'admin'@'192.168.1.10' , Please help me with this.

[basha04]

This seems like a database connection issue. What does the following command

Code: Select all

select user,host from mysql.user

outputs ? Does the user exists ?

And if the user exists what does the

Code: Select all

show grants for admin@'192.168.1.10';

outputs ?

[carpenox]

did you add permissions to that user to the "asterisk" database?

[williamconley]

Generally we just use the cron user which is already fully accredited for "everything Vicidial" on the asterisk database. But adding a fresh user is actually very good for security. Just have to be sure they are added with the proper IP and have "grants" necessary for the task at hand. Also very good (if possible) to test access from the CLI of the new client before trying in software to validate that the IP / user combo actually has access before taking on the additional complexities of configuring the 3rd party software's MySQL interface(s).

[Debasish_das]

Thanks williamconley it's solved.. By your help.. Thanks again