Cannot add IP to Access host

[Daniel_Dog]

Hello everyone,

I am trying to add a access host to my mysql database so that I can access it externally.
But when I enter my external IPv6 address I get the following error:

UNABLE TO ADD ACCESS HOST:
Error inserting host: The password hash doesn't have the expected format.
Unable to set privileges for ** DA Username **_test on ** DA Username **_test: You are not allowed to create a user with GRANT
Unable to revoke privileges for ** DA Username **_test on ** DA Username **_test: There is no such grant defined for user '** DA Username **_test' on host '** My externam IPv6 **'
Error inserting host: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '** Password hash ?? **' at line 1
Unable to set privileges for ** DA Username **_test_test on ** DA Username **_test: You are not allowed to create a user with GRANT
Unable to revoke privileges for ** DA Username **_test_test on ** DA Username **_test: There is no such grant defined for user '** DA Username **_test_test' on host '** My externam IPv6 **'

The database and the users where creates just before I wanted to add a access host so everything has default settings.

Does anyone know how to fix this?

 

[Daniel_Dog]

This seems to be a bug in DirectAdmin itself.
This only happens when DirectAdmin creates the MySQL user.

One work around I found is to update the password.
This will allow you to add the access host without error/issues.

 

[urgido]

same problem here

Error inserting host: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'zM9fAOBkHU9oTL4hyh.UDuZO.DIM116oP6ndfOdYI2oD'' at line 1
Unable to set privileges for ccfond0s on ccfond0s_prueba: You are not allowed to create a user with GRANT
Unable to revoke privileges for ccfond0s on ccfond0s_prueba: There is no such grant defined for user 'ccfond0s' on host '%'

 

[barite]

I have the same problem, I use MySQL 8.0 version, When I use MariaDB 10.6, I have no error:

Error inserting host: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5Vdk],dZZI9RRDvR2LxoX7xyd17NeAQCli4XtnyKXo9xGXCqurFQU.6'' at line 1
Unable to set privileges for admin_service on admin_service: You are not allowed to create a user with GRANT
Unable to revoke privileges for admin_service on admin_service: There is no such grant defined for user 'admin_service' on host

 

[barite]

This is a bug of DirectAdmin. I hope they can fix this bug.

 

[barite]

This seems to be a bug in DirectAdmin itself.
This only happens when DirectAdmin creates the MySQL user.

One work around I found is to update the password.
This will allow you to add the access host without error/issues.

How to update password? I just tried to change the password but still have the same problem.

 

[barite]

I found out the solution.
You have to change a more complicated and longer password for the database, then it works.

 

[samuelmf]

This seems to be a bug in DirectAdmin itself.
This only happens when DirectAdmin creates the MySQL user.

One work around I found is to update the password.
This will allow you to add the access host without error/issues.

My friend in my case i have around 5 users for 1db, must i update the password for each user to avoid that mysql gran error?

 

[samuelmf]

I found out the solution.
You have to change a more complicated and longer password for the database, then it works.

The additional access host must be set at admin level or at user level?

Thanks in advance