November 2018
Intermediate to advanced
460 pages
14h 1m
English
MySQL drivers can be installed with the following command:
(v1.0) pkg> add MySQL
Since version 8.0, MySQL uses a new authentication mechanism that is not yet supported by Julia's MySQL package. In order to be able to work with MySQL 8.0, you need to do two things:
The MySQL configuration file on Windows is found in the home data directory (for example, C:\ProgramData\MySQL\MySQL Server 8.0\my.ini), while on Linux it can usually be found at /etc/mysql/mysql.cnf. In this file, find the default_authentication_plugin parameter and set it to mysql_native_password:
default_authentication_plugin = mysql_native_password ...Read now
Unlock full access