Connecting MySQL

📋 Preparing MySQL

Before connecting DBDash to MySQL, make sure the following prerequisites are in place:

• MySQL is installed and running on your local machine or a remote server.
• Ensure your MySQL user has sufficient privileges to access the database (e.g., SELECT, INSERT, UPDATE, DELETE).
• Confirm that the MySQL server’s port (default: 3306) is open and accessible.

You can verify the MySQL server is running by connecting to it via the command line:

mysql -u root -p

✅ If you can connect without issues, you're ready to proceed.

🔗 Configure MySQL Connection

Now, let’s configure the connection in DBDash. To do this, follow these steps:

1. Open the DBDash Web UI in your browser at http://localhost:3000.
2. On the login screen, click on the "Add New Connection" button.
3. In the connection settings form, fill in the following fields:
   • Host: The IP address or hostname of your MySQL server (e.g., localhost for local setup or the IP address of a remote server).
   • Port: Default is 3306. If you are using a custom port, enter that.
   • User: The MySQL username you want to use (e.g., root or another user).
   • Password: The corresponding password for the MySQL user.
   • Database (optional): You can specify a database here or leave it blank to connect to the MySQL server and view all databases.
4. Click "Save" to store the connection settings.

After saving, you will be able to see your connection listed on the dashboard.

⚠️ Troubleshooting Connection Issues

If you're having trouble connecting to MySQL, check the following:

• If you see a "Connection Refused" error, make sure MySQL is running and listening on the correct port.
• If you’re connecting remotely, ensure that your firewall or cloud security settings allow inbound connections on port 3306.
• Check that the MySQL user you're using has the necessary permissions and that the username/password is correct.

If the issue persists, check the MySQL logs or refer to the Troubleshooting guide for more detailed solutions.