ORA-01882 timezone region not found[SQLDeveloper]

If you get the below error when connecting to an Oracle database for the first time, here is a resolution to the problem.

The error basically means your timezone is not among the timezones in the sqldeveloper's timezone configuration.

1. Go to the location where you either installed or copied the SQL Developer.
2. Open the file located at sqldeveloper/bin/sqldeveloper.conf
3. At the end of the file or midway, add the following line: AddVMOption -Duser.timezone=GMT+1
    where "GMT+1" is your timezone.
4. Restart Sqldeveloper and connect to the database, you should have a successful connect.


Update:
using mysqlconnector 8.0.11, a new error now comes up:

"""Exception Message: "The server time zone value 'West-Africa Central Ti' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support."""

To resolve this, login to mysql cosole(workbench) on the server and enter below commands

SET @@global.time_zone = '+00:00';

SET @@session.time_zone = '+00:00';

Attempt reconnection....

Pulled from : https://community.oracle.com/thread/4144569