Data Backup and Recovery
Data Backup and Recovery
I'm running SnapCenter 4.3.1 with MySQL plugin 2.0. Setting up two servers, both CentOS 7.8 with MySQL CE 8.0 set to store their data in a folder mounted off a filer using NFSv4. One is working, but the other is throwing me this error when I try to unlock the instance:
I found this KB article: https://mysupport.netapp.com/site/article?lang=en&type=solution&page=%2FAdvice_and_Troubleshooting%2FData_Protection_and_Security%2FSnapCenter%2FSnapC...
However, when I drop the user and re-add it using the referenced commands, I get a number of errors:
mysql> CREATE USER 'snapcenter'@'%' IDENTIFIED BY '<plaintextpassword>';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'snapcenter'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'snapcenter'@'localhost';
ERROR 1410 (42000): You are not allowed to create a user with GRANT
mysql> GRANT ALL PRIVILEGES ON *.* TO 'snapcenter'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> ALTER USER 'snapcenter'@'localhost' IDENTIFIED WITH mysql_native_password BY '<plaintextpassword>';
ERROR 1396 (HY000): Operation ALTER USER failed for 'snapcenter'@'localhost'
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
I'm not very familiar with MySQL, so I'm not sure what I'm doing wrong here...
Solved! See The Solution
Sorry, I forgot to update the thread - since both servers are no with no data in them, one is working and the other is not, I just copied the entire data folder from the one that's working to the one that didn't, and after that, MySQL plugin connected successfully. I will try the solutions offered if I run into this problem again.
Hello,
Starting with MySQL 8 you no longer can (implicitly) create a user using the GRANT
command; At the end of the GRANT command, add the WITH GRANT OPTION at the end of it.
Thanks
Hi,
Can you check the location of mysql datafiles using:
select @@datadir;;
and make sure these files are in netapp ontap volumes.
For the resource group,please make sure you add resource settings with key value pair for:
HOST localhost
PORT 3306
MASTER_SLAVE NO
Sorry, I forgot to update the thread - since both servers are no with no data in them, one is working and the other is not, I just copied the entire data folder from the one that's working to the one that didn't, and after that, MySQL plugin connected successfully. I will try the solutions offered if I run into this problem again.