Problem with creating user for mysql cluster


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

1 Like

Now when i try to access from remote server to the database i get this error.

ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/ cannot open shared object file: No such file or directory

1 Like

GRANT ALL PRIVILEGES ON DataBaseNAME.* TO "DatabaseUser"@"%" IDENTIFIED BY "Password";

Use “%” to represent any IP.

The caching_sha2_password issue means that whatever language/library you are using is not upgraded to use MySQL 8 passwords. You either need to upgrade your language, or use this syntax:

IDENTIFIED WITH mysql_native_password BY "Password"

1 Like