To Create MySQL User with all privileges the below commands should be done in mysql.

 

CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘user’@’localhost’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

 

This commands will allow full access user to all databases.