Error PHPMyAdmin remote mysql

[icarohenrique]

Helo!

I'm trying to implement a remote database server in Direct Admin.

I followed all the documentation and it worked. In tests, when I create the database, it is created in the remote database.
However, when I go to PHPMyAdmin (which was also configured according to the documentation) it doesn't work.

In the PHPMyAdmin logs, the error that happens is:

Jun 29 17:28:59 phpmyadmin: user denied: da_sso_K0xTyCFTi (mysql-denied) from 186.206.209.229
Jun 29 17:39:02 phpmyadmin: user denied: da_sso_nldDSTdth (mysql-denied) from 186.206.209.229
Jun 29 17:47:32 phpmyadmin: user denied: da_sso_nldDSTdth (mysql-denied) from 186.206.209.229
Jun 29 17:47:55 phpmyadmin: user denied: da_sso_jxNKeNaGP (mysql-denied) from 186.206.209.229
Jun 29 17:50:16 phpmyadmin: user denied: da_sso_zwCbCN9LC (mysql-denied) from 186.206.209.229
Jun 29 17:52:12 phpmyadmin: user denied: da_sso_cW1dz2xKx (mysql-denied) from 186.206.209.229
Jun 29 17:57:40 phpmyadmin: user denied: da_sso_R6OumB5ik (mysql-denied) from 186.206.209.229
Jun 29 18:13:55 phpmyadmin: user denied: da_sso_nCNwMzpQy (mysql-denied) from 186.206.209.229

When I check the users created in the remote database, the user with the source server IP has no password:

IP User authentication_string
| localhost | da_sso_WL1XqjhAB | *D0BF48BD79246542EC413F3656DAAEACB0A40D64 |
| 172.26.xx.xx | da_sso_WL1XqjhAB | |
| localhost | da_sso_rraxbMVJz | *35033D75CEE5892136A2BBED9FD8BF8AAC0F215E |
| 172.26.xx.xx | da_sso_rraxbMVJz | |
| localhost | da_sso_qMOMuVv26 | *49FD1BB8E6A66738C895C954E32686792F431190 |
| 172.26.xx.xx | da_sso_qMOMuVv26 | |

(172.26.8.24 = IP local)

Have you ever gone through this problem?

 

[factor]

Can you post a link to the doc you followed.

I dont think SSO works on remote database servers.

 

[icarohenrique]

Helo!

I ended up discovering the problem.

The problem was in the remote database and the mysql_native_password plugin was not activated.
I made the adjustment and it worked perfectly.

Thanks

 

[factor]

The problem was in the remote database and the mysql_native_password plugin was not activated.
I made the adjustment and it worked perfectly.

good thanks