MySQL Credential - Database Connection

What is a MySQL Credential

A MySQL credential allows your workflows to execute SQL queries, read and write data in MySQL and MariaDB databases. It is used with SQL query nodes.

---

Configuration Fields

Field	Description	Example
Host	Database server address	db.example.com or localhost
User	Database username	root
Password	User password	my_password
Database	Database name	my_database
Port	Connection port (default: 3306)	3306

---

How to Get Connection Details

Local Database (XAMPP, WAMP, MAMP)

Host: localhost or 127.0.0.1
Port: 3306
User: root
Password: (empty by default in XAMPP, or what you configured)
Database: your database name

Shared Hosting (cPanel)

1. Access cPanel
2. Go to MySQL Databases
3. Create a database and user if they don’t exist
4. Assign the user to the database with the necessary permissions
5. The host is usually localhost or shown in the database details

Cloud Services

Amazon RDS (MySQL):

1. Go to AWS Console > RDS > Your instance
2. Copy the Endpoint
3. Default port: 3306

PlanetScale:

1. Go to your database on planetscale.com
2. Click Connect
3. Copy the connection details

DigitalOcean Managed Database:

1. Go to your database cluster
2. Download or copy the connection parameters

---

Troubleshooting

Connection Error

• Verify the host and port are correct
• Make sure MySQL accepts remote connections (check bind-address in my.cnf)
• Check that the firewall allows connections to port 3306

Access Denied

• Verify username and password
• Make sure the user has permission to connect from the Floogos host
• In MySQL you can check with: SELECT user, host FROM mysql.user;

Database Not Found

• Verify the database name is correct (case-sensitive on Linux)
• Make sure the database exists: SHOW DATABASES;