meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
applications:connect:macsql [2023/01/12 23:58] – joetulenko | applications:connect:macsql [2023/02/13 21:34] (current) – gregbalco | ||
---|---|---|---|
Line 3: | Line 3: | ||
The first thing is a MySQL client. The free version of TablePlus ([[https:// | The first thing is a MySQL client. The free version of TablePlus ([[https:// | ||
- | **Note:** Previous users who used the Sequel Pro program | + | **Note:** Previous users who used the Sequel Pro MySQL client |
If you have a Mac or Linux machine, SSH is already installed (Mac) or most likely already installed (Linux), so you just have to generate the key pair. | If you have a Mac or Linux machine, SSH is already installed (Mac) or most likely already installed (Linux), so you just have to generate the key pair. | ||
Line 11: | Line 11: | ||
'' | '' | ||
- | Hit return to accept the default file location. Then hit return again to store it without a passphrase (usually | + | Hit return to accept the default file location. Then hit return again to store it without a passphrase (typically |
Now type the following: | Now type the following: | ||
Line 17: | Line 17: | ||
'' | '' | ||
- | This will spit back a long code string with ' | + | This will spit back a long code string with ' |
- | Now that we've dealt with SSH keys, open Sequel Pro to connect to the database. | + | Once Greg or Joe has installed your SSH key, open TablePlus (or whatever client -- all MySQL clients should behave fairly similarly) |
- | {{:pluginto:sequel1.png?400|}} | + | {{:applications:connect: |
- | You will need to ask an administrator (= Greg) for (i) the correct IP address to enter in the 'MySQL Host" field and (ii) the correct host name for the "SSH Host" field. The " | + | If you don't see the lower half of the window, click 'over SSH' |
- | Now try either ' | + | Starting with the upper half (MySQL), you will need to enter something in ' |
+ | |||
+ | For the lower half, you will need to enter something for ' | ||
+ | |||
+ | Click ' | ||