This article will guide you on steps to use #Redis to cache #MySQL data with #PHP on #Ubuntu 20.04. Redis, which stands for Remote Dictionary Server, is a fast, open-source, in-memory key-value data store for use as a database, cache, message broker, and queue.
To Connect to Redis through the SQL Gateway:
1. In MySQL Workbench, click to add a new MySQL connection.
2. Name the connection (CData SQL Gateway for Redis).
3. Set the Hostname, Port, and Username parameters to connect to the #SQL Gateway.
4. Click Store in Vault to set and store the password.