How to register a new user with the full administrative rights in MySQL

[dmitrii_fediuk]

CREATE USER 'dfediuk'@'localhost'
GRANT ALL PRIVILEGES ON * . * TO 'dfediuk'@'localhost'