Topic: MySQL and root user privileges

[cactus]

I followed these instructions step by step, twice.
As might delete the root user of MySQL?, In order to recreate it.
How might to assign all privileges to root user?
As could create another user with sufficient privileges to give privileges to root user?

They should work. Do you receive any error messages or pointers when trying the instructions?

[d_loayza]

cactus wrote:

They should work. Do you receive any error messages or pointers when trying the instructions?

No error, all instructions are executed cleanly.

[CharlieBrady]

I followed these instructions step by step, twice.

Please open a bug report, showing exactly what commands you are running and what the result is.

[d_loayza]

Talking to my associate, I remembered that long ago had created a user named "webmaster" with privileges on all databases.

I ejecute  the following commands to restore the situation:

a) mysql --user=webmaster --password=xxxxxxxxx
b) grant all privileges on *.* to 'root'@'localhost' with grant option;
c) use mysql;
d) grant all privileges on mysql to 'root'@'localhost' with grant option;

I will open a detailed report to explain what happened to me, it seems the scripts to restore the root user  does not work correctly.

Sincerely grateful for taking the time to solve my problem.