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
Super User
Posts: 3,661

Re: The MYSQL engine cannot be found

[ Edited ]
Posted in reply to jakewendt

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
Super User
Posts: 3,661

Re: The MYSQL engine cannot be found

[ Edited ]
Posted in reply to jakewendt

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.
Super User
Posts: 5,771

Re: The MYSQL engine cannot be found

Posted in reply to jakewendt

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 and locked.

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

Discussion stats
  • 4 replies
  • 1916 views
  • 1 like
  • 3 in conversation