hi there,
recently someone pointed out to me that it was not possible to add
a mysql-user that was previously removed by directadmin.
when a regular da-user goes to his "Main Menu"->" Mysql Management" -> "
choose a database" ->"select an user" -> " push the Delete Selected button"
in that case the user being deleted is not the only one user of this database,
there are more users to choose from.
and after that regular da-user tries to create a user with the same username and directadmin fails with " error user already exists", while the removed user is not visible in the 'user overview' for a selected database.
when i look in the phpMyadmin in the Mysql directly i see that the
grant privileges are removed from the 'schema_privileges' table but
not from the 'information_schema:user_privileges' table, and not
from the 'mysql:user' table.
after manual removal of the user priveliges, ( in phpMyAdmin->user privileges->reload privileges) user can be created
again through the directadmin webinterface.
is there any solution to this ?
thanx in advance.
fmg_im
recently someone pointed out to me that it was not possible to add
a mysql-user that was previously removed by directadmin.
when a regular da-user goes to his "Main Menu"->" Mysql Management" -> "
choose a database" ->"select an user" -> " push the Delete Selected button"
in that case the user being deleted is not the only one user of this database,
there are more users to choose from.
and after that regular da-user tries to create a user with the same username and directadmin fails with " error user already exists", while the removed user is not visible in the 'user overview' for a selected database.
when i look in the phpMyadmin in the Mysql directly i see that the
grant privileges are removed from the 'schema_privileges' table but
not from the 'information_schema:user_privileges' table, and not
from the 'mysql:user' table.
after manual removal of the user priveliges, ( in phpMyAdmin->user privileges->reload privileges) user can be created
again through the directadmin webinterface.
is there any solution to this ?
thanx in advance.
fmg_im