mysql - Granting access to database without knowing the password -


Then, there is a grant query for a user to provide access to a database:

 < Validate all private on code> Dbname. * To debug @ @% 'accredited by' Dbpasswd '; Now, the problem with our system is that we do not know the database password and can not reverse engineer because it is a hash. Is it possible to clearly define the privilege without knowing the database password?  

The current system is very complex, also to find out where the database configuration file is located and working on it for days has not resulted in any results actually appreciate some help.

PS: What is the privilege in the user table in mysql database? There are: Select_priv, Insert_priv, Update_priv, Delete_priv but they are defined per user, not on database basis.

Do not use the just identifier ... section, this will not change the current password.

In the "user" table, select_priv, Insert_priv, Update_priv, Delete_priv indicate that the user has these rights on all the databases (otherwise, these columns are defined in the "DB" table in Y)

Comments