Hello @JBailey We checked the rights on MYSQL server: mysql> show grants for 'ract'@'%';
+--------------------------------------------------------------------------------------------------------------+
| Grants for ract@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'ract'@'%' IDENTIFIED BY PASSWORD '*XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec) the % mean any. The connection is working, because if we try to show all the tables we see them, the issue is that in the left @chipican cannot see the tables in the libraries menu, for example: So after use (for example) the code in SAS: libname mydb mysql SERVER='cp-dmz-wps' PORT=23074 DATABASE=ract_RAVE_XXXX_PROD
USER=ract PASSWORD=xxxxxxxxxxxxx
INSERTBUFF=100 DBMAX_TEXT=255 access=readonly; we expected to get in libraries -> mydb to see the tables... @KsharpCan you please inform me about this option? SCHEMA=dbo ? Not familiar with SAS code.
... View more