It sounds like you're having trouble connecting to your Laravel Forge provisioned database using TablePlus. Here's a step-by-step guide to troubleshoot and solve the issue:
-
Verify Credentials: Double-check the username and password you are using. The default username is usually
forge, and the password should be the one you've set or were given when the database was created. -
SSH Key: Since the URL includes
mysql+ssh, it indicates that the connection is over an SSH tunnel. Make sure you have added your local machine's public SSH key to the server's authorized keys through the Forge interface. You can do this under the 'SSH Keys' section of your server's Forge dashboard. -
Private Key in TablePlus: Ensure that you have the correct private key configured in TablePlus. The private key should correspond to the public key you've added to Forge. In TablePlus, you can add the private key by going to the connection's SSH tab and selecting the private key file.
-
Correct Host and Port: The SSH host should be your server's IP address, and the default SSH port is usually 22 unless you've changed it. The database host should be
127.0.0.1and the default MySQL port is 3306. -
Database User Permissions: Make sure the
forgeuser has the necessary permissions for theforgedatabase. You can verify this through the Forge dashboard or by logging into MySQL on your server and checking the user's privileges. -
Firewall Rules: Ensure that your server's firewall (configured through Forge or otherwise) allows connections from your IP address to the SSH and MySQL ports.
-
Manual Connection: Try connecting manually using a MySQL client on your machine with the SSH tunneling feature to ensure that the issue is not with TablePlus. You can use the following command in your terminal:
ssh -L 33060:127.0.0.1:3306 forge@[SERVER_IP] -i /path/to/private/key
Then, in a new terminal window, try connecting to MySQL:
mysql -u forge -p -h 127.0.0.1 -P 33060
If this works, the issue might be with TablePlus configuration.
- TablePlus Connection Settings: In TablePlus, make sure you're using the correct connection settings:
- Name: Any name for your connection
- Type: MySQL (SSH)
- Host: 127.0.0.1
- User: forge
-
Password: The password you've set for the
forgeuser - Database: forge (or your specific database name)
- Port: 3306
- SSH Host: [SERVER_IP]
- SSH User: forge
- SSH Key: Path to your private key
- Update TablePlus: Ensure that you are using the latest version of TablePlus, as updates often fix bugs and improve compatibility.
If you've gone through all these steps and are still facing issues, consider reaching out to Laravel Forge support or the TablePlus support team for further assistance.
