MySQL Forums
Forum List  »  MySQL Workbench

Re: Can't connect using ssh key
Posted by: phil side
Date: December 07, 2015 06:21AM

The user I'm connecting to was created like this:

mysql> create database fred
mysql> CREATE USER 'fred'@'localhost' IDENTIFIED BY 'xxxx';
mysql> CREATE USER 'fred'@'%' IDENTIFIED BY 'xxx';
mysql> grant all privileges on fred.* to 'fred'@'x';
mysql> grant all privileges on fred.* to 'fred@'%'

I can connect to the datbase from a remote ubuntu machine like this;

mysql --user=fred --host=xx.xx.xx.xx --port=3306 -p

Options: ReplyQuote


Subject
Views
Written By
Posted
1359
December 07, 2015 05:38AM
Re: Can't connect using ssh key
629
December 07, 2015 06:21AM
551
December 08, 2015 01:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.