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;
This commands will allow full access user to all databases.