RMySQL troubleshooting in Ubuntu

RMySQL package installation is no longer as easy as it used to be with the previous versions. The simple install.packages("RMySQL") no longer works like a magic!
If you try this command on your latest R version, you are likely to get the following errors:

Configuration error:
"could not find the MySQL installation include and/or library directories. Manually specify the location of the MySQL libraries and the header files and re-run R CMD INSTALL."

I have found the solution to this problem. You can also try this and see if your problem is being solved.

Some simple steps are:

Get mysql-connector-c-6.0.2-linux-glibc2.3-x86-64bit from this link here
Un-tar the contents in your downloaded folder.
There you will get two folders- 'library' and 'include'.
on your /usr/local/include folder you will need to copy the contents of the 'library' and 'include' folder (copy the contents in the 'include' and 'library' folders respectively).
inside your /usr/local/include folder, you will need to make a new directory "mysql" and there need to run the following commands:

cp -R '/home/username/Downloads/mysql-connector-c-6.0.2-linux-glibc2.3-x86-64bit/include/.' '/usr/local/lib64/R/include/.'
cp -R '/home/username/Downloads/mysql-connector-c-6.0.2-linux-glibc2.3-x86-64bit/lib/.' '/usr/local/lib64/R/lib/.'

After this, try the command R CMD INSTALL MySQL_0.9-3.tar.gz (or whichever version you have downloaded.
After all of these processes are done, switch to your R console and try library(RMySQL). If you get the "Loading required package: DBI", your job is done!

Notes:

You will need to install these other packages as well:

sudo apt-get install r-cran-rmysql
sudo apt-get install r-cran-dbi

Hope this helps. If there are errors in this or if you have a better solution to this, please share that in comments.

Comments

Equality and Equity: A Journey That Starts at Home, Beyond the Workplace!

In 2023, during the celebration of International Women's Day, I encountered the notion of " Equity " for the first time. Initially, its significance in a woman's daily life didn't strike me profoundly. However, over the past year, I've been continually reminded of its relevance on numerous occasions. Discussions around workplace Diversity and the concerted effort to elevate the presence of women in organizations, especially in leadership roles, have gained traction globally. While commendable, there's a touch of irony in this commendable endeavor. The very men who wield decision-making power in organizations, shaping policies to foster inclusivity and gender balance, often seem to leave the concept of equality at their home doorstep. As they enter their domestic realm, they discard the notion of equality as if shedding a coat, anticipating their wives to effortlessly shift from their professional roles into the responsibilities of a homemaker. It's imp...

A lot can happen over coffee....only if you are allowed to sit at a CCD outlet!

Cafe Coffee Day is no more a new name for the youngsters in India. For a warm cup of coffee at an affordable price, thats where we generally go to! But more than the cup of coffee, its the atmosphere of Café Coffee Days which attracts all of us. An informal setup...good beverage and snacks...soothing music (most of the time)...complimentary wi-fi (at many outlets)...well, CCD always had a lot to offer its customers. Photo source - https://www.zomato.com/pune/cafe-coffee-day-2-koregaon-park For Siddhartha, coffee always used to be an experience to be offered...not just beans to be grown. I have had my job interview conducted at a CCD outlet. I have hosted and attended several community meetups at different CCD outlets across the country. I have even had my coffee dates at CCDs. Well, truely, a lot has happened in my life over coffee...at different CCD outlets. Once, Siddhartha himself had spent his new year's eve, serving customers at a Café Coffee Day (CCD) outlet near C...

RASCI model - the responsibility assignment matrix

In the last few days, both at my workplace as well as while dealing with a few activities around me, I have realized the importance of implementing a better responsibility assignment matrix, to get things done in a less messed up way. A few months back, during some random conversation, a friend of mine had introduced me to the RASCI model, one of the responsibility assignment matrices. Wikipedia says that the responsibility assignment matrix 'describes the participation by various roles in completing tasks or deliverables for a project or business process.' In simple words, for any project, if we can divide each person's role and responsibility, it not only ensures a better end product, but also saves the time, otherwise lost in discussions (which organizations like to call as meetings). A RASCI implementation ensures that each person is responsible for only and only the task assigned to him (or her) and will not need to interfere with another person's task, un...

Priyanka's Scrapbook

Search This Blog