I can't access mysql through terminal on fortrabbit. I follow all steps but it is rejecting my password. However I can regullary login through ssh and edit my application. Anyone had that issue ? Thanks.
can't access fortrabbit mysql db through terminal (ssh)
1.6k views Asked by Miroslav Trninic At
1
There are 1 answers
Related Questions in MYSQL
- How to Retrieve Data from an MySQL Database and Display it in a GUI?
- How to change woocomerce or full wordpress currency with value from USD to AUD
- window.location.href redirects but is causing problems on the webpage
- Error: local variable 'bramka' referenced before assignment
- Products aren't displayed after fetching data from mysql db (node.js & express)
- status table for all entries (even in different dates) in database changing value when all checkboxes are checked
- Can't Fix Mariadb & Mysql ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2) On MacOs
- Express Mysql getting max ID from table not working cought in a promise
- failed to upload a table from sql file
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- How to display the column names which have only unique non-null values in MySQL table?
- mysql query takes too long because of wrong indexes usage
- Multitable joining in Sql
Related Questions in SSH
- Is there a way to prevent vscode from forwarding ssh agent to remote dev container?
- problem to push files on a repository git
- How to connect to ssh server with domain name
- GIT SKIP EMPTY DIRECTORIES
- Share files from the server without data or internet usage
- Is it possible for `sudo` to fail temporarily with the correct password? Hacking suspected
- How to add a second ssh public key to authorized_keys file in the server?
- Termux: Different scrolling behaviour after "screen"-command
- Remote debugging via SSH Tunnel
- Why can I not login to a new linux system (amazon linux 2023) from an old one (CentOS 6)
- Can't establish ssh connection to IP address but can to git
- Using Maven to feed minikube on a VM
- Connect ssh to cisco switch with ansible
- PowerShell Command via SSH
- How to automate an SSH login with a batch file?
Related Questions in LARAVEL
- Function in anonymous Laravel Blade component
- Composer installation fails and reverts ./composer.json and ./composer.lock to original content
- Laravel: Using belongsToMany relationship with MongoDB
- Laravel's whereBetween method not working with two timestamps
- Implementing UUID as primary key in Laravel intermediate table
- Resolving ElephantIO ServerConnectionFailureException: Error establishing connection to server
- Undefined function getAdminPanelUrlPrefix()'error in Laravel SaaS project after installing chatmessenger
- PHP Laravel SQLServer could not find driver
- Laravel installation via Composer results in connection timeout error
- Is there a way of showing content in a Statamic antlers template if a user is authenticated?
- Livewire component JS script Uncaught SyntaxError: Unexpected token
- is there a solution to run cron job command in cpanel only from my cPanel host?
- Prevent a webpage from navigating away
- Deploy Flutter and Laravel php mobile app on the host server
- Please how I fetch user account balance, withdrawals, Loans and Transactions to display in the dashboard?
Related Questions in FORTRABBIT
- Laravel Impersonate works locally, but not on production server
- Add npm run build to Fortrabbit deploy process
- Which unsupported characters exist for the dotenv file?
- Git push to Fortrabbit fails: No space left on device
- Undefined index: driver for Laravel 5 deploy
- git clone - user generated content missing
- Laravel (or server?) is redirecting (only) one route to http
- The only supported ciphers - Laravel hosting on Fortrabbit
- How can I change this php.ini setting when hosting a website with fortrabbit.com?
- Fortrabbit deployment error on push
- Errors while uploading Laravel project to fortrabbit
- How to deploy npm packages on fortrabbit, just like composer?
- Laravel S3 Image upload returning 503 error on FortRabbit
- fortrabbit files laravel 5.2
- Redirect Loop Laravel 5.1 in Fortrabbit
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I have solved this in the past using a SSH tunnel. You open an SSH tunnel to the server, and then you connect to the MySQL server there from the endpoint of that tunnel. As such, to MySQL you appear to be connecting locally.
From the terminal:
First you need to open the tunnel, you can do it like this:
This opens port 8889, then opens a tunnel to
your.fortrabbit.domain.com, then forwards that local port through the tunnel to the IP 127.0.0.1 and port 3306 relative to the server atyour.fortrabbit.domain.com.The options in more detail:
-N: Do not execute a remote command.-L: Specifies the ports (local and remote).8889: Your local port that is being forwarded.127.0.0.1: the remote IP to which you're forwarding, relative to the server which ssh is connecting to3306: the remote port to which you're forwarding.[email protected]: Your username and domain with fortrabbit.Now you're ready to open the connection. In the same terminal, use the following command:
port 8889 is now being forwarded to the port and IP of your MySQL server on the fortrabbit side, so just replace
mysql-usernamewith your username on the mysql server, and you're connected!From a GUI:
You mentioned in your comments that you're using Ubuntu, so install MySQL Workbench from the Software Centre or here, create a
New Connectionand select the connection type as "Standard TCP/IP over SSH".You will need to configure the following:
SSH Hostname: the hostname or IP of your ssh account with fortrabbitSSH Username: your username with themSSH Password: your password with themSSH Keyfile: If you use keys for authentication, select the private one here.MySQL Hostname: 127.0.0.1 (because it's local to the endpoint of your tunnel.MySQL Server Port: normally "3306".Username: The username for the DBPassword: The password for the DBDefault Schema: Whatever should be the default schema for this DB (can be left blank).That should then connect from wherever you are!