R Programming By Example

Dependencies for the RMySQL R package

Chapter 4, Simulating Sales Data and Working with Databases, has an execution dependency on MySQL databases. This means that the RMySQL R package can be installed just fine without having a MySQL database in the system, but when R uses it to interface to a MySQL database, you must have one available and running with an appropriate configuration, otherwise you will run into errors.

Now I will show you how to install the MySQL Community Database, in both Ubuntu 17.10 and macOS High Sierra. During the installation, you may be asked for an optional username and password, and if that is the case, you should take the opportunity and actually specify these instead of leaving it blank since we will need actual ...