MySQL User Privileges

1

Hi,
I did drop root user. After new create root user, but the user not yet privileges.
Example it isn’t not create new user. How can ı this error?

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'passwpord';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
mysql> GRANT GRANT OPTION ON *.* TO 'root'@'%';
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
mysql> FLUSH PRIVILEGES;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
mysql>
2

Hi @parttime .

Could you share the MySQL version, and how the user was dropped?

Also, is this a new MySQL installation, do you have other users created in there?

Finally, using this guide might help you (It’s for resetting a root password, which is not directly your case, but due to the errors it might help: https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html).

Please try it, should it not work, share more details about the current situation.

Best,
Mauricio.

3

This error. How we can resolve the stitation?

mysql> GRANT ALL PRIVILEGES ON . TO ‘user’@‘%’ WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user ‘root’@‘%’ (using password: YES)