Problem with creating user for mysql cluster

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hello,

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
2

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/caching_sha2_password.so: cannot open shared object file: No such file or directory

1 Like
3

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