mysql> CREATE USER 'My-new_user'@'localhost' IDENTIFIED BY 'passwd';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'My-new_user'@'localhost' WITH GRANT OPTION;I managed to do it by successfully creating a new user and giving it privileges.
The problem with the first attempt with this technique was bad writing, I missed the asterisks between the .
Do not waste time trying to give root access directly, for me it was impossible, I needed to create a new user as indicated above.
The problem that users will have to log in to each database they have remains unresolved and this is undoubtedly the worst.
Not to mention the impossibility of reusing users-db.
I will continue investigating ‘by myself’