I’ve cluster install on version 8. Now i’m trying to install wordpress and need to grant all privilage the same as old version.
Old version i was using:
GRANT ALL PRIVILEGES ON DataBaseNAME.* TO “DatabaseUser”@“localhost” IDENTIFIED BY “Password”;
Now its not supported this way.
And the main problem that i need to grant it for any IP address, not only localhost.
The old version i was using databasename@’%’ instead of databasename@'localhost
Thanks in advance