Paul Garth's Projects & Actions

Desired Outcome:

Access MariaDB Database (hosted on IONOS), via SSH, using Command Line, from my Mac Endpoint.

In the past I had written a post about this, which is good as it reminded me of some details regarding saving profiles.

Software application to make connection
-The included terminal application within MacOS should suffice
-I’m using iTerm2, currently have version 3.1.5, and the latest is 3.4.15, which is still good for my relatively older MacOS of Mojave (10.14.6). For now, I’ll stick to my current version.

Find the SSH information
-In my case, my ISP package includes an SSH username, but suggestion is to confirm true before buying a new ISP account.
-Always takes me a while to find this, but within IONOS, Hosting, SFTP & SSH, is a section which tells me my Server name (homexxxxxxxxxx.1and1-data.host) and Main User (uxxxxxxxx). I use this info for making connections via FileZilla (FTP port 22 uploads and downloads) and also for SSH access. Now that I know this, I’ll add it to my systems awareness for working within iTerm2.

Making an SSH Connection within iTerm2
-Run the iTerm2 application
-Note: I need the following: servername; SSH username and SSH password
-ssh homexxxxxxxxxx.1and1-data.host -l uxxxxxxx
-Enter the password for SSH

NOTE: I’m still working on this, but I need to include the “-l” before the username, to make it work.
-Now I have an SSH connection between iTerm2 and IONOS

Connecting in to the MariaDB, hosted by IONOS
-I used this post from IONOS to give me an idea of what’s needed
-I have Web Hosting, so it’s – mysql -u dbo123456789 -h db123456789.db.1and1.com -p db123456789
-Note: That looks like mysql with the database username and the servername and the database name
-It will then prompt for the password, which is the database password (not the SSH password)
-It responded with – MariaDB [dbsxxxxxxx]>
-Note: I confirmed that the database name is correct – I’m using x’s here.
-Now I have accessed the command line of the MariaDB database

The goal is to create a new MariaDB within my ISP hosting (IONOS):

Hosting, Databases, Manage, Create Database
Choice of MariaDB 10 or MySQL 5.7 – I picked MariaDB 10
Note: I’m ideally wanting to install the latest version of MariaDB, so not sure what will actually install. No big deal — I’ll figure out how to check database version.
Enter Description and password.
Note: In the beginning of IONOS (1&1) the database size was 100MB. Now it looks like 2GB — that’s great.
When creating a database, there are a bunch of variables to keep track of, as they’ll be needed later:
-Database description – something that makes sense now and in a couple months
-Host name – dbxxxxxxxxxx.hosting-data.io
-Port – 3306
-Username – dbuxxxxxxx
-Type and version – MariaDB 10
-Storage – 2GB (2147MB)
-Password – – I’ve been using the auto-suggest method lately.

According to the website MariaDB.org, MariaDB is “one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.”

In the past, I’ve installed MariaDB locally on my CentOS or Ubuntu servers, but didn’t go much further. Now, my ISP (IONOS) offers ability to create MariaDB Databases hosted within their cloud. Here goes creating, accessing and learning more about the system. There could be connections to Apache websites and Python programming. I’ll cross-reference to past posts I wrote, as needed.

I always start by first going to the source website to review documentation high-level. This can set in some overwhelm, so I remember the GTD maxim to focus just on “the Next Action”. One thing I notice, as of 20220116 is the version is 10.6.5. Within IONOS they were only saying version 10, so first thing after installing the database is to check the version.