If you are unable to connect to an older MySQL version (5.7 or before) with the newer MySQL workbench 8, these steps might help you:
Cannot Connect to Database Server
You were able to connect to MySQL (version 5) before until you installed the latest version of MySQL Workbench
“The associated secure_auth option was enabled by default as of MySQL 5.6. It is always enabled as of MySQL 5.7, meaning it can not be disabled. A future MySQL release will remove this option. With this option enabled, a user with a password defined in the old format will not be able to login to MySQL.” According to MySQL
Visit this page for more information : https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-secure-auth.html
1. Close any MySQL Workbench instance
2. Download an older PORTABLE version of MySQL Workbench here:
(Version 6.3.7 or slighly below should work fine)
Note that I said PORTABLE (The ZIP Version) not the installer one.
There is no need to install an older version of MySQL Workbench.
Just run the portable version and you will be in business.
Why does LOAD_FILE returns null?
According to the MySQl manual, these rules must be followed:
- The file must be located on the server host
- You must specify the full path name to the file
- You must have the FILE privilege
- The file must be readable by the server and its size less than max_allowed_packet bytes
- If the secure_file_priv system variable is set to a nonempty directory name,
the file to be loaded must be located in that directory
Don’t just move the file to /tmp and expect mysql to find it, in our case the the “secure_file_priv” was set to non null value (see below)
The files needed to be saved to “/var/lib/mysql-files”
You can always change this location in you MySQL config file.
Once we moved the file to the location indicated in “secure_file_priv”, we were able to load the files:
manual-auth-hook command "/etc/letsencrypt/acme-dns-auth.py" returned error code 1
Error output from manual-auth-hook command acme-dns-auth.py:
Traceback (most recent call last):
File "/etc/letsencrypt/acme-dns-auth.py", line 4, in
File "/usr/local/lib/python2.7/dist-packages/requests/__init__.py", line 113, in
from . import packages
File "/usr/local/lib/python2.7/dist-packages/requests/packages.py", line 7, in
locals()[package] = __import__(package)
ImportError: No module named idna
The issue is caused by the “acme-dns-auth.py” using the wrong version of Python.
First make sure that you have the prerequisite installed:
apt install python3-pip
Open the “acme-dns-auth.py” file and update the first line to look like:
Now run the renew script
The best way to handle this issue to download the source code and install it from the command line:
- Download the source code:
- Extract the files, navigate to the folder and run the update script:
tar -xvf xi-5.7.4.tar
Before you enable SNMP in PHP 7, you first need to make sure that you have the proper SNMP packages installed on the Ubuntu System.
Install the SNMP packages
sudo apt-get install snmpd snmp libsnmp-dev
Before you install the PHP package, make sure you download and install the following package:
apt-get install snmp-mibs-downloader
This package will help translate OIDs into human readable strings
Now you can install the php extension.
apt-get install php-snmp
Then restart the followings:
service snmpd restart
service apache2 restart
Service nginx restart
Install and Manage MIBS file