Mysql – i cannot install thesql plugin keyring_file.dll

innodbMySQLwamp

I have been trying to install the keyring_file.dll of MySQL 5.7.26 plugin from WAMP 3.1.9 without success. It keeps me telling in the CMD Prompt:

ERROR 1123 (HY000): Can't initialize function 'keyring_file'; Plugin initialization function failed.

…and the MySQL log states:

[ERROR] Plugin keyring_file reported: 'File 'C:/Program Files/MySQL/MySQL Server 5.7/keyring\keyring' not found (Errcode: 2 – No such file or directory)'

Could somebody help me figure out what the root cause is?

Best Answer

The reason for that error is that mysql can't locate the keyring_file.dll file.

To fix that do the ff:

Edit the my.ini file located in C:\ProgramData\MySQL\MySQL Server 5.7\ and add the ff in the [mysqld] block:

early-plugin-load=keyring_file.dll
keyring_file_data=C:/Program Files/MySQL/MySQL Server 5.7/lib/plugin/keyring_file

Restart the MySQL service:
```
net stop MySQL57
net start MySQL57
```

Validate that the keyring plugin is now active:

SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'keyring%';

Related Solutions

Mysql – Connecting to MYSQL on an EC2 instance

Since Zapier is coming in from outside your instance, a possible cause of your problem is the security group for your instance. Most ports on EC2 instances (except the SSH port) are normally blocked by default unless you explicitly open them.

So you would need to open the mysql port 3306 on your instance up to the ip address Zapier is coming in from. (preferably you would not open it up to everyone in the world.)

See Using Amazon RDS/EC2 on the Zapier site, starting from the section where it says Can't Connect to My Database. They continue on to provide specific instructions for the security group settings.

You will also probably need to grant permission on the database using the mysql GRANT command to the user coming in from the Zapier ip address.

Something like this should work :

GRANT ALL PRIVILEGES
ON mydb.*
TO 'user'@'54.86.9.50'
IDENTIFIED BY 'newpassword';

Or you can allow that user to come in from any ip adress like this:

GRANT ALL PRIVILEGES
ON mydb.*
TO 'user'@'%'
IDENTIFIED BY 'newpassword';

(Incoming requests would still be limited to Zapier ip addresses due to the security group settings.)

Mysql – wordpress site kills thesql

"Nov 11 09:05:14 localhost kernel: [ 5931.834129] Out of memory: Kill process 6761 (mysqld) score 233 or sacrifice child"

You are crossing system memory and then kernel is killing highest user of memory - in your case that'd be mysqld. Consider revising mysql global and per-thread variables in order to limit total usage under control. You may use this procedure to estimate MySQL memory usage or you might want to fill in here to check the usage details.

Also... Swapping is not good for MySQL, it's better to have swappiness set to 1-10 or 0 depending on your kernel version. Refer here.

Best Answer

Related Solutions

Mysql – Connecting to MYSQL on an EC2 instance

Mysql – wordpress site kills thesql

Related Question