The MYSQL engine cannot be found

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

The MYSQL engine cannot be found

 

I am very new to SAS, but otherwise very experienced in computing.  I'm using a 5 year old MacBook Pro running El Capitan.  I installed Oracle VirtualBox and started the free SAS University Edition on it.  I have mariadb (the now open source version of MySQL) installed locally via MacPorts.  I can use mysql from the command line without issue.  I am trying to simply connect SAS to a database, any database at this point, just to prove that it can be done.

 

I have tried many versions of the following one-liner with and without some of the options

 

libname mysqllib mysql user=root password="" database=mytestdb server=localhost;

 

from the example in

 

https://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002913931.htm

 

but I always get the same error in the log.

 

ERROR: The MYSQL engine cannot be found.
ERROR: Error in the LIBNAME statement.
 
I've searched online and can't find a solution.
 
Do I need to set some environment variable?
Does the free version not include something that I need here?
Is SAS not compatible with the MariaDB version of MySQL?
Do I need to install something else?
Do I need to tell SAS where it can find the MYSQL engine?
Is this a VirtualBox issue?
 
Thank you in advance.
Jake

Accepted Solutions
Solution
‎10-13-2015 03:52 PM
Respected Advisor
Posts: 3,063

Re: The MYSQL engine cannot be found

[ Edited ]

I suspect that the SAS/ACCESS to MySQL product is not in SAS University Edition.

 

Run PROC SETINIT to confirm the products available:

 

proc setinit noalias;
run;

View solution in original post


All Replies
Solution
‎10-13-2015 03:52 PM
Respected Advisor
Posts: 3,063

Re: The MYSQL engine cannot be found

[ Edited ]

I suspect that the SAS/ACCESS to MySQL product is not in SAS University Edition.

 

Run PROC SETINIT to confirm the products available:

 

proc setinit noalias;
run;
New Contributor
Posts: 3

Re: The MYSQL engine cannot be found

Original site validation data
Current version: 9.04.01M3P062415
Site name: 'UNIVERSITY EDITION 2.2 9.4M3 WITH ETS FOR PLAYER'.
Site number: 70186327.
CPU A: Model name='' model number='' serial='+2'.
Expiration: 15JUN2016.
Grace Period: 0 days (ending 15JUN2016).
Warning Period: 46 days (ending 31JUL2016).
System birthday: 02JUL2015.
Operating System: LIN X64 .
Product expiration dates:
---Base SAS Software 15JUN2016 (CPU A)
---SAS/STAT 15JUN2016 (CPU A)
---SAS/ETS 15JUN2016 (CPU A)
---SAS/IML 15JUN2016 (CPU A)
---SAS/ACCESS Interface to PC Files 15JUN2016 (CPU A)
---SAS/IML Studio 15JUN2016 (CPU A)
---SAS Workspace Server for Local Access 15JUN2016 (CPU A)
---SAS Workspace Server for Enterprise Access 15JUN2016 (CPU A)
---High Performance Suite
 
I presume then that "SAS/ACCESS Interface to PC Files" does not include access to a MySQL database.  Bummer.
 
Thank you.
Esteemed Advisor
Posts: 5,198

Re: The MYSQL engine cannot be found

Generally, it might work with MariaDB, but SAS would probably not support this.

When it comes to the University Edition, I don't see MySQL in list of ACCESS engines included,

 

http://support.sas.com/software/products/university-edition/index.html

Data never sleeps
New Contributor
Posts: 3

Re: The MYSQL engine cannot be found

This seems to be the case.  Thank you.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1214 views
  • 0 likes
  • 3 in conversation