MySQL v8 allow remote access.

In version 8 the grant option to allow remote access no longer works and you will get syntax errors if you try to execute that command.

This is what you can do:

• Create the root user (yes, a new user because what exists is ‘[email protected]’ which is local access only):CREATE USER 'root'@'%' IDENTIFIED BY '123';
• Give the privileges:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';