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 best solutions below
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in SSH
- Mule 3.6 Custom Java Class
- Permission denied hg-git
- Is it possible to clone a private git repo without adding ssh keys
- How can I figure out which process is opening the certain tcp port?
- Working on two different Git Organization repos using two different credentials in proxy mode
- SShpass not allowed with Travis CI
- vi/fugitive: Gpush does not exit... sometimes
- Prevent Linux user from connecting with WinSCP
- Expect Script through Putty works but not when called by scripts executed via http
- Vagrant : Create new user and force the use of ssh keys for accessing the server
- Trouble Connecting to MySQL via SSH
- Error in executing a Jar file in remote machine
- Workbench migration via ssh - how to set up a tunnel
- Program running non-stop in ssh
- How to Stop Node.js on Ubuntu and log out without stopping
Related Questions in LARAVEL
- Attempting to bind Guzzle Curl Client to Laravel's Service Container -- then Type Hint the Client Fails when attempting to __construct()
- Can not access the 3rd table in laravel 5 in 3 tables have relationships
- No laravel sync folders in homestead vagrant on windows
- How to use where date(timeline) in Laravel Query Builder
- Laravel Eloquent "Many-to-Many-to-One ?"
- Laravel: Locale Session: Controller gets Parameter to change it but it cant. U have to hardcode it
- Stopping an infinite loop process in vagrant
- Insert multiple rows in Laravel
- laravel full-text search with multiple keywords together
- Laravel : Saving a belongsToMany relationship
- Add a Controller to a Laravel 5 Package
- Laravel. Eloquent query for two tables
- Add readonly attribute in form model binding only when editing in laravel 5
- Laravel firstOrNew how to check if it's first or new?
- How to show variable in view blade.php page using laravel paginator::make
Related Questions in FORTRABBIT
- Multiple alias in one account
- Importing mysql dump
- 'image upload' not writing to MySql database or public folder with Laravel 4.1 (with Croppa) on Fortrabbit
- Fortrabbit: How to set composer install as default method?
- Avoid the ImageNotWritableException in Fortrabbit using Intervention
- How do I access my js files in fortrabbit
- Multiple databases with one Fortrabbit app using Laravel 4.1 and mysql
- can't access fortrabbit mysql db through terminal (ssh)
- Fortrabbit deployment error with github
- Laravel Impersonate works locally, but not on production server
- Laravel-4 and phpmyadmin installation in fortrabbit
- How to install wkhtmltopdf on fortrabbit?
- Fortrabbit Worker + IronMq + Symfony2
- Cloning a fortrabbit app to another fortrabbit account without its dashboard/git credentials
- 'ssh' is not recognized as an internal or external command
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)
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?
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!