MySQL/MariaDB Connection

About MySQL

The MySQL® database has become the world’s most popular open-source database because of its consistently fast performance, high reliability and ease of use. It’s used on every continent – Yes, even Antarctica! – by individual Web developers as well as many of the world’s largest and fastest-growing organizations to save time and money powering their high-volume Web sites, business-critical systems and packaged software – including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, and Zappos.com.

About MariaDB

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation. Contributors are required to share their copyright with the MariaDB Foundation.

Source: Wikipedia

Connection

Comments

User fields

Creating New Connection

• In the Name Text Box type in a new name for the connection you are about to create
• Type in the hostname
• Select a Database name from the drop-down List
• Select the appropriate connection port default is 3306
• Fill in the Username/Password for the database you wish to connect to
• Fill in SSL/SSH connection details if necessary
• Click Test Connection to ensure the details you have provided are correct
• Click OK to close the connection properties window

Video Tutorials

Used by

1. MySQL Reader
2. MySQL Writer
3. Database Loop Action
4. Sql Script Action
5. Sql Data Check Action
6. Check Connection Action
7. SQL To Text Dynamic Action
8. SQL To XML Dynamic Action
9. SQL To Insert Dynamic Action
10. SQL To Excel Dynamic Action
11. SQL To QVD Dynamic Action
12. SQL To QVX Dynamic Action
13. Select Value Action
14. SQL Record to Variables Action
15. SQL to Variables Action