Access denied for user (using password: YES) - When trying to connect with Database MySQL

[Jijo_Raj]

Hi,

I am trying to integrate 3CX with Database MYSQL. But it says Access denied for user. I tried creating a new user and then assign it to the database, But still i get the same error.

Can someone help me on this!


Thanks in advance

 

[Evolute IT]

Hi,

I am trying to integrate 3CX with Database MYSQL. But it says Access denied for user. I tried creating a new user and then assign it to the database, But still i get the same error.

Can someone help me on this!


Thanks in advance

Did you allow the host "@" or a specific IP? MySQL can block based on source.

 

[Jijo_Raj]

Can you please advice me on how to Allow "@"

 

[Evolute IT]

Can you please advice me on how to Allow "@"

How do you manage your MySQL users? PhpMyAdmin or Workbench?

 

[Jijo_Raj]

PhpMyAdmin

 

[Evolute IT]

When you create the user, you have the Host option. You can choose anything in the field.

 

[edossantos]

Access denied means that the user logged in, but doesn't have access to the table you want to query. This is a permissions issue that you need to fix in your MySQL server...

 

[Jijo_Raj]

Okay, Can i connect with my localmachine(XAMPP) and complete the integration. So i can request for the Mysql Permission later.

Kindly help me to connect with my local machine.

when i try to connect it says " Unable to connect to any of the specified MySQL hosts."

 

[edossantos]

Do you have a MySQL server installed in the 3CX Server? The location of the database will not make any difference... I'm not sure to understand what you're trying to do here...

 

[Jijo_Raj]

Hi,

I have no Mysql Server installed.

I am trying to integrate 3cx with my phpmyadmin database(MySQL).

 

[edossantos]

For any MySQL database you should follow this guide:
https://www.3cx.com/docs/sql-database-pbx-integration/

Are you having any issue with that? In that case, provide details, logs, etc.